OraFAQ Forum: Client Tools » help me about problem show struct a table in PLSQL developer!

Home » Other » Client Tools » help me about problem show struct a table in PLSQL developer!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help me about problem show struct a table in PLSQL developer! [message #465378]

Tue, 13 July 2010 22:09

phamcongquyet
Messages: 2
Registered: July 2010
Location: Viet Nam

Junior Member

Hi,every body!
I want to show struct a table in PLSQL developer version 7.1.1.1339.
I used syntax " decribe table_name; but it not success in SQLwindow .It success in Command window.
I understand why?please ,heping me!

My English grammar is poor.Hop every body sympathize!

Thanks advance!

If evey one have free time,can send your answer to email: phamcongquyet@gmail.com

Thank you very much!

Report message to a moderator

Re: help me about problem show struct a table in PLSQL developer! [message #465379 is a reply to message #465378]

Tue, 13 July 2010 22:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: help me about problem show struct a table in PLSQL developer! [message #465380 is a reply to message #465379]

Tue, 13 July 2010 22:54

rangan.s
Messages: 75
Registered: February 2008
Location: chennai

Member

SQL window only used to execute the quires . there you cannot try desc or execute procedue all this can be achieved in command window .

Thanks
Rangan

Report message to a moderator

Re: help me about problem show struct a table in PLSQL developer! [message #465458 is a reply to message #465380]

Wed, 14 July 2010 04:26

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Strictly speaking describe isn't a sql command, it's a sqlplus command.
It works in the command window because that emulates sqlplus.

@Rangan - sql window can do a lot more than execute queries - you can run pl/sql blocks in it.

Report message to a moderator

Re: help me about problem show struct a table in PLSQL developer! [message #465459 is a reply to message #465458]

Wed, 14 July 2010 04:41

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

if describe fails try ..

select table_name,column_name , data_type , data_length from user_tab_columns  where table_name = '<Table Name>'

Report message to a moderator

Re: help me about problem show struct a table in PLSQL developer! [message #465517 is a reply to message #465378]

Wed, 14 July 2010 08:55

Frank
Messages: 7901
Registered: March 2000

Senior Member

Why not simply
- open the object tree on the left, right click the table name and select describe
or
- type in the table name in the sql window, right click it and select describe?

If you want to use a GUI, learn its features. Otherwise you might as well use sqlplus!

Report message to a moderator

Re: help me about problem show struct a table in PLSQL developer! [message #465871 is a reply to message #465517]

Thu, 15 July 2010 20:18

phamcongquyet
Messages: 2
Registered: July 2010
Location: Viet Nam

Junior Member

Thank you very much. I fell very happy because you very enthusiasm!

Report message to a moderator

Previous Topic:	ER Studio
Next Topic:	run scripts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 20:19:09 CDT 2024