About dhargaurav

dhargaurav · ‎06-17-2013

Thanks for the quick response. the above works when I union all the same table but how about different tables. select ship_via, ship_via_desc from ship_via where ship_via in ('F150','F750') union all select ship_via, count(ship_via) from carton_hdr where carton_nbr in (SELECT rpt_parm from RPT_REQST_Q WHERE STAT_CODE = 93 AND CREATE_DATE_TIME > SYSDATE - 1) group by ship_via

dhargaurav · ‎06-17-2013

I want to run 2 select statements in one search. something like select * from my_table; select * from your_table; When I use the ; it gives me an error A database error occurred: ORA-00911: invalid character

Posts	4
Solutions	0
Karma Given	1
Karma Received	1
Member Since	‎06-05-2013

Online Status	Offline
Date Last Visited	‎06-05-2020 02:04 AM

Select Statements

Re: Select Statements

Select Statements

Join the Conversation

Select Statements

Re: Select Statements

Select Statements