For a list of available schemas, use the show schemas command if the table or view is in a particular schema, qualify it with the schema name. Oracle9i sql reference for information on oracles sql commands and functions. See associated error messages for a description of the problem. Lists the column definitions for the specified table, view or synonym, or the specifications for the. I have not been able to perform a clean installation of the latest download of the oracle 9i database on a new dell pentium 4, 2. The computer has 50 gig of available space, 512 ram, and its virtual memory is set to in initial size of 768 mb with a maximum size of 1536mb.
Desc ribe sqlplus command describe an oracle table, view, synonym, package or function. Oracle9i database error messages oracle help center. Upgrade from oracle 9i to 11g database upgrade from 9i to 11g the following is a real scenario for upgrading a 9. I am using oracle 11g r2 and i have been trying to execute the below given plsql procedure. Note that because this is a sqlplus command you dont need to terminate it with a semicolon. You can also display the line number and indentation of the attribute or column name when an object contains multiple object types. Guarantees that sessionlevel commands are applied to the correct session objects if the session ends and another session. Contains a complete description of the structured query language sql used to manage information in an oracle database. For a full description of the select statement, see oracle9i sql reference. For a list of views in the current schema, use the show views command.
Oracle database administration fundamentals ii note sheets. Oracle9i database generic documentation master glossary. Oracle learning library ask tom dev gym database doc 19c, 18c, 12c follow on twitter live sql 20. Ensure you have a jdk installed, if not, download here for 64bit intel macs, download java for mac os x 10. For the latest version of mac os, use the software update feature download the file for os x on the downloads page. Desc describe an oracle table, view, synonym, package or. The describe command enables you to describe objects recursively to the depth level set in the set describe command. Notesincluded with the oracle9i database softwaredescribe this change. Provides a decription of the specified table or view. For a list of tables in the current schema, use the show tables command.
182 1221 276 645 601 461 981 1451 1425 161 1076 351 988 421 620 1092 507 1091 221 452 511 1244 574 204 1359 1206 680 597 165 1368 1103