Odd number of records:select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp);Output:-135Even number of records:select * from emp where (rowid,0) in (select rowid, mod(rownum,2) from emp)Output:-246

RAMESH

• Oct 12th, 2011

FOR ODD:- "sql SELECT * FROM (SELECT E.*, ROWNUM rn FROM departments E) WHERE MOD (rn, 2) = 1; FOR EVEN:- "sql SELECT * ...

patilpravin_1981

 Profile Answers by patilpravin_1981 Questions by patilpravin_1981

• Jan 30th, 2008

select rownum from dual where rownum=(select rownum/2 0 from dual)

Answer Question  Select Best Answer

ieddy

 Profile Answers by ieddy Questions by ieddy

• Jan 7th, 2009

#5 ??Update x Set x.Salary = (Select? avg(e.salary)*2 'Salary' --, m.Employee_id --, m.Employee_Name,m.salary??? From (employee m join employee e on m.employee_id = e.manager_id and m.manager_id...

diana

• Oct 26th, 2007

#5 -UPDATE xSET salary = ( SELECT AVG(a.salary)*2                      FROM employees a JOIN employees b ON  ...

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Feb 26th, 2008

the ROWNUM is a number(like serial no) which is dynamically changes.but the ROWID does not change.Because it is having the unique address,which is generated by the oracle

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

Rowid:  Hexadecimal string representing the unique address of a row in its table. This datatype is primarily for values returned by the ROWID pseudocolumn.  Rownum: For each row returned by ...

Answer Question  Select Best Answer

nis1981

 Profile Answers by nis1981 Questions by nis1981

• Aug 10th, 2008

Select t1.id, t1.name, t1.salfrom test t1, test t2where t1.id = t2.idand t1.sal < t2.sal;

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 9th, 2008

SELECT   id,  name,  MIN(sal)FROM   test_emp   GROUP BY id,name;

Answer Question  Select Best Answer

How data is stored in database?

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

All data are stored in o and 1 format means binary form

anjali

• Jul 28th, 2011

All data are stored in o and 1 format means binary form

Answer Question  Select Best Answer

May

• Apr 28th, 2021

It clearly mentioned "without using group by".

fire_starter

 Profile Answers by fire_starter Questions by fire_starter

• Oct 9th, 2011

You can use union A union result will eliminate the duplicate rows ( for info, if one wants the duplicate rows preserved, that the UNION ALL should be used). For example we have a table called test_...

Answer Question  Select Best Answer

LONG RAW data type is used for storing BLOB's (binary large objects).

Shankha

• Apr 17th, 2020

I greatly appreciate you for coming to this guide on datatype is used to store picture can be uploaded and retrieved. Yet I would discourage this store picture in a database because traditional ...

goyal_tarun

• May 3rd, 2007

Hi,BLOB is generally used to store pictures. It stands for Binary Large Object. The maximum storage limit is 4GB. There is also one limitation using BLOB, you can have only one column of type BLOB.Cheers,Tarun

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

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Procedure wont retrun any value but it can return many values on condition. but function always returns a values

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 28th, 2007

A procedure is used to perform a specific task. It can also return a value but its not mandatory.But a function is used to perform some calculations and it is mandatory to return atleast one value.

Answer Question  Select Best Answer

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 9th, 2008

SELECT   e.ename || ' '|| e.sal || ' ' || e1.ename || ' '|| e1.salFROM   EMP E ,  emp e1WHERE   e.sal < e1.sal

venkat2182

 Profile Answers by venkat2182 Questions by venkat2182

• Aug 9th, 2007

Hi....I hope u know about "self-join". The following query will give the above result.SELECT e1.name,e1.salary,e2.name,e2.salary FROM emp_test e1,emp_test e2WHERE e1.name='Jones' FRO...

Answer Question  Select Best Answer

sudeep

• Mar 30th, 2007

Hi...select (count(distinct mgr)/count(*) * 100) from emp;Rgds,deeps..

