rayavarapu

 Profile Answers by rayavarapu Questions by rayavarapu

• Jan 23rd, 2013

Null is not a value and not a string. It is unknown it is maximum in descending order and minimum value in ascending order.

Sandeep

• Mar 7th, 2012

Char(0)

Answer Question  Select Best Answer

In what ways can data be copied from one table to another?

Neeraj Saxena

• Apr 12th, 2013

You can copy the data from one table to another with the help of below Query:

Suppose dummy is the main table and we need to copy the data from dummy_120413 table.

Create tabel dummy_120413 as Select * from dummy;

Answer Question  Select Best Answer

rajkumar1237

 Profile Answers by rajkumar1237 Questions by rajkumar1237

• Apr 27th, 2013

OCI means::oracle call interface.is a interface api used to access oracle database from C programs. Data Guard stands for it is multiple DB servers environment configured for Physical as well as Logic...

Answer Question  Select Best Answer

There are 2 tables, A and B having 3 rows each. What will be result on executing the following query? : SQL> select * from A,B

Raju TT

• Jun 11th, 2013

Cross join -cartesian product :Table a no. of rows (3) * Table b no.of rows (3)= cross join query returns 9 rows

Code
 

Arpit Agrawal

• May 24th, 2013

Here simply answer would be 6. Since a is having 2 rows and b is having 3 rows. And we go for Cartesian join, which means 3*2=6.

Answer Question  Select Best Answer

Vinod Tuteja

• Jun 14th, 2013

Main Difference : Referential
Index is created in both Cases (Unique and Primary key Constraint )

But can't references Columns with combination of UNIQUE and NOT NULL. Like in Primary key ,we Can references primary key to make foreign key constraint .

z_ashwini

 Profile Answers by z_ashwini Questions by z_ashwini

• Jan 13th, 2012

Eg: Consider table emp with EMP_ID,EM|NAME,ADD columns You can define the column e_name as Unique constraint. DECLARE e_name number(10) NOT NULL; BEGIN ... .. END: Primary key cannot have NU...

Answer Question  Select Best Answer

Is it possible to use function inside a trigger.

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 16th, 2013

Code
span style="font-style: italic;">--referencing old as old and new as new

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 16th, 2013

Yes, by using CALL statement.

Answer Question  Select Best Answer

Varun Tiwari

• Jul 4th, 2013

Any data transaction control statement can not be used in triggers. As trigger invokes due to any DML event and the transaction may not be successfully commit later and may need to complete rollback.

Pragma_autonomous can be used as an alternate way to commit.

prashant mhatre

• Jun 13th, 2013

Can not used ...if we want to use it inside the trigger then use pragma_autonomous.

Answer Question  Select Best Answer

Create a query using “ group by” that shows maximum salary for each department?

lviswanath

 Profile Answers by lviswanath Questions by lviswanath

• Jul 17th, 2013

Code
 

Answer Question  Select Best Answer

If there are 2 overloaded procedure, one among then have 1 IN parameter and another have 2 parameters. Both procedures parameters are of default type.

What will happen when you will call package.procedure without any parameter?

Khamar

• Jul 22nd, 2013

You will get an error message "PLS-0037: too many declarations of procedure_name match this call"

Answer Question  Select Best Answer

DEPARTMENT_ID EMP_COUNT DEPT_PERCENTAGE

lviswanath

 Profile Answers by lviswanath Questions by lviswanath

• Jul 23rd, 2013

Ask the question clearly

what is DEPT_PERCENTAGE

on what basis we have to calculate DEPT_PERCENTAGE?

Answer Question  Select Best Answer

JILEY SINGH

 Profile Answers by JILEY SINGH Questions by JILEY SINGH

• Aug 4th, 2013

Function can be called in select statement but procedure cant be called in select statement. function has return keyword but procedure not

Varun Tiwari

• Jul 4th, 2013

Function Procedure 1. Can be used as column Cant used in select statement in select statement 2. Can be used in where Cant used in where condition c...

Answer Question  Select Best Answer

Procedure A calls procedure B. A updates table t1, t2. B updates table t3. If some error happens to B what happens to the updates in all those tables? Whether they will rollback or commit? If commits how far it will commit?

vishal.bhadange

 Profile Answers by vishal.bhadange Questions by vishal.bhadange

• Aug 24th, 2013

