-1

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

i am using Oracle 9i.

1 Answer 1

2

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');
4
  • But I don't know the 'table_name', that' what I want to find!!
    – Sam
    Oct 4, 2013 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/…
    – Philᵀᴹ
    Oct 4, 2013 at 14:24
  • Thanks. Got it! :) And what to know the existing procedures and functions?
    – Sam
    Oct 4, 2013 at 14:30
  • Use USER_OBJECTS
    – Philᵀᴹ
    Oct 4, 2013 at 14:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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