FAQ SQL*PlusConsultez toutes les FAQ

1
2
3
export ORACLE_HOME=/oracle01/11gR1 
export ORACLE_SID=orcl 
export PATH=$PATH:/oracle01/11gR1/bin

1
2
3
set %ORACLE_HOME%=c:\oracle01\11gR1 
set %ORACLE_SID%=orcl 
set %PATH%=%PATH%;C:\oracle01\11gR1\bin

sqlplus (utilisateur[/mot_de_passe][@identifiant_BDD] | /) [AS SYSDBA | AS SYSOPER] | /NOLOG

sqlplus scott/tiger

sqlplus sys/change_on_install AS SYSDBA

sqlplus /

sqlplus /nolog

SQL> connect scott/tigger

SQL> connect sys/change_on_install AS SYSDBA

sqlplus -V

SQL> define

1
2
3
4
5
6
7
8
DEFINE _DATE           = "30/03/09" (CHAR) 
DEFINE _CONNECT_IDENTIFIER = "XE" (CHAR) 
DEFINE _USER           = "HR" (CHAR) 
DEFINE _PRIVILEGE      = "" (CHAR) 
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR) 
DEFINE _EDITOR         = "Notepad" (CHAR) 
DEFINE _O_VERSION      = "Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production" (CHAR) 
DEFINE _O_RELEASE      = "1002000100" (CHAR)

SQL> define _CONNECT_IDENTIFIER

SQL> define variableName=newValue

SQL> define _EDITOR="c:/Notepad++/Notepad++.exe"

SQL> SET sqlprompt "&_USER@&_CONNECT_IDENTIFIER> "

SQL> SET sqlprompt "nouvelleValeur"

SQL> SET sqlprompt "jsd03 SQL> "

SQL> SET sqlprompt &_USER@&_CONNECT_IDENTIFIER>

SQL> set time on

20:36:20 SQL>

SQL> SHOW USER

USER IS "JSD03"

SQL> help SHOW

SQL> help host

1
2
3
sqlplus SYS/password @helpdrop.sql --supprime les tables d'aide si elles existent déjà 
sqlplus SYS/password @helpbld.sql --créée les tables d'aide 
sqlplus SYS/password @helpus.sql --charge les données dans les tables d'aide

SQL> password

1
2
3
4
5
6
7
8
9
10
SQL> conn scott 
Enter password: 
Connecte. 
SQL> password 
Modification de mot de passe pour SCOTT 
Ancien mot de passe : 
Nouveau mot de passe : 
Ressaisir le nouveau mot de passe : 
Mot de passe modifie 
SQL>

1
2
3
SQL> ! commandeUnix 
SQL> $ commandeWindows 
SQL> host commandeUnixOuWindows

1
2
3
SQL> ! date 
lun jan 10 10:29:06 CEST 2009 
SQL>

1
2
3
SQL> $ echo developpez.com 
developpez.com 
SQL>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
SQL> $ 
Microsoft Windows XP [version 5.1.2600] 
(C) Copyright 1985-2001 Microsoft Corp. 
  
C:\Documents and Settings\Jean-Sébastien>exit 
  
SQL> host 
Microsoft Windows XP [version 5.1.2600] 
(C) Copyright 1985-2001 Microsoft Corp. 
  
C:\Documents and Settings\Jean-Sébastien>echo developpez.com 
developpez.com 
  
C:\Documents and Settings\Jean-Sébastien>date 
La date du jour est : 02/06/2009 
Entrez la nouvelle date : (jj-mm-aa) 
  
C:\Documents and Settings\Jean-Sébastien>exit 
  
SQL>

SQL> SET serveroutput ON

SQL> SET serveroutput ON size 1000000

SQL> store SET fileName

SQL> store SET "c:/sqlVariables.txt"

SQL> @"c:/sqlVariables.txt"

SQL> SHOW variableName

1
2
SQL> SHOW pagesize 
pagesize 14

SQL> SHOW all

SQL> quit

SQL> exit