Interested to Buy Any Domain ? << Click Here >> for more details...
Can an Integrity Constraint be enforced on a table if some
existing table data does not satisfy the constraint ?
- 2 Answers
- 7757 Views
- I also Faced
- E-Mail Answers
Answer Posted / orawhiz
No.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the database administrators utilities available?
Explain parameter file in oracle.
How to turn on or off recycle bin for the session?
How to convert times to characters in oracle?
Differentiate between function and procedure in oracle.
What is snapshot is too old? Give and example for better understand.
What are the oracle differences between nvl and coalesce
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How view is different from a table?
What is a nvl function?
How to get last row id?
What are the differences between date and timestamp in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is oracle database client?
What is hash cluster in oracle?
