FAQ SQL*PlusConsultez toutes les FAQ

SQL> /

1
2
SQL> SELECT EMPLOYEE_ID, FIRST_NAME 
2 FROM employees

SQL> 1

SQL> a , LAST_NAME

1
2
SQL> SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME 
2 FROM employees

SQL> SPOOL cheminVersLeFichier/nomDuFichier

SQL> SPOOL OFF

SQL> SET TIMI[ING] ON/OFF

1
2
3
4
5
6
7
8
9
SQL> SET timing ON 
SQL> SELECT sysdate FROM dual; 
  
SYSDATE 
-------- 
15/05/09 
  
Ecoulé : 00 :00 :00.04 
SQL>

SQL> list

1
2
3
SQL> list 
1* select * from account 
SQL>

sqlplus scott/tigger < "c:/script.sql"

sqlplus scott/tigger @"c:/script.sql"

sqlplus / @"c:/script.sql"

SQL> @cheminVersLeFichier/nomDuFichier

SQL> @/home/oracle/scripts/CreateSchema.sql

SQL> DEFINE _EDITOR

SQL> DEFINE _EDITOR="C:/Program Files/Notepad++/notepad++.exe"

SQL> ed

SQL> SET DEFINE OFF

SQL> SET SCAN OFF

SQL> SET DEFINE @

1
2
SQL> SELECT EMPLOYEE_ID, FIRST_NAME 
2 FROM employees

SQL> 1

SQL> c /EMPLOYEE_ID/DEPARTEMENT_ID

1
2
SQL> SELECT DEPARTEMENT_ID, FIRST_NAME 
2 FROM employees