Re: SQL QUERY

Hi,

  An observation on the suggestion :

  If u use "UNION" alone, the view would give u   distinct rows from all the tables.

  If your requirement is to get the exact number of   rows then use "UNION ALL" which would present the   number of rows as it is present...

Regards
Rajagopal Venkataramany

• "T. Ravindran" <ravi_at_oil.asm.nic.in> wrote:
  > Hi,
  >
  > create view table as (
  > select col1,col2,col3,col4 from table1
  > union
  > select col1,col2,col3,col4 from table2 );
  >
  > ravindran
  >
  > ----- Original Message -----
  > To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > Sent: Monday, September 04, 2000 8:50 AM
  >
  >
  > Hi Gurus
  >
  > I require help with creating a view based on
  > multiple tables.
  > There are 22 tables that have the same column names.
  > I need to create a view based on these tables so
  > that each of the tables
  > data is appended to the view.
  >
  > eg TABLE1
  > COL1 COL2 COL3 COL4
  > blah blah blah blah
  > abcd defg jfjfkjf xyz
  >
  > TABLE2
  > COL1 COL2 COL3 COL4
  > what is my name
  > where do I work
  >
  >
  > If I combine the 2 tables into a view it must look
  > like
  >
  > VIEW1
  > COL1 COL2 COL3 COL4
  > blah blah blah blah
  > abcd defg jfkjf xyz
  > what is my name
  > where do I work
  >
  >
  >
  > Any help would be greatly appreciate
  >
  >
  > TIA
  >
  > Suhen Pather
  > Oracle DBA (OCP)
  > Telkom SA
  > Land +27 12 300 4025
  > Mobile +27 82 770 9801
  >
  > --
  > Author: Suhen Pather
  > INET: PatherS5_at_telkom.co.za
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: T. Ravindran
  > INET: ravi_at_oil.asm.nic.in
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---