Differences

This shows you the differences between two versions of the page.

Link to this comparison view

bd:resurse:comenzi_utile [2019/03/06 13:06]
fbratiloveanu
bd:resurse:comenzi_utile [2019/04/25 10:33] (current)
maria_luiza.serban
Line 1: Line 1:
 ==== Comenzi Utile ==== ==== Comenzi Utile ====
  
 +  * Parole
 +
 +<note warning>
 +**11g**
 +
 +User: stud1
 +
 +Pass: student
 +
 +**12c**
 +
 +User: c##stud1
 +
 +Pass: student
 +
 +</​note>​
 +  * Formatare afisare
 +<code sql> ​
 +set lines 100
 +set PAGES 100
 +</​code>​
   * Lista cu tabelele la care are acces userul curent: ​   * Lista cu tabelele la care are acces userul curent: ​
 <code sql> select table_name from user_tables;​ </​code>​ <code sql> select table_name from user_tables;​ </​code>​
Line 44: Line 65:
 AND a.table_name = '​EMP';​ AND a.table_name = '​EMP';​
 </​code>​ </​code>​
-  * Formatare data+  * Formatare data(mai multe informatii [[https://​docs.oracle.com/​cd/​B28359_01/​olap.111/​b28126/​dml_commands_1029.htm#​OLADM780|aici]])
 <code sql> <code sql>
---check how date is defined +-->​verificare format 
---Method 1+--a. Method 1
 define _DATE define _DATE
---Method 2+--b. Method 2
 SELECT sysdate FROM dual; SELECT sysdate FROM dual;
  
---change formate date+-->​modificare format
 ALTER SESSION SET nls_date_format='​DD-MON-YYYY';​ ALTER SESSION SET nls_date_format='​DD-MON-YYYY';​
 </​code>​ </​code>​
-  ​Formatare afisare + 
-<code sql>  +  ​Verificare indecși 
-set lines 100 +<code sql> 
-set PAGES 100+select index_name, table_name from user_indexes;​
 </​code>​ </​code>​
 +
  
bd/resurse/comenzi_utile.1551870371.txt.gz · Last modified: 2019/03/06 13:06 by fbratiloveanu
CC Attribution-Share Alike 3.0 Unported
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0