Difference between an implicit & an explicit cursor.?

Difference between an implicit & an explicit cursor.?
by

1 Answer

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 assigned to a SELECT
statement via the CURSOR...IS statement. An implicit cursor is used for
all SQL statements Declare, Open, Fetch, Close. An explicit cursors are
used to process multirow SELECT statements An implicit cursor is used
to process INSERT, UPDATE, DELETE and single row SELECT. .INTO
by

Related questions

What is the Difference between an implicit cost and explicit cost?

Description : What is the Difference between an implicit cost and explicit cost?

Last Answer : What is the answer ?

The difference between accounting profits and economic profits is: A. Implicit Cost B. explicit costs C. Fixed Costs D. Variable Costs

Description : The difference between accounting profits and economic profits is: A. Implicit Cost B. explicit costs C. Fixed Costs D. Variable Costs

Last Answer : ANSWER: A

Define what is the difference between Implicit wait and Explicit wait?

Description : Define what is the difference between Implicit wait and Explicit wait?

Last Answer : Implicit Wait: Sets a timeout for all successive Web Element searches. For the specified amount of time, it will try looking for element again and again before throwing a NoSuchElementException. It waits for elements to ... How up. Explicit Wait: It is a one-timer, used for a particular search./p>

Explicit and implicit values of "I Have a Dream"?

Description : Explicit and implicit values of "I Have a Dream"?

Last Answer : answer:I haven't heard that speech in many years. But I would think that the bulk of it's content would be considered implicit . The speech,as he(MLK) framed it was a story of an abstract reality. A ... and compare them to some of Obama's. Then watch some of Hitler's, and compare them to Trump's

Which of the following is not a method to describe a curve mathematically? a.Explicit form b.Laplace form c.Implicit form d.Parametric form

Description : Which of the following is not a method to describe a curve mathematically? a.Explicit form b.Laplace form c.Implicit form d.Parametric form

Last Answer : b.Laplace form

CHOOSE THE WORD FROM THE OPTIONS WHICH IS NEARLY OPPOSITE IN MEANING TO THE GIVENWORD: Obscure A. Academic B. Implicit C. Explicit D. Ugly

Description : CHOOSE THE WORD FROM THE OPTIONS WHICH IS NEARLY OPPOSITE IN MEANING TO THE GIVENWORD: Obscure A. Academic B. Implicit C. Explicit D. Ugly

Last Answer : ANSWER: C

CHOOSE THE WORD FROM THE OPTIONS WHICH IS NEARLY OPPOSITE IN MEANING TO THE GIVENWORD: Obscure A. Academic 103 B. Implicit C. Explicit D. Ugly

Description : CHOOSE THE WORD FROM THE OPTIONS WHICH IS NEARLY OPPOSITE IN MEANING TO THE GIVENWORD: Obscure A. Academic 103 B. Implicit C. Explicit D. Ugly

Last Answer : ANSWER: C

CHOOSE THE WORD FROM THE OPTIONS WHICH IS NEARLY OPPOSITE IN MEANING TO THE GIVENWORD: Obscure A. Academic B. Implicit C. Explicit D. Ugly

Description : CHOOSE THE WORD FROM THE OPTIONS WHICH IS NEARLY OPPOSITE IN MEANING TO THE GIVENWORD: Obscure A. Academic B. Implicit C. Explicit D. Ugly

Last Answer : ANSWER: C

Transfer earning or alternative cost is otherwise known as - (1) Variable cost (2) Implicit cost (3) Explicit cost. (4) Opportunity cost

Description : Transfer earning or alternative cost is otherwise known as - (1) Variable cost (2) Implicit cost (3) Explicit cost. (4) Opportunity cost

Last Answer : (4) Opportunity cost

he non-expenditure costs which arise when the producing firm itself owns and supplies certain factors of production are - (1) Explicit costs (2) Original costs (3) Implicit costs (4) Replacement costs

Description : he non-expenditure costs which arise when the producing firm itself owns and supplies certain factors of production are - (1) Explicit costs (2) Original costs (3) Implicit costs (4) Replacement costs

Last Answer : (3) Implicit costs Explanation: In economics, an implicit is the opportunity cost equal to what a firm must give up in order to use factors which it neither purchases nor hires. It is ... instead of renting, selling or lending it. These are costs a business incurs without actually spending money.

Explain when a type conversion will undergo an implicit cast and when you must perform an explicit cast. What are the dangers associated with explicit casts?

Description : Explain when a type conversion will undergo an implicit cast and when you must perform an explicit cast. What are the dangers associated with explicit casts?

Last Answer : Types can be implicitly converted when the conversion can always take place without any potential loss of data. When a potential loss of data is possible, an explicit cast is required. If an explicit cast is improperly performed, a loss of data precision can result, or an exception can be thrown.

Is constructor or destructor inheritance explicit or implicit? What does this mean?

Description : Is constructor or destructor inheritance explicit or implicit? What does this mean?

Last Answer : Constructor or destructor inheritance is explicit…. Public Extended : base() this is called the constructor initializer.

What is explicit vs. implicit conversion?

Description : What is explicit vs. implicit conversion?

Last Answer : When converting from a smaller numeric type into a larger one the cast is implicit. An example of when an explicit cast is needed is when a value may be truncated. 

Which functions are used as preferences over state history? a) Award b) Reward c) Explicit d) Implicit

Description : Which functions are used as preferences over state history? a) Award b) Reward c) Explicit d) Implicit

Last Answer : b) Reward

