i want to display 1 to 10 numbers using one select statement.
Answer Posted / sumit
declare
abc varchar2(500) ;
begin
select 1||chr(0)||2||chr(0)||3 ..... into
abc from dual;
dbms_output.put_line(abc);
end;
cannot use chr(10) to take columns in sql.
way is to use rownum,row_number or any psuedo column like
sequence
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is offset in sql query?
How do I run a query in pl sql developer?
What is difference between procedure and trigger?
What is difference between left and right outer join?
what are the nonstandard string types? : Sql dba
Which one is better sql or oracle?
How many types of keys are there in sql?
What is pl sql commands?
What is scalar function in sql?
What is procedure explain with program?
What are expressions?
How many types of tables are there?
How do you modify a trigger?
Is vs as in pl sql?
Is hadoop a nosql?