Skrevet av Emne: Oracle: How to show table names  (Lest 4306 ganger)

ATC

  • Gjest
Oracle: How to show table names
« på: 30. April 2009, 09:26 am »
  • [applaud]0
  • [smite]0
  • In MySQL I would use 'show tables'. How can I do the same thing in Oracle?



    ATC

    • Gjest
    [Solved] Oracle: How to show table names
    « Svar #1 på: 30. April 2009, 09:26 am »
  • [applaud]0
  • [smite]0
  • SELECT TABLE_NAME FROM USER_TABLES;

    More information about your tables is available from USER_TABLES. To see all the attributes of USER_TABLES, try:

    SELECT * FROM USER_TABLES;