Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4384 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
What is the minimum client footprint required to connect c# to an oracle database?
how to we delete a row using varray
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
What are oracle functions?
What is an anonymous block?
What is meant by raw datatype?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
How will you identify oracle database software release?
Oracle General 
