Oracle SQL*Plus

Connecting

  • To connect to sqlplus, Type, sqlplus
  • Oracle automatically connects to a default database. To find out which database, Type echo %oracle_sid% or echo $oracle_sid on UNIX
  • To find out who u logged in as, Type define
  • To connect as another user to another database, you don't need to exit. Just connect as follow: connect sys as sysdba;
  • Every table in db belongs to a particular schema

 

Oracle basic datatypes

  • number: can hold an integer and decimal
  • varchar2: for variable characters
  • char
  • date: stores year, day, month, hour, minute, seconds
  • timestamp: stores milliseconds
  • LOB - large objects
  • BLOB- binary large objects
  • CLOB - character large objects

 

Editor Shortcuts

  • find out which table the current use owns: Type select table_name from user_tables;
  • To control the pagesize (something like pagination) of the query you run on sqlplus: Type set pagesize [number]
  • To rerun or re-execute a preceeding query type /
  • To know what query is in ur buffer, type l or list or just type the line number of the query
  • To change the column name of ur last query, type c/[column name to change]/[new column name]

 

Dynamic Scripts

  • Set linesize [number] - Set linesize for your query output
  • Set pagesize [number] - Set pagesize for your query output
  • col ename format a32 - format the column "ename"
  • col sal format $999,999.00
  • set pause on

Post new comment

The content of this field is kept private and will not be shown publicly.