Answer Posted / khartheek

Normalization is the process of decomping the realtions
into smaller realtions inorder to minimize the data
redudancy i.e (Repeation of same copies of data ) multiple
times .

How do we get field details of a table?

936

---

When do we use group by clause in a sql query?

995

---

What is the data type of dual table?

921

---

What is bulk copy or bcp in oracle?

1045

---

Can we connect to ORACLE db using Windows Authentication?

1183

---

What are the different types of record groups in oracle? Explain each of them

972

---

Can group functions be mixed with non-group selection fields?

963

---

what is insert all statement in sql

6397

---

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

1983

---

How to create a new tablespace in oracle?

934

---

How to rename an index in oracle?

1063

---

What are the advantages of oracle?

963

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2153

---

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5289

---

What is oracle update statement with inner join ?

995

---