OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Re: hi

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

Re: hi [message #373295]

Tue, 10 April 2001 12:06

gangadhar gundavaram
Messages: 9
Registered: April 2001

Junior Member

Hi Naresh,

Iam getting no rows found , but this table have primary key . could you see the problem.

SQL> ed
Wrote file afiedt.buf

1 Select constraint_name,constraint_type,status
2 from user_constraints
3* where table_name='olt_student'
4
SQL> /

no rows selected

Report message to a moderator

Re: hi [message #373297 is a reply to message #373295]

Tue, 10 April 2001 12:10

aish
Messages: 44
Registered: March 2001

Member

Use all caps for table name
1 Select constraint_name,constraint_type,status
2 from user_constraints
3* where table_name='OLT_STUDENT'

Thanks,
Aish

Report message to a moderator

Re: hi [message #373298 is a reply to message #373295]

Tue, 10 April 2001 13:30

gangadhar gundavaram
Messages: 9
Registered: April 2001

Junior Member

Hi Aish,

Thanks very much. yeah it is working.
Iam a Web Developer not Data base Programmer

could tell me constraint_type c,p,u Stand for what? how many types of constraint_type are availabe in oracle.

Thanks in Advance
-Gangadhar

Report message to a moderator

Re: hi [message #373299 is a reply to message #373295]

Tue, 10 April 2001 13:35

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

C = Check
P = Primary Key
U = Unique Key
R = Referential Integrity
V = Check Option on a view

Report message to a moderator

Re: hi [message #373300 is a reply to message #373295]

Tue, 10 April 2001 13:37

gangadhar gundavaram
Messages: 9
Registered: April 2001

Junior Member

Hi Aish,
If i know the CONSTRAINT_NAME SYS_C003332
can I findout the Feild Name in the table.
because Iam Accessing Production Databse
some body else Created tables.

Thanks in Advance

-Gangadhar

Report message to a moderator

Re: hi [message #373301 is a reply to message #373295]

Tue, 10 April 2001 13:40

gangadhar gundavaram
Messages: 9
Registered: April 2001

Junior Member

Thanks v ery much.

-Gangadhar

Report message to a moderator

Re: hi [message #373304 is a reply to message #373295]

Tue, 10 April 2001 16:21

Amit Chauhan
Messages: 74
Registered: July 1999

Member

Hi,
Yes you can find out.
Try this :
select substr(column_name, 1, 50)
from user_cons_columns
where constraint_name = 'SYS_C003332'
/
Thanks
Amit

Report message to a moderator

Re: hi [message #373305 is a reply to message #373304]

Tue, 10 April 2001 16:41

gangadhar gundavaram
Messages: 9
Registered: April 2001

Junior Member

Hi Amit,

Thanks very much. I got it.

-Gangadhar

Report message to a moderator

Re: hi [message #373308 is a reply to message #373295]

Tue, 10 April 2001 18:39

Naresh Sharma
Messages: 12
Registered: April 2001

Junior Member

Use all caps for table name

Select constraint_name,constraint_type,status
from user_constraints
where table_name='OLT_STUDENT'

------------
Regards

Naresh

Report message to a moderator

Previous Topic:	hiredates
Next Topic:	Shutdown immediate

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 10:08:39 CST 2024