Vijay

• Mar 20th, 2013

By using merge statement we can do it simply.

smi

• Jul 30th, 2012

Use merge stat

Answer Question  Select Best Answer

Nasim

• Dec 19th, 2006

Maximum we can write 28 triggres on table3 -> insert, update and delete4 -> combination of insert, update and delete2 -> trigger type (for each row and statement)2 -> trigger event (before and after)(3+4)*2*2 = 28

Girdhar Singh

• Aug 22nd, 2006

  total 12 trigger we created but we write trigger how much we want

Answer Question  Select Best Answer

vaibhav Tyagi

 Profile Answers by vaibhav Tyagi Questions by vaibhav Tyagi

• Oct 21st, 2007

Create proc EarnMoneyProcasdeclare @earn int,@total int,@tempday int,@TotDays int set @earn=1set @tempday=1set @total=0set @Totdays = 50*365print @Totdayswhile(@tempday <= @Totdays  )beginset @earn = @earn + 2;set @tempday =@tempday+1print @earnendprint @total

Srinivasa Pavan

• Jan 9th, 2007

hai allam a new to this site and i can give a solution to this Question and here is the coding for that.declare result number :=1;inc number ?:=2;year number :=1;i number;beginwhile??(?year?<=50?)?...

Answer Question  Select Best Answer

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 22nd, 2008

%tye and %rowtype provide data independence and allows programs to adapt to database changes due to new business requirement.%type is used to declare a variable with same datatype as that of...

BASVARAJ KOLUR

• Mar 9th, 2007

the %type will return datatyp attached to refernced column or itemex: v_a emp.empid%type;it will return datatype attched to empid of emp table. the %rowtype will return all datatype attached ever...

Answer Question  Select Best Answer

harshasp

 Profile Answers by harshasp Questions by harshasp

• Jul 16th, 2008

To join ntable we need n-1 join conditions....And whenever we are not able to retrieve the data using Joins..we use Subqueries...Writing the conditions to query throught join is difficult but through subquery its easy.and performance wise Joins are good...

krishnaveni_g

 Profile Answers by krishnaveni_g Questions by krishnaveni_g

• Jul 16th, 2008

we want to join n table we need n-1 join conditions.  There is no limitation. Some queries not solved by using the joins we can go for subqueries.  Performance wise joins is better.

Answer Question  Select Best Answer

vinoth.jeevanandam

 Profile Answers by vinoth.jeevanandam Questions by vinoth.jeevanandam

• Mar 3rd, 2009

You cannot use =, >, >= on rownum operator. Instead you can have,select employee_id from (select row_number() over(order by employee_id asc) as rn, employee_id from employees) where rn=2;select employee_id from (select rownum as rn, employee_id from employees) where rn=2;

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 22nd, 2008

We should not use >, >=,  =  with rownum.It do not show any error message but returns 0 rows.Here select ename,job,salfrom emp where rownum = 2;Rownum always assigns rownum 1 to first ...

Answer Question  Select Best Answer

Sujata Bisoi

• Mar 8th, 2007

 i think it will perfectly work:-            delete empname from emp A where  rowid > (select min(rowid) from emp B where A.ename = B.ename);

Pawan Ahuja

• Dec 3rd, 2006

Delete from where rowid not in (select min(rowid) from group by col1,col2....)RegardsPawan Ahuja

Answer Question  Select Best Answer

YASODHA

• Aug 29th, 2011

Insert is faster than delete because insert just add values to the table. but delete want to store the deleted data in the memory for future references

Rakesh

• Jul 22nd, 2011

