Acrobat X Files

Home > Programming > Oracle Programming

Mini User's Guide for SQL*Plus Oracle SQL*Plus Programming Examples

Sort Desciption:

prompt) by doing a. "telnet @engin.umich.edu". Note: use "telnet hostinfo" to see a selection of free nodes. Oracle SQL*Plus Programming Examples ...

Content Inside:

Mini User's Guide for SQL*Plus Oracle SQL*Plus Programming Examples Page 1EECS 484 10/3/2005 1Mini User's Guide for SQL*Plus T. J. TeoreyTable of Contents Oracle/loggingin 1 Nested subqueries 5 SQL create table/naming rules 2 Complex functions 6 Update commands 3 Save a query/perm table 6 Select commands 3 Special commands 6 Set operations 4 SQL views 9 Builtin functions 4 Index 10 Oracle Oracle 8.1.6 resides on a Sun Sparc10 node. However you do not need to login directly to this machine but think of it as a database server to be accessed from another machine for example canoe.engin.umich.edu. Logging in to UNIX and Oracle SQL*Pluslogin: <your Unix loginid> password: <your Unix loginpassword> yourunixnode% source /usr/caen/oracle/local/muscle yourunixnode% sqlplus Enter username: <youroracleid> Enter password: <youroraclepassword> /*You are now in SQL*Plus and can start issuing SQL*Plus commands*/ SQL> select * from employee; /*example of an sqlplus command*/ SQL> grant connect to youroracleid identified by yournewpassword; /*change password*/ Input and Output Files for OracleTo save the transcript of an sqlplus session or part of a session: SQL> set echo on; /*displays SQL code with results of the query*/ SQL> spool <filename>; /*filename will be appended with .1st if a postfix is not provided*/ SQL> spool off; /*will turn off the transcript spooling. You can now print the file with the instructions provided below*/ To read in a file: SQL> start <filename>; or SQL> @<filename>; where filename must be a OpSys file ending with .sql (the .sql may or may not be supplied to Oracle but must be part of the name of the file). Print Oracle ResultsTo print on a Sun or IBM the users can say: lpr P<printer_name> <filename> printer_names (2340eecss22341eecsh14327eecss14327eecss24 440eecss14440eecsm1) HP: lp d<printer_name> <filename> Access from any computer:1. To ...

Source: www.eecs.umich.edu

 

Related Files

Oracle Database 10g: Program with PL/SQL

Filed under: Programming and Oracle Programming
Oracle Database 10g: Program with PL/SQL. Duration 5 Days. What you will learn. This class is applicable to Oracle8i Oracle9i and Oracle Database 10g users ...

Oracle JDeveloper for Forms & PL/SQL Developers; A Guide to J2EE ...

Filed under: Programming and Oracle Programming
The most efficient way to learn J2EE programming techniques. Two Oracle experts ... Market. Developers currently using Oracle Forms and the PL/SQL language ...

Oracle/SQL Tutorial

Filed under: Programming and Oracle Programming
C.J. Date and Hugh Darwen: A Guide to the SQL Standard (4th Edition) AddisonWesley ... Oracle Data Dictionary. 23. 4. Application Programming. 4.1. PL/SQL ...

Oracle PLSQL Programming

Filed under: Programming and Oracle Programming
ORACLE PL/SQL PROGRAMMING. Course Code 2PTC313. Module Aims. The aims of the module are to:. Support students to develop a good understanding PL/SQL. ...

Oracle 10 g : Java Programming

Filed under: Programming and Oracle Programming
Oracle 10g: Java Programming. Duration 5 Days. What you will learn:. This course teaches the concepts and essential elements of the Java language. ...