Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36324 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajesh dutta
where conditions used only for comparing row values.
having conditions used to compares group values like
min,max,count etc.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Explain what are the type of synonyms?
Is primary key indexed by default in oracle?
Explain mutating triggers.
What is a Garbage Collection? and what is full recursive Garbage collection?
> 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 is catalog in Oracle?
Is postgres faster than oracle?
How to assign values to data fields in record variables?
What is an oracle tablespace?
How to use fetch statement in a loop?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How many types of database triggers exist?
What are the advantages of oracle?
How do you find current date and time in oracle?
