Home » SQL & PL/SQL » SQL & PL/SQL » select only structure of table ,no any rows (oracle stored procedure)
icon9.gif  select only structure of table ,no any rows [message #313364] Fri, 11 April 2008 08:51 Go to next message
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
Re: select only structure of table ,no any rows [message #313365 is a reply to message #313364] Fri, 11 April 2008 08:56 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Read & FOLLOW posting guidelines as stated in URL above
Re: select only structure of table ,no any rows [message #313368 is a reply to message #313364] Fri, 11 April 2008 09:18 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If I were you I'd use Dbms_Metadata
Previous Topic: Need help with my code to have expected output.
Next Topic: Inserting value from varchar2 to date field
Goto Forum:
  


Current Time: Sun Dec 04 08:57:19 CST 2016

Total time taken to generate the page: 0.07635 seconds