power-builder.blogspot.com
Sitemap - PowerBuilder Tips & Tricks
http://power-builder.blogspot.com/2008/01/sitemap.html
PowerBuilder Tips and Tricks. Advanced PowerBuilder Tips and Tricks Programming, that I copied from books, website, blog, literature, and other resources. If Statements Using SQL. Run an Application Only Once. Registering OCX Components in an Exe. Get The Name of a Network Drive. Mapping a Network Drive. Sending Hexadecimal Character to Printer. Calling an Internet Browser from Application. Getting Date Format from Windows Registry. Return Code on Application Exit. Oracle Tips and Tricks.
oracletipstricks.blogspot.com
Using rsync to Copy Oracle Home Directories | oracle tips & tricks
http://oracletipstricks.blogspot.com/2008/03/using-rsync-to-copy-oracle-home.html
Oracle Tips and Tricks. Monday, 10 March 2008. Using rsync to Copy Oracle Home Directories. If you're using UNIX for your ORACLE database server, it is possible to copy the Oracle Database Software (the Oracle Home directory) from one server to another using rsync. Root@svr1 ]# rsync -auvzpogl -e ssh /u01/app/oracle/product/10.2.0/db 1/ svr2:/u01/app/oracle/product/10.2.0/db 1/. Posted by popo @ 23:17. Enter your search terms. Sending E-Mail in PL/SQL. Another Oracle apps DBA Interview Questions (with .
oracletipstricks.blogspot.com
oracle tips & tricks
http://oracletipstricks.blogspot.com/2008_01_01_archive.html
Oracle Tips and Tricks. Sunday, 27 January 2008. Getting Table Details with SQL*Plus. You can use SQL*Plus to provide the following details about a table:. Other Tables That REFER to this Table. Use the following code in SQL*Plus to provide this information:. COLUMN COMMENTS FORMAT A50. COLUMN column name FORMAT A35. COLUMN Data Type FORMAT A15. COLUMN DATA DEFAULT FORMAT A20. COLUMN "PK Column" FORMAT A35. COLUMN "FK Column" FORMAT A20. ACCEPT Owner PROMPT 'Enter Owner :'. FROM ALL TAB COMMENTS. WHERE C...
oracletipstricks.blogspot.com
oracle tips & tricks
http://oracletipstricks.blogspot.com/2008_02_01_archive.html
Oracle Tips and Tricks. Tuesday, 19 February 2008. Another Oracle apps DBA Interview Questions (with answer). What happens if the ICM goes down? How will you speed up the patching process? How will you handle an error during patching? Provide a high-level overview of the cloning process and post-clone manual steps. Provide an introduction to AutoConfig. How does AutoConfig know which value from the XML file needs to be put in which file? Which profile options and files will you check? Run pre-clone on th...
oracletipstricks.blogspot.com
Database Link From Oracle to SQL Server | oracle tips & tricks
http://oracletipstricks.blogspot.com/2008/04/database-link-from-oracle-to-sql-server.html
Oracle Tips and Tricks. Thursday, 24 April 2008. Database Link From Oracle to SQL Server. After you succeed connecting Oracle with SQL Server. Probably you want to create database link between it. Oracle heterogeneous services allow you to define a database link between Oracle and SQL Server, as well as links to DB2 and other inferior databases. Here are complete notes in creating a database link between Oracle and SQL Server. 4 Ensure that your global names parameter is set to False. SID LIST LISTENER =.
oracletipstricks.blogspot.com
oracle tips & tricks
http://oracletipstricks.blogspot.com/2007_09_01_archive.html
Oracle Tips and Tricks. Wednesday, 19 September 2007. Get IP Address and Hostname. There are legitimate times when you want your procedural code to gather the current host name or IP address and Oracle has several ways to do this:. The utl inaddr procedure. SQL select utl inaddr.get host address('www.detik.com'). 2 hostname from dual;. The sys context procedure. SQL select SYS CONTEXT('USERENV', 'IP ADDRESS', 15) ipaddr from dual;. Posted by popo @ 20:51. Tuesday, 18 September 2007. SELECT * FROM table.
oracletipstricks.blogspot.com
Five DBA Best Practices | oracle tips & tricks
http://oracletipstricks.blogspot.com/2008/02/five-dba-best-practices.html
Oracle Tips and Tricks. Tuesday, 19 February 2008. Five DBA Best Practices. My favorite best practice is the one about multiple Oracle Homes. Here it how it goes. When applying a patch or a patchset, I recommend against applying to the existing Oracle Home. Instead, I suggest creating a new Oracle Home, and apply the patches there. So, here is the conventional approach:. 1 Shut down the database. 2 Apply patch to the Oracle Home. 3 Start the database. 4 In case of problems:. 5 Shut down the database.
oracletipstricks.blogspot.com
Computing date differences | oracle tips & tricks
http://oracletipstricks.blogspot.com/2008/04/computing-date-differences.html
Oracle Tips and Tricks. Tuesday, 22 April 2008. One of the confounding problems with Oracle DATE datatypes is the computation of elapsed time. Oracle supports date arithmetic and you can make expressions like "date1 - date2" to get the difference between the two dates. Once you have the date difference, you can use simple techniques to express the difference in days, hours, minutes or seconds. Round(to number(end-date-start date) â elapsed days. Round(to number(end-date-start date)*24)â elapsed hours.
oracletipstricks.blogspot.com
Another Oracle apps DBA Interview Questions (with answer) | oracle tips & tricks
http://oracletipstricks.blogspot.com/2008/02/another-oracle-apps-dba-interview.html
Oracle Tips and Tricks. Tuesday, 19 February 2008. Another Oracle apps DBA Interview Questions (with answer). What happens if the ICM goes down? How will you speed up the patching process? How will you handle an error during patching? Provide a high-level overview of the cloning process and post-clone manual steps. Provide an introduction to AutoConfig. How does AutoConfig know which value from the XML file needs to be put in which file? Which profile options and files will you check? Run pre-clone on th...