Both insert and delete are used for different purposes. Also inserts are not always faster than delete. If the table has got indexes then insert will be slow and delete will be fast (if the WHERE cla...

Answer Question  Select Best Answer

What does Toad mean? How it's work?

vinodsahani

 Profile Answers by vinodsahani Questions by vinodsahani

• May 18th, 2010

Toad is a freeware, powerful, low-overhead tool used by database designer and application developers for faster and easier and simplifies day-to-day administration of various relational databases.

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• May 7th, 2010

It is just a Tool that uses for writing database statements and PL/SQL.

Answer Question  Select Best Answer

%ROWCOUNT%NOTFOUND%FOUND%ISOPEN

narmadac

 Profile Answers by narmadac Questions by narmadac

• Feb 11th, 2010

Cursor attributes when appended to the cursor name allow the users to access useful information from the retrieved rows.  After opening a cursor a 'fetch' statement is used to fetch rows from the...

syam sundar

• Aug 17th, 2007

%ROWTYPE - returns number of the rows which are fetched/updated/deleted%ISOPEN    - returns true if the cursor is open%FOUND     - returns true if the cursor fetched any row%NOTFOUND-returns true if the cursor does not fetch any row

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 13th, 2008

The DUAL table is owned by the user SYS and can be accessed by all users. It contains one column, DUMMY, and one row with the value X. The DUAL table is useful when you want to return a value once onl...

kowmudiswarna

 Profile Answers by kowmudiswarna Questions by kowmudiswarna

• Sep 13th, 2007

Hi,The data type of column of dual table is character data type  i.e  varchar2

Answer Question  Select Best Answer

Papa Rao

• Oct 18th, 2017

In cross join one table of each row compare with each row another table is called Cartesian Join.

Venkatesh

• Sep 20th, 2017

If result is same, what is the use of two joins?

Answer Question  Select Best Answer

sumanta.bala

 Profile Answers by sumanta.bala Questions by sumanta.bala

• Jun 5th, 2009

SELECT ename,deptno,sal,TRUNC (AVG (sal) OVER (PARTITION BY deptno)) avg_sal FROM scott.emp

arun_doss

 Profile Answers by arun_doss Questions by arun_doss

• Mar 13th, 2008

SELECT empno, sal, ( SELECT SUM ( a.sal )                          &nb...

Answer Question  Select Best Answer

janagap

 Profile Answers by janagap Questions by janagap

• Feb 15th, 2008

Select plk,zin,count(*) from tablegroup by gin;

ualike

 Profile Answers by ualike Questions by ualike

• Dec 5th, 2006

Here it is, considering plk and zin are two attributes of a table zp)SELECT COUNT(*) as "Pluks"FROM zpGROUP BY zin;

Answer Question  Select Best Answer

Arjunya

 Profile Answers by Arjunya Questions by Arjunya

• Apr 29th, 2010

SELECT XFROM YWHERE MOD(X,3) = 1;Where X is the column name and Y is the table name.

ganne

• Aug 2nd, 2006

Select rownum,empno from emp group by rownum,empno having mod(rownum,3)=1;

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

LEVELYou use LEVEL with the SELECT CONNECT BY statement to organize rows from a database table into a tree structure. LEVEL returns the level number of a node in a tree structure. The root is level 1, children of the root are level 2, grandchildren are level 3, and so on.

Tatyana

• May 5th, 2006

Sorry, sorry, I am wrong. Rowid is a pseudocolumn.

Answer Question  Select Best Answer

Nicsmart

 Profile Answers by Nicsmart Questions by Nicsmart

• Mar 31st, 2010

A mutating table is a table that is currently being modified by an INSERT,UPDATE,DELETE statement or a table that might need to be updated by the effects of a declarative DELETE CASCADE referential in...

Nasim

• Aug 24th, 2007

One solution also exist:create a row level trigger and insert/update the data and take it in collections( varray or nested table or associative array). Then write a after statement level trigger and fetch that data.

Answer Question  Select Best Answer

ashok rajagopal

• Dec 14th, 2006

This is how the index works in simple terms. When you add a row to a table, the rowid of that row plus a few other info is store in a separate area which is dedicated to keep it.  Lets say you de...

sibgatullah

• Dec 13th, 2006

Effective use of index will speed up your query execution time.

Answer Question  Select Best Answer

sindhu

• Aug 2nd, 2007

Thanks for your answer.It helped me alot for my interview.

BinduJoseph

 Profile Answers by BinduJoseph Questions by BinduJoseph

• Jan 22nd, 2007

First lets consider these two tables. AKey Data----------- ----------1 a 2 b  BKey Data----------- ----------1 c 3 d ...

Answer Question  Select Best Answer

Name

• Mar 23rd, 2015

Nope. Thats SQL server.

mukeshkoshym

 Profile Answers by mukeshkoshym Questions by mukeshkoshym

• Nov 26th, 2009

In simpleVarchar2 works with 8 bit characters where as Nvarchar2 works ith 16 bit characters.If you have to store data other than english prefer Nvarchar2 or viceversa.

Answer Question  Select Best Answer