Vijay

• Feb 16th, 2007

Above query will work but you have to take care of division by zero error.You can use this also SELECT (mag_count/total_count)*100 percentage FROM (SELECT COUNT(*) mag_count FROM emp WHERE desg='MANG'...

Answer Question  Select Best Answer

jaspreet.nagra

 Profile Answers by jaspreet.nagra Questions by jaspreet.nagra

• Jul 14th, 2009

Assume you have following two tables:SQL> select * from aa;DAT   NAME----   --------1       Amit2       JasSQL&g...

dmadhusudhanarao

 Profile Answers by dmadhusudhanarao Questions by dmadhusudhanarao

• Aug 2nd, 2006

assume that 2 table are emp,deptnow write query like thisselect * from emp,deptthe out put is emp has 14 records and dept has 4 recordsthen output is 14x4=56 records you will simply.

Answer Question  Select Best Answer

sau326

 Profile Answers by sau326 Questions by sau326

• Jul 19th, 2010

SELECT TOP 2 employeenumber FROM employees WHERE employeenumber NOT IN(SELECT TOP 1 employeenumber FROM employees)Regards,Saurabh

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 9th, 2008

SELECT   *FROM   (SELECT empno,  ename,  sal ,  rank() over(ORDER BY empno) e FROM emp)WHERE   e IN (2,3);

Answer Question  Select Best Answer

kranthi swaroop

• Dec 3rd, 2011

In simple way View is a mirror to a master table.. View are two types 1) SIMPLE View 2) COMPLEX View We will not Define anywhere SIMPLE or COMPLEX while creating a view. Depending Upon the query ...

subhransu mohapatra

• Nov 2nd, 2011

It will not accept DML statement..because complex view contain multiple table...therefore oracle can't understand which data will insert or update in which table...

Answer Question  Select Best Answer

kowmudiswarna

 Profile Answers by kowmudiswarna Questions by kowmudiswarna

• Sep 25th, 2007

select count(*) from all_users;

Kannan

• Jan 6th, 2007

Sybase:sp_who will help to find the available users.....select * from sysusers - it used to find the no.of users in ur DB

Answer Question  Select Best Answer

hindol_saha

 Profile Answers by hindol_saha Questions by hindol_saha

• Mar 27th, 2007

Using Self join like.Delete from emp where id in (select id from emp a,emp b                    &nbs...

madhuk17

 Profile Answers by madhuk17 Questions by madhuk17

• Feb 18th, 2007

Delete from emp a where rowid not in(select min(rowid) from emp b where a.empno=b.empno);

Answer Question  Select Best Answer

gwilson5

 Profile Answers by gwilson5 Questions by gwilson5

• Sep 4th, 2010

A cursor variable is a variable that points to or refernces an underlying cursor.? Unlike an explicit cursor, which names the PL/SQL work area for the result set, a cursor variable is a reference to ...

Raj_P

 Profile Answers by Raj_P Questions by Raj_P

• Sep 1st, 2010

I think, You can use SYS_Cursor.

Answer Question  Select Best Answer

What is the literal meaning of SQL

bhagare

 Profile Answers by bhagare Questions by bhagare

• Feb 5th, 2014

Structure quary launguge

nagarjuna

• Nov 21st, 2013

The terms literal and constant value are synonymous and refer to a fixed data value.For example, JACK, BLUE ISLAND, and 101 are all character literals

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

vishnu vardhan reddy

 Profile Answers by vishnu vardhan reddy Questions by vishnu vardhan reddy

• Sep 16th, 2008

select e.* from( select enmae,sal,   dense_rank()  over(partition by deptno           order by sal) ranksal from emp)e  where e.ra...

hiasat

 Profile Answers by hiasat Questions by hiasat

• Aug 4th, 2008

SELECT empno,ename,salFROM ( select empno,ename,sal from emp order by sal asc )WHERE rownum

Answer Question  Select Best Answer