How you open and close a cursor variable.Why it is required?

How you open and close a cursor variable.Why it is required?
by

1 Answer

Answer :

OPEN cursor variable FOR SELECT...Statement
CLOSE cursor variable In order to associate a cursor variable with a
particular SELECT statement OPEN syntax is used. In order to free the
resources used for the query CLOSE statement is used.
by

Related questions

What is use of a cursor variable? How it is defined?

Description : What is use of a cursor variable? How it is defined?

Last Answer : A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor ... indicating the types of the select list that will eventually be returned by the cursor variable.

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

Description : What should be the return type for a cursor variable.Can we use a scalar data type as return type?

Last Answer : The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE

What is a cursor ? Why Cursor is required ?

Description : What is a cursor ? Why Cursor is required ?

Last Answer : Cursor is a named private SQL area from where information can be accessed. Cursors are required to process rows individually for queries returning multiple rows.

What are savepoint mode and cursor mode properties ? level?

Description : What are savepoint mode and cursor mode properties ? level?

Last Answer : Specifies whether Oracle Forms should issue savepoints during a session. This property is included primarily for applications that will run against non-ORACLE data sources. For applications that will run ... use the default setting. Cursor mode - define cursur state across transaction Open/close.

What are attributes of cursor?

Description : What are attributes of cursor?

Last Answer : %FOUND , %NOTFOUND , %ISOPEN,%ROWCOUNT

What are cursor attributes?

Description : What are cursor attributes?

Last Answer : %ROWCOUNT -%NOTFOUND -%FOUND -%ISOPEN

What is a cursor for loop?

Description : What is a cursor for loop?

Last Answer : Cursor For Loop is a loop where oracle implicitly declares a loop variable, the loop index that of the same record type as the cursor's record.

How you were passing cursor variables in PL/SQL 2.2?

Description : How you were passing cursor variables in PL/SQL 2.2?

Last Answer : In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2, the only means of passing a cursor variable to a PL/SQL block is via bind variable or a procedure parameter.

What WHERE CURRENT OF clause does in a cursor?

Description : What WHERE CURRENT OF clause does in a cursor?

Last Answer : LOOP SELECT num_credits INTO v_numcredits FROM classes WHERE dept=123 and course=101; UPDATE students FHKO;;;;;;;;;SET current_credits=current_credits+v_numcredits WHERE CURRENT OF X;

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Description : Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Last Answer : No, a cursor variable points a row which cannot be stored in a two- dimensional PL/SQL table.

What is a cursor?

Description : What is a cursor?

Last Answer : Oracle uses work area to execute SQL statements and store processing information PL/SQL construct called a cursor lets you name a work area and access its stored information A cursor is a mechanism used to fetch more than one row in a Pl/SQl block.

Difference between an implicit & an explicit cursor.?

Description : Difference between an implicit & an explicit cursor.?

Last Answer : only one row. However,queries that return more than one row you must declare an explicit cursor or use a cursor FOR loop. Explicit cursor is a cursor in which the cursor name is explicitly ... statements An implicit cursor is used to process INSERT, UPDATE, DELETE and single row SELECT. .INTO

What a SELECT FOR UPDATE cursor represent.?

Description : What a SELECT FOR UPDATE cursor represent.?

Last Answer : SELECT......FROM......FOR......UPDATE[OF column-reference][NOWAIT] The processing done in a fetch loop modifies the rows that have been retrieved by the cursor. A convenient way of ... the FOR UPDATE clause in the cursor declaration, WHERE CURRENT OF CLAUSE in an UPDATE or declaration statement.

What are the cursor attributes used in PL/SQL ?

Description : What are the cursor attributes used in PL/SQL ?

Last Answer : %ISOPEN - to check whether cursor is open or not % ROWCOUNT - number of rows fetched/updated/deleted. % FOUND - to check whether cursor has fetched any row. True if rows are ... featched. These attributes are proceeded with SQL for Implicit Cursors and with Cursor name for Explicit Cursors.

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

Description : What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

