Explain the usage of WHERE CURRENT OF clause in cursors ?

Explain the usage of WHERE CURRENT OF clause in cursors ?
by

1 Answer

Answer :

WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to
the latest row fetched from a cursor. Database Triggers
by

Related questions

Explain the two type of Cursors ?

Description : Explain the two type of Cursors ?

Last Answer : There are two types of cursors, Implicit Cursor and Explicit Cursor. PL/SQL uses Implicit Cursors for queries. User defined cursors are called Explicit Cursors. They can be declared and used.

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;

What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.

What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error. e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error number)

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Can you use select in FROM clause of SQL select ?

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

Last Answer : Yes.

How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Description : How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Last Answer : Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

When do you use WHERE clause and when do you use HAVING clause?

Description : When do you use WHERE clause and when do you use HAVING clause?

Last Answer : HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.

Which parameter in Storage clause will reduce no. of rows per block?

Description : Which parameter in Storage clause will reduce no. of rows per block?

Last Answer : PCTFREE parameter Row size also reduces no of rows per block.

What is the significance of having storage clause ?

Description : What is the significance of having storage clause ?

Last Answer : We can plan the storage for a table as how much initial extents are required, how much can be extended next, how much % should leave free for managing row updations etc.,

What is a property clause?

Description : What is a property clause?

Last Answer : A property clause is a named object that contains a list of properties and their settings. Once you create a property clause you can base other object on it. An object based on a property can inherit the setting of any property in the clause that makes sense for that object.

Can a property clause itself be based on a property clause?

Description : Can a property clause itself be based on a property clause?

Last Answer : Yes

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

What are the usage of SAVEPOINTS ?value in a session before accessing next value ?

Description : What are the usage of SAVEPOINTS ?value in a session before accessing next value ?

Last Answer : SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.

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.

Other than cursors, what would not be included in a screenshot?

Description : Other than cursors, what would not be included in a screenshot?

Last Answer : Never mind, it can’t be that they can’t be included in the screenshot, since we have seen them in books in google images etc. But why is it not being included in the screenshot I’m taking?

Can i download cursors for my macbook? where?

Description : Can i download cursors for my macbook? where?

Last Answer : mighty mouse is good if you have 10.4 or lower

Which phrase from this passage most clearly shows cursors preoccupation with mastery?

Description : Which phrase from this passage most clearly shows cursors preoccupation with mastery?

Last Answer : Wretched creatures

………………… is preferred method for enforcing data integrity A) Constraints B) Stored Procedure C) Triggers D) Cursors

Description : ………………… is preferred method for enforcing data integrity A) Constraints B) Stored Procedure C) Triggers D) Cursors

Last Answer : A) Constraints

……………. is a preferred method for enforcing data integrity A) Constraints B) Stored procedure C) Triggers D) Cursors

Description : ……………. is a preferred method for enforcing data integrity A) Constraints B) Stored procedure C) Triggers D) Cursors

Last Answer : A) Constraints

What is Current record attribute property?

Description : What is Current record attribute property?

Last Answer : Specifies the named visual attribute used when an item is part of the current record. Current Record Attribute is frequently used at the block level to display the current row in a multi-record ... current record, but you cannot dynamically highlight the current item, as the input focus changes.

How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?

Description : How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?

Last Answer : Sequence name CURRVAL, Sequence name NEXTVAL.It is not possible. Only if you access next value in the session, current value can be accessed.

How can you view all the current users connected in your database in this moment?

Description : How can you view all the current users connected in your database in this moment?

Last Answer : SELECT COUNT(*),USERNAME FROM V$SESSION GROUP BY USERNAME;

Fraudulent usage, inability to attract potentially brand -loyal customers, and use by current customers but not new customers, are believed to be disadvantages of which of the following? A)Sweepstakes B)Money refunds C)Frequent -user incentives D)Coupons E)Premiums

Description : Fraudulent usage, inability to attract potentially brand -loyal customers, and use by current customers but not new customers, are believed to be disadvantages of which of the following? A)Sweepstakes B)Money refunds C)Frequent -user incentives D)Coupons E)Premiums

Last Answer : D)Coupons

Explain UNION,MINUS,UNION ALL, INTERSECT ?

Description : Explain UNION,MINUS,UNION ALL, INTERSECT ?

Last Answer : INTERSECT returns all distinct rows selected by both queries.MINUS - returns all distinct rows selected by the first query but not by the second.UNION - returns all distinct rows selected by either queryUNION ALL - returns all rows selected by either query, including all duplicates.

Explain what partitioning is and what its benefit is.

Description : Explain what partitioning is and what its benefit is.

Last Answer : Partitioning is a method of taking large tables and indexes and splitting them into smaller, more manageable pieces.

Explain materialized views and how they are used.

Description : Explain materialized views and how they are used.

Last Answer : Materialized views are objects that are reduced sets of information that have been summarized, grouped, or aggregated from base tables. They are typically used in data warehouse or decision support systems.

Explain the use of table functions.

Description : Explain the use of table functions.

