OraFAQ Forum: SQL & PL/SQL » select only structure of table ,no any rows

Home » SQL & PL/SQL » SQL & PL/SQL » select only structure of table ,no any rows (oracle stored procedure)

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

select only structure of table ,no any rows [message #313364]

Fri, 11 April 2008 08:51

hemuforum
Messages: 1
Registered: April 2008
Location: chennai

Junior Member

in storedprocedure,input param is tableName
it should return only structure of table (no any rows)

so help me, and give stored procedure for given table

Report message to a moderator

Re: select only structure of table ,no any rows [message #313365 is a reply to message #313364]

Fri, 11 April 2008 08:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Read & FOLLOW posting guidelines as stated in URL above

Report message to a moderator

Re: select only structure of table ,no any rows [message #313368 is a reply to message #313364]

Fri, 11 April 2008 09:18

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

If I were you I'd use Dbms_Metadata

Report message to a moderator

Previous Topic:	Need help with my code to have expected output.
Next Topic:	Inserting value from varchar2 to date field

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 10:45:13 CST 2024