OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » Query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query [message #537210]

Tue, 27 December 2011 05:17

aallan
Messages: 150
Registered: October 2011

Senior Member

Dear All;
i have output query in 1 row, for example

Id           Name       Salary
100          John       2000

i need to output the same query in vertical way like:

100
John
2000

Please help ?

Report message to a moderator

Re: Query [message #537243 is a reply to message #537210]

Tue, 27 December 2011 06:25

cookiemonster
Messages: 13926
Registered: September 2008
Location: Rainy Manchester

Senior Member

Since this is the forms forum I would assume this question is about forms.
In which case the answer is to arrange your datablock items vertically.
Is this a forms question?

Report message to a moderator

Re: Query [message #537246 is a reply to message #537243]

Tue, 27 December 2011 06:37

aallan
Messages: 150
Registered: October 2011

Senior Member

thanks cookiemonster for reply
im sorry, i must wrote it in PL section
i need it in sql query or pl code

Report message to a moderator

Re: Query [message #537255 is a reply to message #537246]

Tue, 27 December 2011 07:02

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

One:

SQL> select deptno, dname, loc from dept where deptno = 10;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK

Two:

SQL> select deptno || chr(10) ||
  2         dname  || chr(10) ||
  3         loc
  4  from dept
  5  where deptno = 10;

DEPTNO||CHR(10)||DNAME||CHR(10)||LOC
-------------------------------------------------------------
10
ACCOUNTING
NEW YORK


SQL>

Report message to a moderator

Previous Topic:	regarding sound track..
Next Topic:	Clear the Block If Value Change

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 15 14:51:05 CDT 2024