Home » SQL & PL/SQL » Client Tools » help me about problem show struct a table in PLSQL developer!
help me about problem show struct a table in PLSQL developer! [message #465378] Tue, 13 July 2010 22:09 Go to next message
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!

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 Go to previous messageGo to next message
BlackSwan
Messages: 22558
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
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 Go to previous messageGo to next message
rangan.s
Messages: 74
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
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 Go to previous messageGo to next message
cookiemonster
Messages: 10860
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.
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 Go to previous messageGo to next message
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>'
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 Go to previous messageGo to next message
Frank
Messages: 7877
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!
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 Go to previous message
phamcongquyet
Messages: 2
Registered: July 2010
Location: Viet Nam
Junior Member
Thank you very much. I fell very happy because you very enthusiasm!
Previous Topic: ER Studio
Next Topic: run scripts
Goto Forum:
  


Current Time: Fri Aug 01 20:41:52 CDT 2014

Total time taken to generate the page: 0.05650 seconds