hagoodc.wordpress.com
Manage your SQL Plus Window | An Oracle Guy's ColdFusion
https://hagoodc.wordpress.com/2014/03/26/manage-your-sql-plus-window/comment-page-1
An Oracle Guy's ColdFusion. Manage your SQL Plus Window. Posted by Chris Hagood. On March 26, 2014. Update your glogin.sql file to contain the code below to automatically modify your sql plus window to reflect database environment and logged in user. My glogin.sql file is located in the following directory:. C: oracle Ora11gR2x64 product 11.2.0 client 1 sqlplus admin. Larr; An updated sqlprompt script. Comparing lists in Oracle →. One response to “. Manage your SQL Plus Window. March 26, 2014 at 3:16 pm.
hagoodc.wordpress.com
An updated sqlprompt script | An Oracle Guy's ColdFusion
https://hagoodc.wordpress.com/2014/03/12/an-updated-sqlprompt-script
An Oracle Guy's ColdFusion. An updated sqlprompt script. Posted by Chris Hagood. On March 12, 2014. Basically, the meat of this post is this command (in sql plus):. Set sqlprompt " user '@' connect identifier ". You can also update your glogin.sql file to contain the command above. My glogin.sql file is located in the following directory:. ORACLE HOME product 11.2.0 client 1 sqlplus admin. Larr; CFStoredProc When Oracle and CF stop talking…. Manage your SQL Plus Window →. Leave a Reply Cancel reply.
hagoodc.wordpress.com
Chris Hagood | An Oracle Guy's ColdFusion
https://hagoodc.wordpress.com/author/hagoodc
An Oracle Guy's ColdFusion. Oracle Scheduler – Repeat Interval. Posted by Chris Hagood. On October 23, 2014. Oracle’s scheduler offers a great deal of flexibility regarding when a particular job will run. While I like the functionality, I don’t use it often enough to remember off the top of my head the specific variations. The following are for the “repeat interval” attribute in the scheduler. All based on the start date of the job). Mon-Thur, 5 past the hours of 9am, 11am, 1pm, 3pm. The next half hour.
hagoodc.wordpress.com
The next half hour | An Oracle Guy's ColdFusion
https://hagoodc.wordpress.com/2014/04/02/the-next-half-hour
An Oracle Guy's ColdFusion. The next half hour. Posted by Chris Hagood. On April 2, 2014. I have a job in Oracle that runs every 30 minutes (during work hours), and wanted to schedule the first run at the next “xx:30” mark on the clock. Nothing all that exciting, but took me a few minutes to figure out the logic and I thought I would share. Line of interest from my call to the scheduler:. Start date = CEIL( (SYSDATE - trunc(SYSDATE) * 48 )/ 48 trunc( SYSDATE ). Basic demonstration of the calculation:.
hagoodc.wordpress.com
An Oracle Guy's ColdFusion | Page 2
https://hagoodc.wordpress.com/page/2
An Oracle Guy's ColdFusion. Query to delete duplicate rows…. Posted by Chris Hagood. On November 4, 2013. First: I didn’t come up with this technique. I found it on the AskTom ( http:/ asktom.oracle.com/. Web site. That being said, I use it all the time and refer others to the technique often. Link to where I got it from: http:/ asktom.oracle.com/pls/apex/f? P=100:11:0: : P11 QUESTION ID:15258974323143. If you have more columns, just add them into the partition area of the query. Posted by Chris Hagood.
hagoodc.wordpress.com
Manage your SQL Plus Window | An Oracle Guy's ColdFusion
https://hagoodc.wordpress.com/2014/03/26/manage-your-sql-plus-window
An Oracle Guy's ColdFusion. Manage your SQL Plus Window. Posted by Chris Hagood. On March 26, 2014. Update your glogin.sql file to contain the code below to automatically modify your sql plus window to reflect database environment and logged in user. My glogin.sql file is located in the following directory:. C: oracle Ora11gR2x64 product 11.2.0 client 1 sqlplus admin. Larr; An updated sqlprompt script. Comparing lists in Oracle →. One response to “. Manage your SQL Plus Window. March 26, 2014 at 3:16 pm.
hagoodc.wordpress.com
Knowledge | An Oracle Guy's ColdFusion
https://hagoodc.wordpress.com/2013/11/28/knowledge
An Oracle Guy's ColdFusion. Posted by Chris Hagood. On November 28, 2013. One of my favorite and most trusted sites for Oracle information is AskTom ( http:/ asktom.oracle.com/. One of my favorite quotes I have read at least a hundred times is “I learn something new about Oracle every day”. I wouldn’t say I learn something new every day, but this has been one of the more fruitful weeks in this regard. Larr; One in a million. CFStoredProc When Oracle and CF stop talking… →. Leave a Reply Cancel reply.
hagoodc.wordpress.com
Oracle Scheduler – Repeat Interval | An Oracle Guy's ColdFusion
https://hagoodc.wordpress.com/2014/10/23/oracle-scheduler-repeat-interval
An Oracle Guy's ColdFusion. Oracle Scheduler – Repeat Interval. Posted by Chris Hagood. On October 23, 2014. Oracle’s scheduler offers a great deal of flexibility regarding when a particular job will run. While I like the functionality, I don’t use it often enough to remember off the top of my head the specific variations. The following are for the “repeat interval” attribute in the scheduler. All based on the start date of the job). Mon-Thur, 5 past the hours of 9am, 11am, 1pm, 3pm. You are commenting u...
hagoodc.wordpress.com
One in a million | An Oracle Guy's ColdFusion
https://hagoodc.wordpress.com/2013/11/26/one-in-a-million
An Oracle Guy's ColdFusion. One in a million. Posted by Chris Hagood. On November 26, 2013. How many times have you been creating or migrating data and have everything fail because of one stinkin’ record? Can you deal with it? Wouldn’t it be nice if you could basically say “Hey Oracle… I am going to insert a bunch of records. A few might not be valid, but please insert the rest and just let me know which ones failed. Please….”. Since I prefer to show and then explain…. When you tell Oracle to set up logg...
SOCIAL ENGAGEMENT