... following query
select constrint_name from user_constraints where table_name='emp';
I got the output as "no rows selected"
( i used oracle10g)i was created a table emp with constraints on sql*plus,but i didnt get the constraint names by the following query
select constrint_name from user_constraints where table_name='emp';
I got the output as "no rows selected"
( i used oracle10g)
I was created a table emp with constraints on sql*plus,but I didnt get the constraint names by the?
- Posted:
- 3+ months ago by prasadkom...
- Topics:
- table, plus, rows, name
Details:
Answers (1)
You misspelled constraint. It doesn't matter so much here as we knew what you meant but computers are fussy. Your query should have been:
select constraint_name from user_constraints where table_name='emp';
not:
select constrint_name from user_constraints where table_name='emp';