oracle – Najít duplicity v tabulce

    select       column_name,       count(column_name) from       table group by       column_name having       count (column_name) > 1;  

oracle – GRANT privileges

GRANT privileges ON object TO user; privileges SELECT INSERT UPDATE DELETE REFERENCES ALTER INDEX ALL object database object that you are granting privileges for. In the case of granting privileges on a table, this would be the table name. user the name of the user that will be granted these privileges.   Examples: GRANT SELECT,…

oracle – SELECT ALL VIEWS

   SELECT *FROM all_viewsWHERE owner = ‘owner_name’  AND view_name = ‘view_name’;