SELECT table_name---same
FROM user_tables t
WHERE EXISTS (
SELECT table_name----same
FROM user_indexes i
WHERE i.table_name = t.table_name);
SELECT COUNT(*)
FROM user_tables
WHERE srvr_id = 503;
SELECT COUNT(*)
FROM dual
WHERE EXISTS (
SELECT NULL
FROM user_tables
);
SELECT table_name
FROM user_tables t
WHERE NOT EXISTS (
SELECT table_name
FROM user_indexes i
WHERE i.table_name = t.table_name);
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
Index Usage – 21 week ago
-
-
-
-
-
-
-
-
Oracle Cloud & Third party tools3 years ago
-
-
-
Moving Sideways7 years ago
-
Upcoming Events...10 years ago
-
No comments:
Post a Comment