As the instruction length increases ————_ of instruction addresses in all the instruction is_ a. Implicit inclusion b. Implicit and disadvantageous c. Explicit and disadvantageous d. Explicit and disadvantageous

Description : As the instruction length increases ————_ of instruction addresses in all the instruction is_ a. Implicit inclusion b. Implicit and disadvantageous c. Explicit and disadvantageous d. Explicit and disadvantageous

Last Answer : c. Explicit and disadvantageous

Match the following types of variables with the corresponding programming languages: (a) Static variables (i) Local variables in Pascal (b) Stack dynamic (ii) All variables in APL (c) Explicit heap dynamic (iii) Fortran 77 (d) Implicit heap dynamic (iv) All objects in JAVA Codes: (a) (b) (c) (d) (A) (i) (iii) (iv) (ii) (B) (iv) (i) (iii) (ii) (C) (iii) (i) (iv) (ii) (D) (ii) (i) (iii) (iv)

Description : Match the following types of variables with the corresponding programming languages: (a) Static variables (i) Local variables in Pascal (b) Stack dynamic (ii) All variables in APL (c) Explicit heap dynamic (iii) Fortran 77 (d) Implicit ... (ii) (C) (iii) (i) (iv) (ii) (D) (ii) (i) (iii) (iv)

Last Answer : (C) (iii) (i) (iv) (ii) 

The non-expenditure costs which arise when the producing firm itself owns and supplies certain factors of production are (1) Explicit costs (2) Original costs (3) Implicit costs (4) Replacement costs

Description : The non-expenditure costs which arise when the producing firm itself owns and supplies certain factors of production are (1) Explicit costs (2) Original costs (3) Implicit costs (4) Replacement costs

Last Answer :  Implicit costs

Transfer earning or alternative cost is otherwise known as (1) Variable cost (2) Implicit cost (3) Explicit cost (4) Opportunity cost (economic cost)

Description : Transfer earning or alternative cost is otherwise known as (1) Variable cost (2) Implicit cost (3) Explicit cost (4) Opportunity cost (economic cost) 

Last Answer : Opportunity cost (economic cost)

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

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 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 difference between TRUNCATE & DELETE ?

Description : What is difference between TRUNCATE & DELETE ?

Last Answer : TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database triggers fire on DELETE.

What is difference between a PROCEDURE & FUNCTION ?

Description : What is difference between a PROCEDURE & FUNCTION ?

Last Answer : A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or may not return at all.

What is the difference between OLE Server & Ole Container?

Description : What is the difference between OLE Server & Ole Container?

Last Answer : An Ole server application creates ole Objects that are embedded or linked in ole Containers ex. Ole servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate ... are created by ole server applications. Ex. oracle forms is an example of an ole Container.

What is the difference between object embedding & linking in Oracle forms?

Description : What is the difference between object embedding & linking in Oracle forms?

Last Answer : In Oracle forms, Embedded objects become part of the form module, and linked objects are references from a form module to a linked source file.

What are the difference between lov & list item?

Description : What are the difference between lov & list item?

Last Answer : Lov is a property where as list item is an item. A list item can have only one column, lov can have one or more columns.

Fill in the blank. The _____ is the difference between the additional money spent on prevention and the corresponding reduction in the cost of failure. Select one: a. cost-benefit analysis b. implicit cost c. cost of quality d. variable cost e. cost-utility analysis

Description : Fill in the blank. The _____ is the difference between the additional money spent on  prevention and the corresponding reduction in the cost of failure. Select one: a. cost-benefit analysis b. implicit cost c. cost of quality d. variable cost e. cost-utility analysis

Last Answer : c. cost of quality

What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?

Description : What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?

Last Answer : An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.

What is the main diff. bet. Reports 2.0 & Reports 2.5?

Description : What is the main diff. bet. Reports 2.0 & Reports 2.5?

Last Answer : Report 2.5 is object oriented.

To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Description : To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Last Answer : & physical page no.

What is the frame & repeating frame?

Description : What is the frame & repeating frame?

Last Answer : A frame is a holder for a group of fields. A repeating frame is used to display a set of records when the no. of records that are to displayed is not known before.

What is a physical page ? & What is a logical page ?

Description : What is a physical page ? & What is a logical page ?

Last Answer : A physical page is a size of a page. That is output by the printer. The logical page is the size of one page of the actual report as seen in the Previewer.

How can values be passed bet. precompiler exits & Oracle call interface?

Description : How can values be passed bet. precompiler exits & Oracle call interface?

Last Answer : By using the statement EXECIAFGET & EXECIAFPUT.

How is link tool operation different bet. reports 2 & 2.5?

Description : How is link tool operation different bet. reports 2 & 2.5?

Last Answer : In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.

Spurious tuples may occur due to i. Bad normalization ii. Theta joins iii. Updating tables from join a) i& ii b) ii & iii c) i& iii d) ii & iii

Description : Spurious tuples may occur due to i. Bad normalization ii. Theta joins iii. Updating tables from join a) i& ii b) ii & iii c) i& iii d) ii & iii

Last Answer : a) i& ii b) ii & iii

Would you be more or less likely to purchase music that came with a label warning the listener of implicit lyrics?

Description : Would you be more or less likely to purchase music that came with a label warning the listener of implicit lyrics?

Last Answer : I would suppose that “implicit” referred to graphic sexual (or possibly violent) content as opposed to cussing. If I were buying it for young children, either label would steer me away. If it’s for an adult, neither would.