Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 35941 Views
- I also Faced
- E-Mail Answers
Answer Posted / narender sharma
Where clause is used to restrict rows but having clause is
used to restrict groups
| Is This Answer Correct ? | 28 Yes | 3 No |
Post New Answer View All Answers
What is the use of oracle?
What is a nested table?
How to bring a tablespace online?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is background process in Oracle?
How do I spool to a csv formatted file using sqlplus?
> 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 to create a server parameter file?
Explain the use of file option in exp command.
Is there a function to split a string in plsql?
What is flashback in Oracle?
How to create tables for odbc connection testing?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is the usage of analyze command in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
