Differences

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

--- informatica:oracle:comandos [2017/03/23 15:33] – jose
+++ informatica:oracle:comandos [2024/06/19 09:46] (current) – jose
@@ Line 1: / Line 1: @@
+<code>
+SELECT 'DROP TABLE ' || owner || '.' || table_name || ' CASCADE CONSTRAINTS;' AS drop_command
+FROM all_tables
+WHERE owner = 'WZC_AUTHORIZATION_OWN';
+</code>
+<code>
+set sqlformat insert;
+select * from WZC_AUTHORIZATION_OWN.AUTHORIZATION_CONFIGURATION;
+set sqlformat default;
+</code>
 ====== Crear Usuario ======
@@ Line 7: / Line 19: @@
-Comprobar usuario bloqueado:
+====== Comprobar usuario bloqueado: ======
 <code>
 select username,account_status,profile from dba_users where username='jose'