CASE 1 (If you are not handling exception in Procedure B, none of the table gets updated) "sql PROCEDURE A BEGIN UPDATE TABLE t1; UPDATE TABLE t2; CALL PROCEDURE ...

Answer Question  Select Best Answer

Difference between PL/SQL table and Global Temporary Table. why we use Global Temporary Table without using PL/SQL Table.

nivi

• Sep 3rd, 2013

1.Global Temporary table is stored in Temporary tablespace while PL/SQL table is stored in PGA. 2.SQL operations can not be performed on pl/sql tables whereas it can be performed on GTT as any normal...

plsqlgeek

 Profile Answers by plsqlgeek Questions by plsqlgeek

• Aug 16th, 2013

PL/SQL table or associated array is a collection (data type). Where as GTT is a temp table created to store/process data for a particular session. Once you log out of the session the data is gone, not the table structure.

Answer Question  Select Best Answer

Suresh kumar patra

• Sep 10th, 2013

SQL>ed

Then Window Will Open,You Can Change Your Code.

Vinod Tuteja

• Jun 18th, 2013

Simply Write

SQL>ed

Then Window Will Open,You Can Change Your Code .

Answer Question  Select Best Answer

Malar somu

 Profile Answers by Malar somu Questions by Malar somu

• Sep 10th, 2013

Implicit Cursor:- It is Oracle implicit type.. when we fetch only one record then we need to use implicit cursor i.e when ever we performing select query or any dml operations termed as implicit curso...

hira

• Aug 8th, 2013

When ever any query execute by the server in database sever itself create a implicit cursor ,which can not any control to the programmer but in case explicit cursor the programmer has to create it.and used for the data manipulation by following some rule......

Answer Question  Select Best Answer

How do you reference a (updated) table from procedure A which is being updated by another procedure B?

Lalit

• Sep 15th, 2013

By taking help of global temporary table.

Answer Question  Select Best Answer

1-WHAT IS DIFF BETWEEN VARRAY AND TABLE?2-WHAT IS SQL SUPPORT FOR NESTED TABLE?3-WHAT IS INLINE STORAGE AND OUT OF LINE STOGARE OF THE NESTED TABLE?4-WHAT ARE COMMON EXCEPTION RELATED WITH COLLECTION?5-CAN U DECLARE VARRAY OF VARRAY OF VARRAY OF TABLE?6-GIVE SAMPLE DEFINATION OF VARRAY OF OBJECT AND TABLE OF OBJECT?7-WHAT ARE COMMON METHODS OF HANDLING EXCEPTIONS?

subhashishchaki

 Profile Answers by subhashishchaki Questions by subhashishchaki

• Oct 7th, 2013

Collections similarities and differences Collection Type Elements Limit Subscript Type Uninitialized Status Always Dense ----------------------------------------------------------...

basukolur014

 Profile Answers by basukolur014 Questions by basukolur014

• Feb 28th, 2011

Exceptions related to collections are...1.collection_is_null2.collection subscript beyond count3.collection subscript outside limit4.no_data_found .these are more common exceptions  related to collections.

Answer Question  Select Best Answer

How to call/reference a cursor defined in a procedure A from another procedure B?

How to pass a cursor as a parameter of a cursor?

UTTAM GHOSH

• Oct 31st, 2013

How I can an Ac dynamo of a car/vehicle test with a12v dc battery good or bad

Pavan

• Aug 27th, 2013

This can be done by using REFCURSORS.

Answer Question  Select Best Answer

What are bind variables in sql? explain in detail?

pradipta

 Profile Answers by pradipta Questions by pradipta

• Feb 8th, 2014

The way to get Oracle to reuse the execution plans for "the statements having different hard coded value in where clause" there should use bind variables. Bind variables are ?substitution? variable...

Aarti

• Jan 15th, 2014

Bind variable is session specific variable. It is declared using variable keyword. Bind variable cant be used in named block. It cant have default value.

Answer Question  Select Best Answer

Pixie

• Feb 18th, 2014

PL/SQL tables are PL/SQLs way of providing arrays. They are temporary tables in memory and thus are processed very quickly. They are not database tables, and DML statements cannot be issued against...

sbagai2001

 Profile Answers by sbagai2001 Questions by sbagai2001

• May 30th, 2006

DECLARE   TYPE EmpCurTyp IS REF CURSOR;   // Reference Cursor - weak    TYPE NumList IS TABLE OF NUMBER;  // Table of Number   TYPE NameList IS TABLE OF VA...

Answer Question  Select Best Answer