CODEWITHSUNDEEP
oracle-databasetoad
Edwin Benjamin
Edwin Benjamin

Reputation: 27

how to fetch the column name in related table in Toad?

how to fetch the column name in related table in Toad? For example, Table Name: User; Column name: Usr_code

Select * from User where u

after where condition, related column should be coming in drop down? send the shortcut?

Upvotes: 0

Views: 5196

Answers (2)

Ryan A.
Ryan A.

Reputation: 1

To fetch the columns names from a table, I use the following:

SELECT * FROM [table name] WHERE ROWNUM < 1;

Upvotes: 0

J. Chomel
J. Chomel

Reputation: 8393

Do you mean you want to know what are the columns of table User?

  • From Oracle metadata:

    select * from all_tab_columns where table_name ='USER';

  • From Toad UI: You should use an alias, then shortcut for autocompletion is CTRL+space if I remember correctly. So start with the below and use kbd shortcut after you entered the last dot .:

  • Depending on the TOAD configuration, it can also be CTRL+.

    Select * from User u where u.<ctrl>+<space>

    or 

    Select * from User u where u.<ctrl>+<.>

Upvotes: 1

Related Questions