Can we use views in stored procedure?

0 Answers  

---

What is online transaction processing (oltp)?

0 Answers  

---

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

---

What is case function?

0 Answers  

---

Is it possible to access the current value in a session before accessing next value?

1 Answers  

---

What is pl sql block in dbms?

0 Answers  

---

How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What is meant by cursor in sql?

0 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

---

What are different joins used in sql?

0 Answers  

---