OraFAQ Forum: SQL & PL/SQL » Query to select PK. / how to insert and update CLOB?

Home » SQL & PL/SQL » SQL & PL/SQL » Query to select PK. / how to insert and update CLOB?

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

Query to select PK. / how to insert and update CLOB? [message #2760]

Mon, 12 August 2002 06:14

figen
Messages: 10
Registered: July 2002

Junior Member

I have two questions;

(1) How can I guery a table to find out Primary key(s)? I don't want to use column names. So is there any way to ask like " get me the Primary key of this table " :)

(2)How to insert and update CLOB datatype?

Any help would be highly appreciated

Report message to a moderator

Re: Query to select PK. / how to insert and update CLOB? [message #2769 is a reply to message #2760]

Mon, 12 August 2002 09:40

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Primary keys:

select cc.column_name
  from user_constraints c, user_cons_columns cc
 where c.table_name = :tablename
   and c.constraint_type = 'P'
   and cc.constraint_name = c.constraint_name
 order by cc.position;

Report message to a moderator

Previous Topic:	help!
Next Topic:	Update with concatenation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 07:29:15 CDT 2024