Last Answer : A cursor declared in a package specification is global and can be accessed by other procedures or procedures in a package. A cursor declared in a procedure is local to the procedure that can not be accessed by other procedures.

What is a cursor for loop ?

Description : What is a cursor for loop ?

Last Answer : Cursor for loop implicitly declares %ROWTYPE as loop index,opens a cursor, fetches rows of values from active set into fields in the record and closes when all the records have been processed. eg. FOR emp_rec IN C1 LOOP salary_total := salary_total +emp_rec sal; END LOOP;

What are the PL/SQL Statements used in cursor processing ?

Description : What are the PL/SQL Statements used in cursor processing ?

Last Answer : DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or Record types, CLOSE cursor name.

The value recorded in system.last_record variable is of type

Description : The value recorded in system.last_record variable is of type

Last Answer : a. Number b. Boolean c. Character. ? b. Boolean.

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size?

Description : Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size?

Last Answer : Yes

System.effective_date system variable is read only True/False?

Description : System.effective_date system variable is read only True/False?

Last Answer : False

Can Full Backup be performed when the database is open ?

Description : Can Full Backup be performed when the database is open ?

Last Answer : No.

An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Description : An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Last Answer : True

How do you create a new session while open a new form?

Description : How do you create a new session while open a new form?

Last Answer : Using open_form built-in setting the session option Ex. Open_form('Stocks ',active,session). when invoke the mulitiple forms with open form and call_form in the same application, state whether the following are true/False

How many minimum groups are required for a matrix report

Description : How many minimum groups are required for a matrix report

Last Answer : The minimum number of groups in matrix report are 4

How does one give developers access to trace files (required as input to tkprof)? (for DBA)

Description : How does one give developers access to trace files (required as input to tkprof)? (for DBA)

Last Answer : The "alter session set sql_trace=true" command generates trace files in USER_DUMP_DEST that can be used by developers as input to tkprof. On Unix the default file mask for these files are "rwx r-- -- ... = true Include this in your INIT.ORA file and bounce your database for it to take effect.

What are the minimum number of groups required for a matrix report

Description : What are the minimum number of groups required for a matrix report

Last Answer : The minimum of groups required for a matrix report are 4 e

How will you estimate the space required by a non- clustered tables?

Description : How will you estimate the space required by a non- clustered tables?

Last Answer : Calculate the total header size Calculate the available dataspace per data block Calculate the combined column lengths of the average row Calculate the total average row size. Calculate the average number rows ... add 10 % additional space to calculate the initial extent size for a working table.

With which function of summary item is the compute at options required?

Description : With which function of summary item is the compute at options required?

Last Answer : ummary item is the compute at options required?

What is the basic data structure that is required for creating an LOV?

Description : What is the basic data structure that is required for creating an LOV?

Last Answer : Record Group.

Cursor disappears from the desktop?

Description : Cursor disappears from the desktop?

Last Answer : Can you see the mouse pointer, or does that also disappear?

Ipad question about correcting and moving cursor?

Description : Ipad question about correcting and moving cursor?

Last Answer : Yes. Just put your finger near the error and hold it there. A “magnifying glass” will appear, with a cursor inside it, and you can move your finger around to place the cursor more precisely.

HTML coders out there: help! You know how you can hover your cursor over certain text for about a second, and then a little text ballon will appear?

Description : HTML coders out there: help! You know how you can hover your cursor over certain text for about a second, and then a little text ballon will appear?

Last Answer : answer:Does blogger allow you to type actual HTML in your blogs? If so, then it’s pretty simple: You see this printed on the page normally

What is there to do when you get the fake hand cursor?

Description : What is there to do when you get the fake hand cursor?

Last Answer : The real hand shows up when I try to click on the email. So I don’t mean at the same trime. Is there a corrective measure is my question?

My cursor and laptop screen are freezing today. Do you know what is causing this?

Description : My cursor and laptop screen are freezing today. Do you know what is causing this?

Last Answer : answer:You likely have what is called malware or adware on your machine. I suspect that because it seems to be giving you trouble when you try to go onto the internet. When you wake' up your ... up your problem. You can find the spybot program here: http://www.safer-networking.org/index2.html

