Answer / rohit

Yes

How to get a create statement for an existing table?

0 Answers  

---

how to find out largest value in a table

2 Answers  

---

How do I find the database name in oracle?

0 Answers  

---

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

0 Answers  

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

---

Explain about the analyze command in oracle?

0 Answers  

---

How are Indexes Update ?

1 Answers  

---

12 RULES OF RDBMS

1 Answers  

---

What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

1 Answers  

---

structural difference between bitmap and btree index ?

1 Answers   Infosys,

---

What is a data lock in oracle?

0 Answers  

---

what is null value?

9 Answers  

---