Differences
This shows you the differences between two versions of the page.
|
bd:resurse:comenzi_utile [2019/03/07 10:55] fbratiloveanu |
bd:resurse:comenzi_utile [2019/04/25 10:33] (current) maria_luiza.serban |
||
|---|---|---|---|
| Line 17: | Line 17: | ||
| </note> | </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 71: | Line 76: | ||
| 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> | ||
| + | |||
