This shows you the differences between two versions of the page.
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> | ||
+ | |||