Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to know this because, I forgot the name of the table I created

Using Oracle 9i

Thanking you for your time.

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

Login as your user, then execute:

SELECT TABLE_NAME FROM USER_TABLES;

Selecting from this data dictionary view will list all of the tables owned by the currently logged in user.

All of the objects you own can either be viewed in their object-specific USER_ view, or queried in the USER_OBJECTS view:

SELECT OBJECT_NAME, OBJECT_TYPE FROM USER_OBJECTS;

For example:

SELECT OBJECT_NAME, OBJECT_TYPE 
FROM USER_OBJECTS
WHERE OBJECT_TYPE IN ('FUNCTION', 'PACKAGE', 'PACKAGE BODY', 'PROCEDURE');
share|improve this answer
    
But I don't know the 'table_name', that' what I want to find!! –  Sameer Thigale Oct 4 '13 at 14:21
    
TABLE_NAME is the column name in the USER_TABLES view, which is obvious if you know SQL. docs.oracle.com/cd/B28359_01/server.111/b28320/… –  FreshPhilOfSO Oct 4 '13 at 14:24
    
Thanks. Got it! :) And what to know the existing procedures and functions? –  Sameer Thigale Oct 4 '13 at 14:30
    
Use USER_OBJECTS –  FreshPhilOfSO Oct 4 '13 at 14:33
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.