Interested to Buy Any Domain ? << Click Here >> for more details...
8. Display the client name and order date for all orders
using the natural join keywords.
- 1 Answers
- 3743 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / devraj
Select ca.name, ord.orderdate From customer ca Natural Join
ord;
Natural join is a cartisn product.
| Is This Answer Correct ? | 0 Yes | 0 No |
> 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?
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
How to assign values to variables?
What is oracle database 10g express edition?
What do you mean by merge in oracle?
What is the string concatenation operator in oracle?
which sql command we can use to get a print out from oracle?
What is data block in Oracle?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
How to find out what oracle odbc drivers are installed?
How to concatenate two text values in oracle?
how do u know the total no of rows in a table?
Oracle General 
