Why does %isopen return false for an implicit cursor?

1 Answers  

---

How did you export data from database to excel file.

1 Answers   TCS,

---

What is the difference between sql and isql*plus?

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  

---

How does sql developer connect to oracle database?

0 Answers  

---

---

What are the Restrictions on Cursor Variables?

2 Answers  

---

What is a database event trigger?

0 Answers  

---

What are expressions?

0 Answers  

---

How can I change database name in sql?

0 Answers  

---

What is dml with example?

0 Answers  

---

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,

---

Why do we need cursors in pl sql?

0 Answers  

---