Last Answer : Table functions are designed to return a set of rows through PL/SQL logic but are intended to be used as a normal table or view in a SQL statement. They are also used to pipeline information in an ETL process.

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Description : Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Last Answer : A function and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a single task. While a procedure does not have to return any ... functions and procedures that are grouped together based on their commonality to a business function or application.

Explain the use of setting GLOBAL_NAMES equal to TRUE.

Description : Explain the use of setting GLOBAL_NAMES equal to TRUE.

Last Answer : Setting GLOBAL_NAMES dictates how you might connect to a database. This variable is either TRUE or FALSE and if it is set to TRUE it enforces database links to have the same name as the remote database to which they are linking.

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

Description : Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

Last Answer : ORACLE_BASE is the root directory for oracle. ORACLE_HOME located beneath ORACLE_BASE is where the oracle products reside.

Explain an ORA-01555

Description : Explain an ORA-01555

Last Answer : You get this error when you get a snapshot too old within rollback. It can usually be solved by increasing the undo retention or increasing the size of rollbacks. You should also look at the logic involved in the application getting the error message.

How would you go about generating an EXPLAIN plan?

Description : How would you go about generating an EXPLAIN plan?

Last Answer : Create a plan table with utlxplan.sql. Use the explain plan set statement_id = 'tst1' into plan_table for a SQL statement Look at the explain plan with utlxplp.sql or utlxpls.sql

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.

Explain the difference between a data block, an extent and a segment.

Description : Explain the difference between a data block, an extent and a segment.

Last Answer : A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings ... that an object takes when grouped together are considered the segment of the database object.

Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Description : Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Last Answer : A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is ... and thus there will be a slight performance gain as the database is not cutting archive logs to disk.

What is a join ? Explain the different types of joins ?

Description : What is a join ? Explain the different types of joins ?

Last Answer : Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join - ... that query can also retrieve rows that do not have corresponding join value in the other table.

Explain Connect by Prior ?in a session before accessing next value ?

Description : Explain Connect by Prior ?in a session before accessing next value ?

Last Answer : Retrieves rows in hierarchical order.e.g. select empno, ename from emp where.

Explain how procedures and functions are called in a PL/SQL block ?

Description : Explain how procedures and functions are called in a PL/SQL block ?

Last Answer : Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');

Explain the following file extension related to library?

Description : Explain the following file extension related to library?

Last Answer : .pll,.lib,.pld The library pll files is a portable design file comparable to an fmb form file The library lib file is a plat form specific, generated library file comparable to a fmx form file The pld file is Txt format file and can be used for source controlling your library files Parameter

Explain types of Block in forms4.0?

Description : Explain types of Block in forms4.0?

Last Answer : Base table Blocks. Control Blocks. 1. A base table block is one that is associated with a specific database table or view. 2. A control block is a block that is not associated with a database table. ITEMS

Explain about stacked canvas views?

Description : Explain about stacked canvas views?

Last Answer : Stacked canvas view is displayed in a window on top of, or "stacked" on the content canvas view assigned to that same window. Stacked canvas views obscure some part of the underlying content canvas view, and or often shown and hidden programmatically.

Explain about horizontal, Vertical tool bar canvas views?

Description : Explain about horizontal, Vertical tool bar canvas views?

Last Answer : Tool bar canvas views are used to create tool bars for individual windows. Horizontal tool bars are display at the top of a window, just under its menu bar. Vertical Tool bars are displayed along the left side of a window

What is a Database instance ? Explain

Description : What is a Database instance ? Explain

Last Answer : A database instance (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The memory structure that are ... helps up to improve database performance by decreasing the amount of I/O performed against data file.

What is a deadlock ? Explain .

Description : What is a deadlock ? Explain .

Last Answer : Two processes wating to update the rows of a table which are locked by the other process then deadlock arises. In a database environment this will often happen because of not issuing ... when a commit/rollback operation performed or any one of this processes being killed externally.

Explain the relationship among Database, Tablespace and Data file.?

Description : Explain the relationship among Database, Tablespace and Data file.?

Last Answer : Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace

Explain the relationship among database, tablespace and data file.

Description : Explain the relationship among database, tablespace and data file.

Last Answer : Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.

Does PL/SQL support “overloading”? Explain

Description : Does PL/SQL support “overloading”? Explain

Last Answer : The concept of overloading in PL/SQL relates to the idea that you can define procedures and functions with the same name. PL/SQL does not look only at the referenced name, however, ... Prefacing a procedure or function name with the package name fully qualifies any procedure or function reference.

Explain Oracle memory structure

Description : Explain Oracle memory structure

Last Answer : The Oracle RDBMS creates and uses storage on the computer hard disk and in random access memory (RAM). The portion in the computer s RAM is called memory structure. Oracle has two memory structures ... the user has retrieved from the database or data that the user wants to place into the database.

Explain the differences between SHUTDOWN, SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE AND SHUTDOWN ABORT.

Description : Explain the differences between SHUTDOWN, SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE AND SHUTDOWN ABORT.

Last Answer : SHUTOWN NORMAL = SHUTDOWN : It waits for all sessions to end, without allowing new connections. SHUTDOWN IMMEDIATE : Rollback current transactions and terminates every session. SHUTDOWN ABORT : Aborts all ... in an inconsistent state. It's the fastest method, but can lead to database corruption.