What is difference between select statement and cursor

Question Posted / srinu

3 Answers
21091 Views
JDA, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is difference between select statement and cursor..

Answer / gudekotas

SELECT STATEMENT CONTAINS PARTICULAR STRUCTURE AND SELECT
QUERY RESULT SET CONTAINS ROWID,ROWNUM.

CURSOR DOESN'T CONTAIN STRUCTURE AND IT IS
VIRTUAL(CONTEXAREA)MEANS NO ROWID,NO ROWNUM.

Is This Answer Correct ?

11 Yes

2 No

What is difference between select statement and cursor..

Answer / bolearner

The above answer is not so correct.

cursor can fetch rowid, rownum also from table.

The select into cant retrieve more than 1 record in plsql.

But cursor can retrieve more records that can be viewed for modified later in plsql.

Cursors has attributes like open,close,fetch,notfound. Those attributes not applicable in select..into clause.

finally select..into in plsql, just select column values and storing into plsql variable.

Is This Answer Correct ?

6 Yes

1 No

What is difference between select statement and cursor..

Answer / akash

Using select..into statement u cannot fetch more than 1 rows.
Beside naming the same select statement as cursor explicitly allows user to options like OPEN,CLOSE,FETCH.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

select sal from emp group by sal

3 Answers TCS,

what is sp_pkeys? : Transact sql

0 Answers

What is pl sql in dbms?

0 Answers

What are different types of triggers?

0 Answers

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers Hexaware,

Compare SQL and PL/SQL.

3 Answers

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers

What are the types of SQL Statement?

3 Answers

What is composite data type in pl sql?

0 Answers

Can we create table inside stored procedure?

0 Answers

What are the properties of a transaction?

0 Answers

what is a trigger in mysql? Define different types of trigger. : Sql dba

0 Answers

For more SQL PLSQL Interview Questions Click Here