Horje
oracle object dependencies Code Example
oracle object dependencies 
-- Dependencies on a view, table, ...
SELECT *
  FROM ALL_DEPENDENCIES			-- or DBA_DEPENDENCIES or USER_DEPENDENCIES
 WHERE TYPE = 'VIEW'			-- or 'PROCEDURE', 'SYNONYM'...
   AND REFERENCED_OWNER = 'OBJECT_OWNER'
   AND REFERENCED_NAME = 'OBJECT_NAME';



Sql

Related
oracle gather table statistics Code Example oracle gather table statistics Code Example
test the postgresql db connection Code Example test the postgresql db connection Code Example
sql union Code Example sql union Code Example
sql query interview questions Code Example sql query interview questions Code Example
select current_timestamp - interval '3 days'; Code Example select current_timestamp - interval '3 days'; Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje