Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vijay kumar jakkam
1. A CHECK constraint evaluates to TRUE when the resulting value of the CHECK constraint expression is unknown, e.g. when the expression contains NULL.
Example: A CHECK constraint that enforces the value of a particular column to be >0 evaluates to TRUE if NULL passed while inserting.
2. CHECK Constraints are not evaluated for delete statements.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the parameter mode that can be passed to a procedure?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to handle a single quote in oracle sql?
How to load data from external tables to regular tables?
What are the differences between char and varchar2 in oracle?
Explain the use of control file?
What are the differences between blob and clob in oracle?
Can sub procedure/function be called recursively?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How to use "while" statements in oracle?
What is ceil and floor in oracle?
> 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?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to define an external table with a text file?
