Answer / subrat

SELECT LEVEL
FROM DUAL
CONNECT BY LEVEL<=9;

Answer / gangadhar

SQL> select *
2 from xmltable('for $i in 1 to 10 return $i');

Answer / hemant

select 1||chr(10)||2||chr(10)||3||chr(10)||4||chr(10)
||5||chr(10)||6||chr(10)||7||chr(10)||8||chr(10)||9||chr(10)
||10 from dual
/

Answer / pushkar

use sequence. automatically increments.

Answer / rashmi raju

select 1,2,3,4,5,6,7,8,9,10 from dual;

Answer / ameer mujahid

select rownum from employees;

Answer / aditya

select 1,2,3,4,5,6,7,8,9,10

Answer / seshu

select in(1,10)
from dual;

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

Is record in oracle pl sql?

0 Answers  

What is foreign key sql?

0 Answers  

What is magic table?

6 Answers  

What are local and global Indexes and where they are useful.

0 Answers  

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,

What are all different types of collation sensitivity?

0 Answers  

What is the use of <> sql?

0 Answers  

What is dynamic sql in pl sql?

0 Answers  

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

Why should I use postgresql?

0 Answers  

Why we use joins in sql?

0 Answers