What are savepoint mode and cursor mode properties ? level?

What are savepoint mode and cursor mode properties ?
level?
by

1 Answer

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 against
ORACLE, use the default setting.
Cursor mode - define cursur state across transaction Open/close.
by

Related questions

what are key-mode and locking mode properties? level ?

Description : what are key-mode and locking mode properties? level ?

Last Answer : Key Mode : Specifies how oracle forms uniquely identifies rows in the database.This is property includes for application that will run against NON-ORACLE datasources . Key setting unique (default.) ... locks on rows that correspond to queried records in the form. a) immediate b) delayed

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

Can you Rollback to any savepoint ?

Description : Can you Rollback to any savepoint ?

Last Answer : Yes.

What is the easiest way to change the phrase, revenues, profits, gross margin, to read revenues, profits, and gross margin? a) Use the insert mode, position the cursor before the g in the gross, then type the word and followed by a space b) Use the insert mode, position the cursor after the g in gross, then type the word and followed by a space c) Use the overtype mode, position the cursor before the g in gross, then type the word and followed by a space d) None of these

Description : What is the easiest way to change the phrase, revenues, profits, gross margin, to read revenues, profits, and gross margin? a) Use the insert mode, position the cursor before the g in the gross, then ... cursor before the g in gross, then type the word and followed by a space d) None of these

Last Answer : a) Use the insert mode, position the cursor before the g in the gross, then type the word and followed by a space

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Last Answer : Break. SYSTEM VARIABLES

What are the values that can be specified for OPTIMIZER MODE Parameter ?

Description : What are the values that can be specified for OPTIMIZER MODE Parameter ?

Last Answer : COST and RULE.

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

Description : Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

Last Answer : ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. ... having to write transactions to an archive log and thus increases the performance of the database slightly.

What is Restricted Mode of Instance Startup ?

Description : What is Restricted Mode of Instance Startup ?

Last Answer : An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilege.

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Description : What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Last Answer : Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.

My database was terminated while in BACKUP MODE, do I need to recover? (for DBA

Description : My database was terminated while in BACKUP MODE, do I need to recover? (for DBA

Last Answer : If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE xyz BEGIN BACKUP;), it will tell you that media recovery is required when you try to restart the ... : ALTER DATABASE END BACKUP; The above commands need to be issued when the database is mounted.

Does Oracle write to data files in begin/hot backup mode? (for DBA

Description : Does Oracle write to data files in begin/hot backup mode? (for DBA

Last Answer : Oracle will stop updating file headers, but will continue to write data to the database files even if a tablespace is in backup mode.In backup mode, Oracle will write out complete changed blocks ... ). Because of this, one should notice increased log activity and archiving during on-line backups.

What is the diff. when confine mode is on and when it is off?

Description : What is the diff. when confine mode is on and when it is off?

Last Answer : When confine mode is on, an object cannot be moved outside its parent in the layout.

What is the diff. when Flex mode is mode on and when it is off?

Description : What is the diff. when Flex mode is mode on and when it is off?

Last Answer : When flex mode is on, reports automatically resizes the parent when the child is resized.

Which command will we use to manage (stop, start…) RAC services in command-line mode?

Description : Which command will we use to manage (stop, start…) RAC services in command-line mode?

Last Answer : srvctl

What are the Various Block Coordination Properties

Description : What are the Various Block Coordination Properties

Last Answer : The various Block Coordination Properties are a) Immediate Default Setting. The Detail records are shown when the Master Record are shown. b) Deffered with Auto Query Oracle Forms defer fetching the ... No Auto Query The operator must navigate to the detail block and explicitly execute a query

What is the built-in used to get and set lov properties during run-time?

Description : What is the built-in used to get and set lov properties during run-time?

Last Answer : Get_lov_property Set_lov_property Record Group

What built-in is used for changing the properties of the window dynamically?

Description : What built-in is used for changing the properties of the window dynamically?

Last Answer : Set_window_property Canvas-View

What are the built-ins that are used for setting the LOV properties at runtime?

Description : What are the built-ins that are used for setting the LOV properties at runtime?

Last Answer : get_lov_property set_lov_property

Name of the functions used to get/set canvas properties?

Description : Name of the functions used to get/set canvas properties?

Last Answer : Get_view_property, Set_view_property

What are the Coordination Properties in a Master-Detail relationship?

Description : What are the Coordination Properties in a Master-Detail relationship?

Last Answer : The coordination properties are Deferred Auto-Query These Properties determine when the population phase of block coordination should occur

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Description : Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Last Answer : a. ON-INSERT b. POST-INSERT c. PRE-INSERT

Which parameter can be used to set read level consistency across multiple queries?

Description : Which parameter can be used to set read level consistency across multiple queries?

Last Answer : Read only

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.