The Null column in the output will come in the last i.e at the end. WHY?e.g COMM 1200 1000 1300 1450 ---- (NULL) ---- (NULL)

SAMADREHMANY

 Profile Answers by SAMADREHMANY Questions by SAMADREHMANY

• Dec 25th, 2012

SEE THIS ALSO,

Code
 

Anurag Puranik

• Jul 29th, 2006

Nulls are unassigned and unavailable values.i.e. null means "no value".So in order to obtain values the values get preference over the no values(null).

Answer Question  Select Best Answer

SAMADREHMANY

 Profile Answers by SAMADREHMANY Questions by SAMADREHMANY

• Dec 25th, 2012

G means Grid Computing..

Sundaresan

• Aug 29th, 2006

Grid computing

Answer Question  Select Best Answer

aytasirs

 Profile Answers by aytasirs Questions by aytasirs

• Nov 15th, 2012

No data found is an exception where as %not found is a cursor attribute.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

No data found is exception where as %notfound is retrn by exception

Answer Question  Select Best Answer

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