Why has my cursor started jumping around when I type on my computer?

Description : Why has my cursor started jumping around when I type on my computer?

Last Answer : Are you on a laptop? If yes, turn it off, flip it over and try tightening the small screws on the underside. There are 6–10 of them. Sometimes they work lose and the keyboard mouse will begin to wiggle. You’ll need a small Phillips + screwdriver. Let us know how you make out.

What do you call the cross with arrows on each end image that comes on only when your cursor is within the screenshot you captured/trying to capture?

Description : What do you call the cross with arrows on each end image that comes on only when your cursor is within the screenshot you captured/trying to capture?

Last Answer : Please ignore the words “only”, and “trying to capture” in the Question.

I'm not able to move the cursor on my Dell laptop. What gives?

Description : I'm not able to move the cursor on my Dell laptop. What gives?

Last Answer : I’m the very last person to give computer advice, but I had this issue and I have a router on my laptop. My other computer was turned completly off and when I turned it on, everything worked. Note: I am a computer idiot so if this doesn’t seem correct, ignore me.

How do I change my cursor?

Description : How do I change my cursor?

Last Answer : Send a PM to John Powell. Sorry, that’s all I’ve got for ya.

Why does my cursor jump around?

Description : Why does my cursor jump around?

Last Answer : It’s most likely that annoying touch pad that your wrists are touching.

Why can't I insert the cursor to change previously written text in Outlook 2007?

Description : Why can't I insert the cursor to change previously written text in Outlook 2007?

Last Answer : Are you sure you have already hit reply or forward? You have to start the new email to change old text.

Why doesnt the cursor go into the search bar on youtube?

Description : Why doesnt the cursor go into the search bar on youtube?

Last Answer : Best guess: Whoever coded YouTube’s main page did not set it to steal focus.

How do i stop my cursor from flashing on and off all the time?

Description : How do i stop my cursor from flashing on and off all the time?

Last Answer : More details?

I'm using Abiword 2.6 for a word processor. Somehow, I turned on the red cursor of death. How do I turn it off?

Description : I'm using Abiword 2.6 for a word processor. Somehow, I turned on the red cursor of death. How do I turn it off?

Last Answer : Press the “Insert” key on your keyboard. It’s right next to your “Delete”, “Page Up” and “Page Down” keys.

In Excel, have you have ever had this problem with the cursor keys?

Description : In Excel, have you have ever had this problem with the cursor keys?

Last Answer : answer:The whole screen?! Like the desktop and everything… basically all lit pixels? Or do you mean the whole Excel window?

OSX: How do you turn off cursor blinking in all apps (globally)?

Description : OSX: How do you turn off cursor blinking in all apps (globally)?

Last Answer : I hope I’m not asking a stupid question now… Even though I’ve been Mac user since 86, my sore eyes let me find the right method of doing this.

Which of the following shortcut keys brings the cursor to the last cell on the sheet that contains data? -Technology

Description : Which of the following shortcut keys brings the cursor to the last cell on the sheet that contains data? -Technology

Last Answer : (b) Ctrl+End shortcut is used to bring the cursor to the last cell.

Which device is used to control cursor movement ?

Description : Which device is used to control cursor movement ?

Last Answer : Joystick devices are used to control the movement of the cursor.

What is the 'cursor key' of the keyboard ?

Description : What is the 'cursor key' of the keyboard ?

Last Answer : : The arrow keys inserted at the bottom right of the keyboard to control the cursor are called cursor keys . The workspace is specified on the monitor screen by controlling the cursor with the cursor keys. ... using the Ctrl + Home and Ctrl + End keys at the very beginning or end of the document.

What is a cursor ?

Description : What is a cursor ?

Last Answer : The four arrow keys that control the cursor are called cursor keys.

Hover your cursor and click for more information!

Description : http://www.frizou.org/divers/10/18-qui-est-personnage/index.html Have fun :-)))

Last Answer : So Inko, I printed it out and I'll write your names so I don't confuse you: D