Tag Archives | sql

Oracle 11g SQL Error Logging

We’re working on the installation scripts for an internal PL/SQL applications. Multiple scripts are called from the main one. To capture errors from script execution, normally the spool syntax will be used in the scripts to pipe out all executions into log files, and then later the deployment team members will examine them using find/search […]

Continue Reading 5

Book Review: Oracle SQL Developer 2.1 by Sue Harper

I must admit that I rarely use the Oracle SQL Developer because I’m using SQL*Plus, Toad from Quest and PL/SQL Developer from Allround Automations as primary tools for database administration and PL/SQL programming. They’re already providing all functionalities I need. I have nothing against Oracle SQL Developer. Actually it is quite opposite. I really want […]

Continue Reading 1

SQL and PL/SQL reserved words

I found this tip from forum discussing about Oracle’s reserved words. You can use it to quickly view reserved words for both SQL and PL/SQL. SQL> help reserved RESERVED WORDS (PL/SQL) ———————– PL/SQL Reserved Words have special meaning in PL/SQL, and may not be used for identifier names (unless enclosed in “quotes”). An asterisk (*) […]

Continue Reading 4

Powered by WordPress. Designed by WooThemes