Home » SQL & PL/SQL » SQL & PL/SQL » Advanced queries in sql
icon4.gif  Advanced queries in sql [message #212239] Thu, 04 January 2007 05:35 Go to next message
hirak1984
Messages: 1
Registered: January 2007
Junior Member
I want to write a query that will tell me the primary key of a table .please help me......
and I also want to get the attribute names of a table,in case user dont know them.
he/she only knows the name of the table
Re: Advanced queries in sql [message #212244 is a reply to message #212239] Thu, 04 January 2007 05:47 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,


user_constraints & user_tab_columns should help.



regards,
Previous Topic: First row one column and last row other column
Next Topic: deleting child records directly
Goto Forum:
  


Current Time: Fri Dec 09 21:46:50 CST 2016

Total time taken to generate the page: 0.08324 seconds