Sometimes while working in SQL we often forget the names of the view or sequence or index or synonyms or trigger we earlier created. Also it may happen that we want to verify them in future.
Verifying means that we are checking for all the present database object or Trigger in that particular schema.
This could be done for above all using the below mentioned queries:
1. verify VIEWS
SELECT VIEW_NAME FROM USER_VIEWS; OR SELECT * FROM USER_VIEWS;
Input : SELECT VIEW_NAME FROM USER_VIEWS; Output :
Input : SELECT * FROM USER_VIEWS; Output :
2. verify SEQUENCES
SELECT SEQUENCE_NAME FROM USER_SEQUENCES; OR SELECT * FROM USER_SEQUENCES;
Input : SELECT SEQUENCE_NAME FROM USER_SEQUENCES; Output :
Input : SELECT * FROM USER_SEQUENCES; Output :
3. verify INDEXES
SELECT INDEX_NAME FROM USER_INDEXES; OR SELECT * FROM USER_INDEXS;
Input : SELECT INDEX_NAME FROM USER_INDEXES; Output :
Input : SELECT * FROM USER_INDEXES; Output :
4. verify TABLES
SELECT TABLE_NAME FROM USER_TABLES; OR SELECT * FROM USER_TABLES;
Input : SELECT TABLE_NAME FROM USER_TABLES; Output :
Input : SELECT * FROM USER_TABLES; Output :
5. verify SYNONYMS
SELECT SYNONYM_NAME FROM USER_SYNONYMS; OR SELECT * FROM USER_SYNONYMS;
Input : SELECT SYNONYM_NAME FROM USER_SYNONYMS; Output :
Input : SELECT * FROM USER_SYNONYMS; Output :
6. verify TRIGGERS
SELECT TRIGGER_NAME FROM USER_TRIGGERS; OR SELECT * FROM USER_TRIGGERS;
Input : SELECT TRIGGER_NAME FROM USER_TRIGGERS; Output :
Input : SELECT * FROM USER_TRIGGERS; Output :
NOTE: Using * means that we need all the attributes for that database object or Trigger to get displayed.
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Difference between Oracle NoSQL and Oracle
- SQL Trigger | Student Database
- SQL Trigger | Book Management Database
- Difference between Trigger and Procedure in DBMS
- Difference between Cursor and Trigger in DBMS
- Polygraph to check View Serializabilty in DBMS
- View Serializability in DBMS Transactions
- Difference between Simple and Complex View in SQL
- Implementation of Materialized view through the Java Program
- What is GAV (Global as View)?
- Can a Bird Eye View on Phishing Emails Reduce it Potentially?
- Difference between Conflict and View Serializability
- Difference between View and Cursor in SQL
- Local as View (LAV)
- Pseudocolumn in Oracle SQL
- Difference between Oracle and MongoDB
- Comparisons between Oracle vs SQL Server
- Features of Oracle Server
- Difference between Impala and Oracle
- Difference between Hive and Oracle
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.