Oracle Foundation Learning (i) sqlplus basic commands

1 , format the SQL Plus interface:

L Overall Settings:

SET  Number  -- set Number of rows SET  Number  -- set Number of columns

L single-Column settings:

ColumnName  for Numeber -- character class Char,varchar2, example: A10 ColumnName  for 9... 9   -- number 9 For several, example: three-bit 999

2 , notepad editing

L Create a SQL file for code editing:

ED  filename

L Execute File:

@ filename

Execute the SQL file that already exists on the disk:

@ path:\filename

3 , display users

L Switch different users:

CONN username[/password] [asSYSDBA]

Note: If you are using a SYS user login, which belongs to the Super Administrator, you must set the SYSDBA

L Show Current User:

USER

L do not require user login, then add a/nolog parameter

Sqlplus/Nolog

4. calling the native program

L Copy files:

HOST COPY path:\*. SQL  path:\* *. sql

Oracle Foundation Learning (i) sqlplus basic commands