Answer / rajesh

The cursor attributes are
%rowcount
%found
%notfound
%isopen
if u have any issue contact me at
rajesh.natesh@gmail.com,rajesh.natesh@cognizant.com

Answer / pandu

Hi,
Cursor Attributes
1)Isopen
2)Found
3)Not Found
4)rowCount

but ,we cursor's are two types
Namely 1)Implicit Cursor
calling the attibutes as SQL%ISOPEN
2)Explicit cursor
calling the Attiributes as CursoName%ISOPEN.

Answer / nishi

The cursor attributes are

%rowcount

%found

%notfound

%isopen

Answer / gireesh.p.v

%type
%rowtype
contact me gireesh.p.v@gmail.com

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

What are the types of optimization?

0 Answers  

---

What is the usage of sql functions?

0 Answers  

---

What is a primary key? Explain

0 Answers  

---

what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---

What is the purpose of the sql select top clause?

0 Answers  

---

What is sqlservr exe?

0 Answers  

---

explain advantages of innodb over myisam. : Sql dba

0 Answers  

---

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  

---