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

How to write a query in SQL 2005 in order to Select 10 random records from table?

ASHOK PANGULURI

• Feb 11th, 2012

Code
 

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Jan 12th, 2012

Code
 

Answer Question  Select Best Answer

How to fetch alternate rows from the table?

Ram

• Feb 6th, 2013

Code
 

Millar

• Jul 26th, 2012

Code
span style="font-style: italic;">--to find even rows in a table
--to find even rows in a table
--to find odd rows in a table

Answer Question  Select Best Answer

S_NAME MARKS
ramu 60
ramu 40
ramu 50
karan 30
karan 96
karan 46

out put:
ramu "PASS"
karan "FAIL"

Elangovan

• Aug 13th, 2015

Code
 

Ritesh Kumar

• Mar 24th, 2015

"sql WITH t1 AS (SELECT name, COUNT ( result ) as tt_sub_pass FROM student WHERE result >= 40 group by name ...

Answer Question  Select Best Answer

Delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); ordelete duplicate_values_field_name dv from table_name ta where rowid <(select min(rowid) from table_name tb where ta.dv=tb.dv);

thirupathireddy

 Profile Answers by thirupathireddy Questions by thirupathireddy

• Feb 2nd, 2010

DELETE FROM table_name a WHERE rowid > (SELECT min(rowid) FROM table_name b WHERE a.column_name=b.column_name)

syam sundar

• Aug 18th, 2007

Delete table_name t1where rowid>(select rowid from table_name t2)and t1.column1=t2.column1

Answer Question  Select Best Answer

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

SELECTCONNECTRESOURCES

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• Apr 30th, 2010

A user can give all database privilages to another user, which are also has that user.

patilpravin_1981

 Profile Answers by patilpravin_1981 Questions by patilpravin_1981

• Jan 29th, 2008

objectes privileges such asselect,delete,update,connect

Answer Question  Select Best Answer

Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However, for the purpose of increasing performance, oracle allows a developer to create a CLUSTER. A CLUSTER provides a means for storing data from different tables together for faster retrieval than if the table placement were left to the RDBMS.

sumanamara2016

 Profile Answers by sumanamara2016 Questions by sumanamara2016

• Mar 18th, 2016

CLUSTERS A cluster is a schema object that contains data from one or more tables If you two are more tables are joined together on a single column and most of the time you issue join queries on ...

VIKRAM

• Dec 18th, 2015

In this case does the cluster avoid the JOIN Condition or not?

Answer Question  Select Best Answer

Cursor For Loop is a loop where oracle implicitly declares a loop variable, the loop index that of the same record type as the cursor's record.

narmadac

 Profile Answers by narmadac Questions by narmadac

• Feb 11th, 2010

A cursor for loop can be used instead of explicit cursors.  A cursor for loop  implicitly opens, fetches rows, closes a cursor.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

The cursor FOR loop is a shortcut to process explicit cursors. Implicit open, fetch, exit, and close occur. The record is implicitly declared.

Answer Question  Select Best Answer

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Oct 23rd, 2007

As in case of normalization and properly index conditions and order of coulumns are not require to care the pointer of the new record created at last. This will be managed by the indexes and orders of...

Madhu

• Mar 24th, 2007

Suppose a table dept contains 3 columns say deptno,dname and loc.If u want to change the order of dname and loc in reverse,then write  a query as followscreate table dept1 as  (select deptno,loc,dname from dept);drop table dept;create table dept as (select * from dept1); 

Answer Question  Select Best Answer

vishnu vardhan reddy

 Profile Answers by vishnu vardhan reddy Questions by vishnu vardhan reddy

• Sep 16th, 2008

To join a table itself is called self join.

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 22nd, 2008

Join the table to itself is called self join. It is used when you need to join the data with the same table data.Ex:- SELECT A.ENAME,A.SAL ,B.ENAME,B.SAL        FROM EMP A,EMP B      WHERE A.MGR = B.EMPNO

Answer Question  Select Best Answer