what is insert all statement in sql

2 Answers   CGI, TCS,

---

What is the database name in oracle?

0 Answers  

---

How to enter a new row into a table interactively?

0 Answers  

---

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

2 Answers   MasterCard,

---

What is coalesce function?

0 Answers  

---

---

What is a relational database management system?

0 Answers  

---

We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?

3 Answers  

---

What do you mean by merge in oracle and how can you merge two tables?

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  

---

What are the built-in functions used for sending Parameters to forms ?

0 Answers   Oracle, TCS,

---

What is clustered table in Oracle?

0 Answers   MCN Solutions,

---

How can we Update a table with out using UPDATE command?

1 Answers  

---