Home » SQL & PL/SQL » SQL & PL/SQL » help sql
help sql [message #222799] Tue, 06 March 2007 07:33 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member

help me
i have table emp

empno ename
1 srinu
2 ravi
3 krina
4 rama


i want to

empno
1
2
3
4
srinu
ravi
krina
rama


thanks
srinivas
Re: help sql [message #222802 is a reply to message #222799] Tue, 06 March 2007 07:41 Go to previous message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Maybe something like :

select to_char(emp_no) from emp
union
select ename from emp

Previous Topic: fetching values from different columns
Next Topic: DATABASE REFRESH
Goto Forum:
  


Current Time: Wed Dec 07 04:51:12 CST 2016

Total time taken to generate the page: 0.26554 seconds