Which kind of parameters cannot have a default value in pl sql?

0 Answers  

---

What is offset in sql query?

0 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

What is graph sql?

0 Answers  

---

What is dcl in sql?

0 Answers  

---

---

Can a composite key be null?

0 Answers  

---

can we create index on index?

7 Answers   iFlex, Symphony,

---

how is myisam table stored? : Sql dba

0 Answers  

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  

---

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

What is the difference between function, procedure and package in pl/sql?

0 Answers  

---

What is the difference between count 1 and count (*) in a sql query?

0 Answers  

---