aytasirs

 Profile Answers by aytasirs Questions by aytasirs

• Nov 15th, 2012

Use DML Triggers to apply the same action to another table as well.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Write trigger

Answer Question  Select Best Answer

aytasirs

 Profile Answers by aytasirs Questions by aytasirs

• Nov 15th, 2012

Explain plan will tell you

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Use select may be this works

Answer Question  Select Best Answer

aytasirs

 Profile Answers by aytasirs Questions by aytasirs

• Nov 15th, 2012

There is no option to avoid duplicates when inserting data from flatfiles using sql*loader.

The best way is load the data into staging table and write the
query to eliminate the duplicate rows.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Use PK or unique key

Answer Question  Select Best Answer

What is the use of Left Outer & Right Outer Join, Using Equi Join with Union we can do the outer join then why we need to go for Outer Join

aytasirs

 Profile Answers by aytasirs Questions by aytasirs

• Nov 15th, 2012

Left outer Join fetch all the records from Left side Table(Only Condition satisfied records from right side table) where as Right Outer Join fetch all the records from Right side Table(Only Condition satisfied records from Left side table).

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Using Equi Join with Union we can do the outer join then why we need to go for Outer Join -- increase the performance

Answer Question  Select Best Answer

'' Should be used before '%'.

Nazeera Jaffar

• Oct 6th, 2012

The below code selects the column with a substring % (e.g.) reg%istration

Code
 

Nazeera Jaffar

• Sep 30th, 2012

The below code will select the row having column as %

Code
 

Answer Question  Select Best Answer

How to insert a record in two tables with single insert statement ?

Nazeera Jaffar

• Sep 30th, 2012

Answer:

Code
 

chandra411

 Profile Answers by chandra411 Questions by chandra411

• Sep 2nd, 2008

Using merge concept, we can insert a record at a time into two tables.

Answer Question  Select Best Answer

What is the difference between SQL & PLSQL?

Nazeera Jaffar

• Sep 26th, 2012

1.Sql is a declarative language.It tells only what to do. PL/Sql is a procedural language.It tells what to do and how to do. 2.Sql executes DDL and DML statements . Pl/Sql executes triggers,func...

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

sql is structured query language and plsql is procedural sql. in sql we write a query to fetch the data from data base. in pl sql we write the set of sql command and execute it in one times. the benef...

Answer Question  Select Best Answer

Nazeera Jaffar

• Sep 26th, 2012

Delete: Deletes the contents of the table.Also allows us to delete particular row(s) by condition.We can undo the delete operation and write trigger on delete action. Truncate: Delete the ...

lakan reddy

• Sep 21st, 2012

Delete:delets the records from the table by using where claus
truncate:removes all the records from the table and frees the space containing by the table
drop:drops the table and its structure

Answer Question  Select Best Answer

VIJAY SHARMA

• Sep 24th, 2012

Code
span style="color: #ff0000;">"PRIME NUMBERS"

KARRTHIK

• Dec 3rd, 2011

"plsql n number; i number; counter number; begin n:=&n; i:=1; counter:=0; if n=1 then dbms_output.put_line('1 is a prime No.'); else if n=2 ...

Answer Question  Select Best Answer

How to count number of records in a table without using COUNT function?

Sandipan

• Sep 6th, 2012

Select sum(1) from emp;

Code
 

smily08

 Profile Answers by smily08 Questions by smily08

• Aug 30th, 2012

Select max(rownum) from
(select ROW_NUMBER() over (order by col_name) as rowNum from table_name)
withRowNum

Answer Question  Select Best Answer

Naazneen

• Sep 6th, 2012

Using pagination

Code
 

ananymous

• Jan 6th, 2012

The best ans given above is

Code
 

Answer Question  Select Best Answer

manjari_ghosh12

 Profile Answers by manjari_ghosh12 Questions by manjari_ghosh12

• Sep 1st, 2012

Code
 

abhikum.402

• Aug 13th, 2012

Select emp_name from (select *,Dense_RANK()over (order by Emp_sal) SalayRank from Emp_a)A
where SalayRank=10

Answer Question  Select Best Answer

smily08

 Profile Answers by smily08 Questions by smily08

• Aug 30th, 2012

Code
 

smily08

 Profile Answers by smily08 Questions by smily08

• Aug 29th, 2012

Code
 

Answer Question  Select Best Answer

Ayyappa

• Aug 24th, 2012

Hello leelakrishna302 ... Your query ...

Code
 

gives only latest inserted records not the latest updated records..

leelakrishna302

 Profile Answers by leelakrishna302 Questions by leelakrishna302

• Jun 15th, 2012

Select * from emp e where rowid in( select max(rowid) from emp );

Answer Question  Select Best Answer

No.

Shantanu

• Aug 17th, 2012

You cant directly use commit in triggers. You have to use PRAGMA Autonomous_Transaction or you can call other procedure or function, but other procedure or function should also have PRAGMA Autonomous_Transaction in it.

Jagan

• Aug 21st, 2011

Yes, by using autonomous transaction

Answer Question  Select Best Answer

Arbind Kumar Singh

• Jul 23rd, 2012

sql query for retrieving last row particular column value depending upon its ID??? QUERY: select top 1 [column_name1],[column_name2] from [table_name] where ID=[ID_value] order by index desc here i...

Ambarish

• Apr 19th, 2012

Select last(column_name) from Table.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

maverickwild  

 Profile Answers by maverickwild Questions by maverickwild

• Member Since Nov-2005 | Nov 15th, 2005

---

Try this

select sal from (select * from order by sal asc) where rownum < 3

snehal Falke

• Jul 13th, 2012

Select * FROM emp ORDER BY sal ASC LIMIT 2

mohit

• Jun 28th, 2012

If you want to employee name then query is given below

Code
 

Improve Answer

How to retrieve data from two tables of different servers

Sujaya

• Jun 8th, 2012

SELECT Ename, DeptNo, Sal, Emp.DeptNo, Dept.Dname, Dept.Loc, Dept FROM
Emp, Dept
WHERE Emp.DeptNo = Dept.DeptNo;

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

You can use join

Answer Question  Select Best Answer

mfasiur

 Profile Answers by mfasiur Questions by mfasiur

• Jun 7th, 2012

Also, the undo blocks will store all the data until the transaction is either committed or rolled back.So, if someone issues DML statements(insert,update & delete)The before image of the transaction i...

Hany

• Jun 7th, 2012

With No Commit after delete , you will be able to see all record in session 2

Answer Question  Select Best Answer

ngoudjou albert

• May 22nd, 2012

We use the selfjoin on the table employees to retrieve the job before thier managers

Code
 

janardhan g

• Aug 7th, 2011

Select x.ename from emp x,emp y where x.mgr=y.empno and x.hiredate

Answer Question  Select Best Answer