Monday, June 13, 2011

Mini user guide to SQL * Plus Oracle SQL * Plus programming examples

Now you are in SQL * Plus and to start the SQL * Plus commands */SQL STATEMENT select * from employee > * Example of sqlplus command */SQL > help, contact your oracle-identifies with your-new-password; * Change password * input and output files for Oracle sqlplus to save a copy of the session or part of the session: SQL > Set of humanitarian aid; * shows the SQL code with the results of the query */SQL > spool; * the name will be added with. 1st if postfix is not provided * SQL > spool; /* will be shut down for transcript. Now you can print a file with the instructions given below */read file: SQL > home; or SQL > @; where the name of the file must be opred file ending with .SQL (sql may or may not be made available to Oracle, but must be part of the name of the file). Stamp of the Oracle results for print Sun or IBM users can say: lpr-P printer_names (2340eecss2, 2341eecsh1, 4327eecss1, 4327eecss2, 4440eecss1, 4440eecsm1) HP: lp-d access from any ...


Website: www.eecs.umich.edu | File size: 29 kb
Number of pages: 11
Download Mini user guide to SQL * Plus Oracle SQL * Plus pdf Programming Examples.


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.