Answer Posted / devaraj

Because, emp number is unique. so easy to retrieve

What is the difference between translate and replace?

1011

---

What are the advantages of oracle?

961

---

What are the ansi data types supported in oracle?

895

---

How to bring a tablespace online?

994

---

How a tablespace is related to data files?

1060

---

Explain the use of control file?

1060

---

What is an Oracle Instance?

1071

---

Is there an oracle sql query that aggregates multiple rows into one row?

931

---

Can we convert a date to char in oracle and if so, what would be the syntax?

957

---

How many types of synonyms in Oracle?

1063

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2300

---

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

1980

---

What is raw datatype?

1078

---

Give the different types of rollback segments.

978

---

What privilege is needed for a user to create views in oracle?

979

---