what are local and global variables and their differences? : Sql dba

0 Answers  

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

how to create table with in the procedure or function?

2 Answers   Genpact, HCL,

---

What is before and after trigger?

0 Answers  

---

what is a composite primary key ? : Sql dba

0 Answers  

---

---

How many primary keys can a table have?

0 Answers  

---

How to connect a sql*plus session to an oracle server?

0 Answers  

---

What are the different operators available in sql?

0 Answers  

---

what is a view? : Sql dba

0 Answers  

---

What can I use instead of union in sql?

0 Answers  

---

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---