Answer / valli

where startwith having

How to generate query output in html format?

0 Answers  

---

what are stored procedures?

7 Answers   TCS, Wells Fargo,

---

What is the quickest way to export a table to a flat file?

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,

---

How can we delete duplicate rows in a table?

0 Answers  

---

How can I combine multiple rows into a comma-delimited list 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  

---

HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?

3 Answers  

---

How to apply filtering criteria at group level in oracle?

0 Answers  

---

Can I create users through internet explorer in oracle 10g?

0 Answers   MCN Solutions,

---

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 Answers  

---

how to find count rows in table without count function?

3 Answers   Oracle,

---