Write a pl/sql script to display the following series of numbers: 99,96,93&helli

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

Question Posted / ratnakar mishra

1 Answers
4894 Views
I also Faced
E-Mail Answers

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?..

Answer / bhavya

Select
Listagg(rownum*3, ', ') within group (order by rownum desc)
From dual
Connect by level<=100/3;

Is This Answer Correct ?

6 Yes

1 No

Post New Answer

More SQL PLSQL Interview Questions

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers Satyam,

What is a column in a table?

0 Answers

What does count (*) mean?

0 Answers

What is partition by in sql?

0 Answers

What is ROWID?

8 Answers

What is the difference between sql/pl-sql/embeded sql?

3 Answers

What is the result, when NULL is compared with NULL?