ORA-cache

Write SQL query to fetch all rows from the table having specific value in any one of the columns without using or keyword?

Ans: select * from table where 'specific value' in (column_1,column_2,....column_n)

This is the moment that we all were waiting for the last 13 years.We remained unbeaten throughout the tournament.Congratulations to Team India on a spectacular Victory and a phenomenal performance throughout the tournament!

Surya, what a brilliant catch! Rohit, this win is a testament to your leadership. Rahul Dravid sir, we know team India will miss your guidance.

The spectacular Men in Blue have made our country proud.

Rohit,Virat Kohli and Rahul Dravid sir you truly deserved this type of farewell.

What is the use of a WHEN clause in a trigger?

A WHEN clause specifies the condition that must be true for the trigger to be triggered.

What is the purpose of %type data type? Explain with example.

It assigns a variable the same data type used by the column, for which the variable is created. For example,

dcode := dept.detpno%type;

The variable dcode is created with the same data type as that of the deptno column of the dept table.

How can you assign a Name to an Un-Named PL/SQL Exception Block?

You can assign a name to an Un-Named Exception using Pragma, also known as Exception_init.

Is there a PL/SQL Engine in SQL*Plus?

SQL*Plus does not have an SQL Engine. Thus, all your PL/SQL are sent directly to the database engine for ex*****on. This makes it comparatively more efficient as SQL statements are not uncovered and sent to the database individually.

What is context switch in Oracle ?

In a PL/SQL block if you are using SQL statements, then in that case when PL/SQL engine encounters any SQL statements then it transfers the control to SQL engine to execute the SQL statements and then SQL engine executes the statements and returns the control back to PL/SQL engine. This switching between SQL and PL/SQL engine is called context switch.

What is context switch in Oracle ?

In a PL/SQL block if you are using SQL statements, then in that case when PL/SQL engine encounters any SQL statements then it transfers the control to SQL engine to execute the SQL statements and then SQL engine executes the statements and returns the control back to PL/SQL engine. This switching between SQL and PL/SQL engine is called context switch.