In Feburary 2016 27,
Sign in to SQLPlus.
Type a 'select' command using the 'replace' function and press 'enter':select string_column, replace(string_column, 'co.', 'company') from string_table;This command retrieves the 'string_column' twice so that the user can see a before-and-after representation of the data. In this case, 'co.' is the target and 'company' is the replacement.
Inspect the results to see the replacement. If the 'string column' contained 'abc co.', it should now be converted to 'abc company.'
Translate Function
Sign in to SQLPlus.
Type a 'select' command using the 'translate' function and press 'enter':select string_column, translate(string_column, 'abc', 'xyz') from string_table;This command retrieves the 'string_column' twice so that the user can see a before-and-after representation of the data. The phrase 'abc' is the 'fromlist', and 'xyz' is the 'tolist.'
Inspect the results to see the replacement. If 'string column' contained 'abc co.', it is converted to 'xyz zo.'
In Feburary 2016 27,
Showing posts with label case. Show all posts
Showing posts with label case. Show all posts
Saturday, 27 February 2016
Saturday, 13 February 2016
How to Upload My Web Site From Dreamweaver to BluehostIn Feburary 2016 13,
In Feburary 2016 13,
Open Dreamweaver. Click 'Site' from the menu at the top of the screen. Select 'Manage Sites' from the drop-down selections. Then, select 'New Site.' Select the 'Advanced' tab.
Enter your site's name in the 'Site name' field. Select the location of your site for the 'Local root folder' by clicking on the folder icon next to the field. Your local root folder will be the location on your computer where you saved the website files you created to upload to Bluehost. Navigate to the folder of those saved files. For the 'Default images folder' field, click on the folder icon next to the field to select the location of your site's image folder. Your image folder will be a sub-folder of the location where you saved the website files you created.
Type the entire URL for your website in the 'HTTP address' field. Check the 'Case-sensitive links' box. (Bluehost files and folders are case-sensitive.) Click the 'Remote Info' category in the menu list on the left-hand side of the dialog in the 'Category' area.
Select the FTP option from the 'Access' drop-down menu. Enter your domain name in the 'FTP host' field in the format yourdomain.com.
Type '/public_html' (without quotes) in the 'Host directory:' field. If you are publishing a site to an add-on domain, type '/public_html/addon' in the field. An add-on domain is a new domain that you have added to your Bluehost account. The domain that you listed when you set up your Bluehost web hosting account is your primary domain.
Type your FTP username and password in the corresponding fields. Your cPanel username and password are identical to your FTP username and password. The cPanel is your web hosting control panel. You will see a link to it when you sign in to your account at Bluehost.com. You received the username and password via email when you signed up for Bluehost. If you created an additional FTP account for other users, the username will be in the format username@yourdomain.com. Click the 'Test' button to check settings. If you receive the error message 'An FTP error occured - cannot make connection to host', double-check that you have typed your FTP information correctly.
Check the 'Maintain synchronization information' box. Click the 'OK' button. Click the 'Done' button.
Connecting To The Web Server Using Dreamweaver
Click the 'Connect to Remote Host button,' which is the first icon in the Files panel in Dreamweaver. The program will retrieve information from your website and show the file listings in the Files panel. Make sure you are viewing the Files panel in expanded mode so you can see your local files and the server files in windows next to each other. Clicking on the very last icon at the right in the Files panel toggles the view.
Select 'Local view' from the top right-hand drop-down menu in the Files panel. Your local files will be on the left side of the panel and your remote web server files on the right.
Select all of the files on the local side by clicking and dragging your mouse over them. You can drag and drop files from the local side to the remote side, or you can click the 'Put files' button, which is a blue arrow icon pointing upwards, to transfer the files. Once you have transferred your files, your site is uploaded.
Go to your website's URL to check your work.
In Feburary 2016 13,
Open Dreamweaver. Click 'Site' from the menu at the top of the screen. Select 'Manage Sites' from the drop-down selections. Then, select 'New Site.' Select the 'Advanced' tab.
Enter your site's name in the 'Site name' field. Select the location of your site for the 'Local root folder' by clicking on the folder icon next to the field. Your local root folder will be the location on your computer where you saved the website files you created to upload to Bluehost. Navigate to the folder of those saved files. For the 'Default images folder' field, click on the folder icon next to the field to select the location of your site's image folder. Your image folder will be a sub-folder of the location where you saved the website files you created.
Type the entire URL for your website in the 'HTTP address' field. Check the 'Case-sensitive links' box. (Bluehost files and folders are case-sensitive.) Click the 'Remote Info' category in the menu list on the left-hand side of the dialog in the 'Category' area.
Select the FTP option from the 'Access' drop-down menu. Enter your domain name in the 'FTP host' field in the format yourdomain.com.
Type '/public_html' (without quotes) in the 'Host directory:' field. If you are publishing a site to an add-on domain, type '/public_html/addon' in the field. An add-on domain is a new domain that you have added to your Bluehost account. The domain that you listed when you set up your Bluehost web hosting account is your primary domain.
Type your FTP username and password in the corresponding fields. Your cPanel username and password are identical to your FTP username and password. The cPanel is your web hosting control panel. You will see a link to it when you sign in to your account at Bluehost.com. You received the username and password via email when you signed up for Bluehost. If you created an additional FTP account for other users, the username will be in the format username@yourdomain.com. Click the 'Test' button to check settings. If you receive the error message 'An FTP error occured - cannot make connection to host', double-check that you have typed your FTP information correctly.
Check the 'Maintain synchronization information' box. Click the 'OK' button. Click the 'Done' button.
Connecting To The Web Server Using Dreamweaver
Click the 'Connect to Remote Host button,' which is the first icon in the Files panel in Dreamweaver. The program will retrieve information from your website and show the file listings in the Files panel. Make sure you are viewing the Files panel in expanded mode so you can see your local files and the server files in windows next to each other. Clicking on the very last icon at the right in the Files panel toggles the view.
Select 'Local view' from the top right-hand drop-down menu in the Files panel. Your local files will be on the left side of the panel and your remote web server files on the right.
Select all of the files on the local side by clicking and dragging your mouse over them. You can drag and drop files from the local side to the remote side, or you can click the 'Put files' button, which is a blue arrow icon pointing upwards, to transfer the files. Once you have transferred your files, your site is uploaded.
Go to your website's URL to check your work.
In Feburary 2016 13,
Friday, 5 February 2016
How to Delete WebsitesIn Feburary 2016 05,
In Feburary 2016 05,
Delete the website files on a UNIX server by using Telnet to access the top directory of the files that make up your website. Enter the UNIX command rm --r [directory] where directory is the name of the parent directory. This will delete all the sub-directories under the website at once. If the parent directory is still there, change to a higher level directory by entering cd followed by to periods. Then type rmdir [directory] where directory is the name of the parent.
Use an FTP program like WS_FTP to access the website files. With this method you will have to work from the bottom up, deleting files in sub-directories and then parent directories, so it is more cumbersome and in the case of a complicated website, can take quite a while.
Delete a website using Adobe Dreamweaver by clicking on 'Site,' then 'Manage Sites.' Highlight the website to be removed and click on 'Remove.' Confirm the action when asked. Microsoft Expression should have a similar function.
Check with the Web host to see if they have a file management system where the user can remove web files directly. You may be able to direct them to remove the website for you with the appropriate authorization. Alternatively, cancel the hosting plan. When you stop paying for the website, the Web hosting company will remove the website for you. Not renewing the domain name when it is due would accomplish the same thing.
Disable a website temporarily by changing the name of the index.html file to something else like index.old. Since most links to a website start at the index.html or index.htm page, even though this isn't typed in the URL box, this will effectively remove the website from access. This won't work if the starting page of the website does not have index.html or index.htm page.
In Feburary 2016 05,
Delete the website files on a UNIX server by using Telnet to access the top directory of the files that make up your website. Enter the UNIX command rm --r [directory] where directory is the name of the parent directory. This will delete all the sub-directories under the website at once. If the parent directory is still there, change to a higher level directory by entering cd followed by to periods. Then type rmdir [directory] where directory is the name of the parent.
Use an FTP program like WS_FTP to access the website files. With this method you will have to work from the bottom up, deleting files in sub-directories and then parent directories, so it is more cumbersome and in the case of a complicated website, can take quite a while.
Delete a website using Adobe Dreamweaver by clicking on 'Site,' then 'Manage Sites.' Highlight the website to be removed and click on 'Remove.' Confirm the action when asked. Microsoft Expression should have a similar function.
Check with the Web host to see if they have a file management system where the user can remove web files directly. You may be able to direct them to remove the website for you with the appropriate authorization. Alternatively, cancel the hosting plan. When you stop paying for the website, the Web hosting company will remove the website for you. Not renewing the domain name when it is due would accomplish the same thing.
Disable a website temporarily by changing the name of the index.html file to something else like index.old. Since most links to a website start at the index.html or index.htm page, even though this isn't typed in the URL box, this will effectively remove the website from access. This won't work if the starting page of the website does not have index.html or index.htm page.
In Feburary 2016 05,
Subscribe to:
Comments (Atom)