I want to know this because I forgot the name of the table I created.
i am using Oracle 9i.
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');
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/…