why dont we assign not null constraint as table level
constraint.
Describe Referential Integrity ?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
Explain the dml?
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
How to update values on multiple rows in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What are the different types of synonyms?
What do you mean by a deadlock?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
How many data types are supported?
What a SELECT FOR UPDATE cursor represent.?
What is a View ?