What a SELECT FOR UPDATE cursor represent.?

What a SELECT FOR UPDATE cursor represent.?
by

1 Answer

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 modifying the rows is
done by a method with two parts: the FOR UPDATE clause in the cursor
declaration, WHERE CURRENT OF CLAUSE in an UPDATE or declaration
statement.
by

Related questions

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 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 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.

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

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

Last 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.

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 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 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 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 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.

What is the usage of an ON-INSERT,ON-DELETE and ON- UPDATE TRIGGERS ? These triggers are execu

Description : What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ? These triggers are execu

Last Answer : These triggers are executes when inserting, deleting and updating operations are performed and can be used to change the default function of insert, delete or update respectively. For Eg, instead of inserting a row in a table an existing row can be updated in the same table.

If you update an assignment record multiple times in a single day, can you still track the record, if yes how?

Description : If you update an assignment record multiple times in a single day, can you still track the record, if yes how?

Last Answer : For some objects, such as assignments, more than one update per day is maintained by creating a physical record for each update. Such objects include an effective sequence number in each physical record to show the order in which updates made to an object on a single day were applied.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How do u implement the If statement in the Select Statement

Description : How do u implement the If statement in the Select Statement

Last Answer : We can implement the if statement in the select statement by using the Decode statement. e.g select DECODE (EMP_CAT,'1','First','2','Second'Null); Here the Null is the else statement where null is done .

Can a formula column be obtained through a select statement?

Description : Can a formula column be obtained through a select statement?

Last Answer : Yes

Can you use select in FROM clause of SQL select ?

Description : Can you use select in FROM clause of SQL select ?

Last Answer : Yes.

Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Last Answer : SELECT customer_no, payments from customer C1 WHERE 3

maxvalue.sql Select the Nth Highest value from a table?

Description : maxvalue.sql Select the Nth Highest value from a table?

Last Answer : select level, max('col_name') from my_table where level = '&n' connect by prior ('col_name') > 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , max(sal) from emp -- where level=2 -- connect by prior sal > sal -- group by level

minvalue.sql Select the Nth lowest value from a table?

Description : minvalue.sql Select the Nth lowest value from a table?

Last Answer : select level, min('col_name') from my_table where level = '&n' connect by prior ('col_name') < 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , min(sal) from emp -- where level=2 -- connect by prior sal < sal -- group by level

How is it possible to select generate a select set for the query in the query property sheet?

Description : How is it possible to select generate a select set for the query in the query property sheet?

Last Answer : By using the tables/columns button and then specifying the table and the column names.

What is a difference between pre-select and pre-query?

Description : What is a difference between pre-select and pre-query?

Last Answer : Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires ... the query criteria in enter query mode.Pre-query trigger fires before pre-select trigger.

Select ‘NORTH’, CUSTOMER From CUST_DTLS Where REGION = ‘N’ Order By CUSTOMER Union Select ‘EAST’, CUSTOMER From CUST_DTLS Where REGION = ‘E’ Order By CUSTOMER The above is a) Not an error b) Error - the string in single quotes ‘NORTH’ and ‘SOUTH’ c) Error - the string should be in double quotes d) Error - ORDER BY clause

Description : Select NORTH', CUSTOMER From CUST_DTLS Where REGION = N' Order By CUSTOMER Union Select EAST', CUSTOMER From CUST_DTLS Where REGION = E' Order By CUSTOMER The above is a) Not an error b) Error - ... ' and SOUTH' c) Error - the string should be in double quotes d) Error - ORDER BY clause

Last Answer : d) Error - ORDER BY clause

Can you audit SELECT statements?

Description : Can you audit SELECT statements?

Last Answer : YES. But beware; you will need a storage mechanism to hold your SQL SELECT audits, a high data volume that can exceed the size of your whole database, every day. SQL SELECT auditing can be ... data in the audit trail must also be audited to see who has selected data from the audit trail.

SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?

Description : SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?

Last Answer : The table has a BLOB column.

Will a user be able to modify a table with SELECT only privilege?

Description : Will a user be able to modify a table with SELECT only privilege?

Last Answer : He won’t be able to UPDATE/INSERT into that table, but for some reason, he will still be able to lock a certain table.

The statement in SQL which allows to change the definition of a table is (A) Alter. (B) Update. (C) Create. (D) select.

Description : The statement in SQL which allows to change the definition of a table is (A) Alter. (B) Update. (C) Create. (D) select

Last Answer : (A) Alter.

As a new project manager, Karen was worried about a statement from her client: “your project deliverable is in low quality with low grade”. According to PMBOK, how can you help Karen distinguish the differences between “quality” and “grade”? Select one: a. Quality and grade represent the same thing. b. Low quality can never be a problem, but low grade is. c. Low quality represents a true problem, but low grade might not be the case. d. Low quality with high grade is always desirable to your client. e. High quality always represents high grade.

Description : As a new project manager, Karen was worried about a statement from  her client: your project deliverable is in low quality with low grade .  According to PMBOK, how can you help Karen ... quality with high grade is always desirable to your client. e. High quality always  represents high grade.

Last Answer : c. Low quality represents a true problem, but low grade might not be the case.

Select the right option from the given alternatives. Smear : Libel :: Heed : ________ (a) Represent (b) Doubt (c) Consider (d) Need

Description : Select the right option from the given alternatives. Smear : Libel :: Heed : ________ (a) Represent (b) Doubt (c) Consider (d) Need

Last Answer : Ans: c) consider 

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?