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

INSTR('120000 12 0 .125',1,'.')output 13

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• May 6th, 2010

Select instr(1200120.125, '.')from dualRegardsDharmendra Jaiswal.

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• May 3rd, 2010

Select instr(12000120.125,'.',1) from dual;

Answer Question  Select Best Answer

hindol_saha

 Profile Answers by hindol_saha Questions by hindol_saha

• Jan 19th, 2010

Ref cursor is used for dynamic cursor based on different where clause ,and it is used for fast processing The scope of cursor is limited to a block/ programme. here block/ programme means upto a e...

fiaskhan

 Profile Answers by fiaskhan Questions by fiaskhan

• Dec 4th, 2008

Ref cursor?are used to define cursor variables. It acts as a pointer for memory area.In a single memory?location (context area) we can write any number of select statement. Mainly it is used when you want to fetch data from more than one table.

Answer Question  Select Best Answer

sharib

• Jan 11th, 2007

I think you are wrong.we can write dml in both function and procedure.

Manish

• Nov 23rd, 2006

1. SP can not return the table datatype whereas function can return.2. in UDFunction if one sql statement raise the error then whole function is terminated where in SP if one sql statement raise the error then other sql statement can be executed.

Answer Question  Select Best Answer

Outer Join--Its a join condition used where you can query all the rows of one of the tables in the join condition even though they don’t satisfy the join condition.

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• May 3rd, 2010

OUTER JOIN is the way to collect records in case of lack of true join condition.

patilpravin_1981

 Profile Answers by patilpravin_1981 Questions by patilpravin_1981

• Jan 29th, 2008

outer join is that type of jon which retrives the matach & alson unmatached recores also from the tables

Answer Question  Select Best Answer

select level, min('col_name') from my_table where level = '&n' connect by prior ('col_name') <'col_name')group by level;Example:Given a table called emp with the following columns:-- id number-- name varchar2(20)-- sal number---- For the second lowest salary:-- select level, min(sal) from emp-- where level=2-- connect by prior sal < sal-- group by level

NITYANAND

• Oct 7th, 2007

TO find out nth LOWEST value, e.g. salary from emp table without using ROWNUM & DESC/ASCSELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal))     &...

Ishita

• Oct 4th, 2007

Easiest wayselect top 1 name from emp where name>(select min(name) from emp) order by nameIshita.

Answer Question  Select Best Answer

ashok panguluri

• Feb 11th, 2012

Primary key: The key which is unique and not allow the null values nothing but primary key. Each table contain only one primary key.

Candidate key: The key which is opt for the primary key is nothing but candidate key, the table can contain number of candidate key as per requirement.

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Jan 12th, 2012

Primary key defines the uniqueness of a row. there should be no null value in primary key. The keys which are opt for primary key known as candidate keys. In a table candidate keys are the candidates...

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Feb 26th, 2008

Desc table_name

safdar

 Profile Answers by safdar Questions by safdar

• Feb 14th, 2008

HI I AM SAFDAR DOGAR create table dept1( deptno number(10) constraints pk_deptno primary key, dname varchar2(20), loc varchar2(20 ));desc user_constraints;select constraint_name,constraint_type from user_constraints where table_name='DEPT1';AM I RIGHT

Answer Question  Select Best Answer

Dhiraj

• Aug 29th, 2011

Select distinct * from table_name

shiiva

 Profile Answers by shiiva Questions by shiiva

• Feb 4th, 2011

Delete the Records selected from the below query:select a.* from emp1 a, emp1 bwhere a.empno = b.empnoand a.rowid < b.rowid  shiv

Answer Question  Select Best Answer

Ajay Kumar

• Mar 21st, 2007

9i it supports the Jdeveloper and Application server where 8i doesn't

rakhee

• Sep 11th, 2006

Ora8i doesnt follow all codd rules but ora9i follows all the 12 rules of codd

Answer Question  Select Best Answer

monika1985

 Profile Answers by monika1985 Questions by monika1985

• May 28th, 2008

Select sal from emp ewhere 4=(select count(distinct(sal) from emp where sal>e.sal)

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 9th, 2008

SELECT * FROM  (SELECT  ename ,sal,                   dense_rank() over (ORDER BY sal DESC) max_sal        FROM emp)WHERE max_sal= 5;

Answer Question  Select Best Answer

yagneswarasankar

 Profile Answers by yagneswarasankar Questions by yagneswarasankar

• Dec 2nd, 2010

SQL> select last_name,salary,rn from (select b.*,rownum rn from (select last_name,salary   from employees)b) where mod(rn,2) = 0;LAST_NAME        &...

kowmudiswarna

 Profile Answers by kowmudiswarna Questions by kowmudiswarna

• Sep 25th, 2007

select*from emp where (rowid,1) in(select rowid,mod(rownum,2)  from emp);

Answer Question  Select Best Answer

jomarie

• Sep 2nd, 2014

This is formed when join conditions is omitted or invalid

sampra

 Profile Answers by sampra Questions by sampra

• Feb 26th, 2008

When a join condition is omited when getting  result from two tables then that kind of query gives us Cartesian product, in which all combination of rows displayed. All rows in the first table is joined to all rows of second table......

Answer Question  Select Best Answer

emraan

 Profile Answers by emraan Questions by emraan

• Dec 31st, 2009

Update e set a = case a when 'city' then 'hyd' when 'hyd' then 'city' endperfect and testedImran Baig+91 - 9247519684

sharmasl

 Profile Answers by sharmasl Questions by sharmasl

• Mar 5th, 2009

Update States set city= decode(city,`Delhi`,`Hyderabad`,`Hyderabad`,`Delhi`,city);By using this query we can?inter change the?citys.Thanks,Salil Sharma

Answer Question  Select Best Answer