What is the quickest way to fetch the data from a table?

1058

What are the differences between char and nchar in oracle?

1096

How to return top 5 rows in oracle?

1062

Explain the use of full option in exp command.

1116

What is an oracle wallet?

942

How to use "while" statements in oracle?

1327

What is primefaces used for?

1049

What is merge statement used for?

1024

> 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?

2032

Explain the truncate in oracle?

967

What are the components of logical database structure in oracle database?

1088

What is the relationship among database, tablespace and data file?

989

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

How to assign values to variables?

1102

Explain oracle insert into command?

1115