Please create a query using user_cons_columns and user

i must get table name, constraint type, constrain name with
using concads "||" and it must be in string type, then with
join processes i need code
please help immidiately

Question Posted / dinesh a.

1 Answers
4432 Views
I also Faced
E-Mail Answers

Answer Posted / dinesh a.

Please create a query using user_cons_columns and
user_constraints table you will get
table_name||constraint_name||constraint_type

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a subquery in oracle?

1098

How to create a testing table in oracle?

984

Which are the five query types available in oracle?

947

how do u setup a replication site?

1974

What is difference between cartesian join and cross join?

1081

How to run the anonymous block again?

1123

Explain the use of log option in exp command.

1110

What privilege is needed for a user to create indexes in oracle?

1021

How to call a sub procedure?

1089

Point the difference between translate and replace?

1081

How to define an anonymous procedure with variables?

1146

Explain the use of ignore option in imp command.

1028

How does Oracle guarantee data integrity of data changes?

2380

What is a table in oracle?

972

What is key preserved table?

1011