Home » SQL & PL/SQL » SQL & PL/SQL » simple select command
simple select command [message #421892] Fri, 11 September 2009 08:08 Go to next message
contactsanjaykumar
Messages: 1
Registered: September 2009
Location: Banglore
Junior Member
How to display the content of two table sequentially.
Re: simple select command [message #421893 is a reply to message #421892] Fri, 11 September 2009 08:09 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
by selecting one after the other.
Interview question by any chance?
Re: simple select command [message #421918 is a reply to message #421892] Fri, 11 September 2009 12:59 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
The name of the table makes no difference. Whether it is EMP or DEPT or even TWO, use
select * from two order by <sequence column>;
Re: simple select command [message #421925 is a reply to message #421892] Fri, 11 September 2009 20:08 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SELECT * FROM TAB1;
SELECT * FROM TAB2;
Previous Topic: Convert number to date using numtodsinterval and timestamp
Next Topic: remove duplicate data in other columns
Goto Forum:
  


Current Time: Sat Dec 10 08:40:43 CST 2016

Total time taken to generate the page: 0.09452 seconds