| Author |
Message |
    
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18169
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Saturday, April 01, 2006 - 12:29 am: |    |
 |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2332
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Friday, March 31, 2006 - 5:19 pm: | |
sare mama  |
Rratna
Bewarse
Username: Rratna
Post Number: 1287
Registered: 03-2004
Posted From: 24.223.154.230
| | Posted on Friday, March 31, 2006 - 5:18 pm: | |
Sinna budhiga chaduvukontunavuga? |
Sinna
Desanike Pedda Bewarse
Username: Sinna
Post Number: 11992
Registered: 04-2005
Posted From: 68.229.151.18
| | Posted on Friday, March 31, 2006 - 5:17 pm: | |
Nayakudu mama Chala CHala Thanks Perfect ga work avuthundi...
Oka sari mail choosuko
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2331
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Friday, March 31, 2006 - 5:15 pm: | |
to get foreign key columns
select a.column_name
from
all_cons_columns a,
all_constraints b
where
a.constraint_name = b.constraint_name
and a.table_name = b.table_name
and b.constraint_type = 'R'
and b.table_name = '<TABLE NAME>' |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2330
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Friday, March 31, 2006 - 5:13 pm: | |
to get primary key column
select a.column_name
from
all_cons_columns a,
all_constraints b
where
a.constraint_name = b.constraint_name
and a.table_name = b.table_name
and b.constraint_type = 'P'
and b.table_name = '<TABLE NAME>' |
Sinna
Desanike Pedda Bewarse
Username: Sinna
Post Number: 11991
Registered: 04-2005
Posted From: 68.229.151.18
| | Posted on Friday, March 31, 2006 - 5:11 pm: | |
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Nayakudu
Bewarse
Username: Nayakudu
Post Number: 2329
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Friday, March 31, 2006 - 5:08 pm: | |
chepthaa agu.. |
Sinna
Desanike Pedda Bewarse
Username: Sinna
Post Number: 11990
Registered: 04-2005
Posted From: 68.229.151.18
| | Posted on Friday, March 31, 2006 - 5:08 pm: | |
select constraint_name from user_constraints where table_name='XYZ'
idi vadithe SYS_C005777 ila isthundi output kani naku kavalasindi aa COlumn Name that is actual ga I want to select the Primary Key COlumn and Foregin Key columns in a table...
Ela cheyyali komchem cheppagalara
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
