avinash khatri

• Jan 19th, 2007

 

we  can   do it by conctening the variable with the query in the plsql program.

Deepak

• Jan 24th, 2007

 

Try this in Oracleselect rownum from where rownum < &N ;

lakshaman

 Profile Answers by lakshaman 

• Jan 24th, 2007

 

SELECT * FROM (SELECT LEVEL FROM dual CONNECT BY LEVEL < 10);

kaledhananjay

• Feb 6th, 2007

 

Try this SELECT NVL(MAX(EMPNO)+1, 0) FROM EMP; It create empno from 0..N.

kaledhananjay

• Feb 6th, 2007

 

SELECT NVL(MAX(EMPNO)+1,0) FROM EMP;This select statement generates empno from 0...N.