Answer / gourvendra singh

Strong Ref Cursor: Strong ref cursor are predetermined and
so we cannot use query having different structure then the
defined one
Week Ref Cursor : Week Ref Cursor are not predetermined and
so we can use query having different structure then the
defined one.

With the help of SQL Trace we will get the result of the
query with the execution plan and statistics of the query.

It is very difficult to send you all the SQL Plus Command,
you can check the same in SQL Plus window under option menu
in Environment there you will find all the SQL plus
commands.

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,

---

Explain uses of cursor.

1 Answers  

---

What operating systems are supported by oracle sql developer?

0 Answers  

---

Is not equal in sql?

0 Answers  

---

How many LONG columns are allowed in a table?

6 Answers   CTS,

---

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

Do we need to create index on primary key?

0 Answers  

---

Explain the purpose of %type and %rowtype data types with the example?

0 Answers  

---

Can you upgrade sql express to full sql?

0 Answers  

---

how to get a list of indexes of an existing table? : Sql dba

0 Answers  

---

Why left join is used in sql?

0 Answers  

---