To find the table that a constraint is in, you can do: SELECT * FROM all_constraints WHERE constraint_name = ‘the_constraint_name’ This is useful for finding child table(s) that have dependent […]
To change a user’s password, including your own: alter user THEUSERNAME identified by “NEWPASSWORD“;
For a list of tables with a specific column name, you can query the DBA_TAB_COLUMNS table: select table_name from dba_tab_columns where column_name=’MY_COLUMN_NAME’ order by table_name asc; This is helpful for […]
To unlock an account: alter user {USERNAME} account unlock;
Easy! Just select: CURRENT_TIMESTAMP