RE: OT RE: Select won't work for view create

Yeah
but it makes you look so cool, smooth and important!!!

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Koivu, LisaSent:   Thursday, April 05, 2001 3:12 PMTo: Multiple recipients of list   ORACLE-LSubject: RE: OT RE: Select won't work for view   create
  Yea
  right!  Someone in the office of our new parent company had too much time   on his hands...   

    <FONT face=Tahoma
    size=2>-----Original Message-----From: Mohan, Ross     [mailto:MohanR_at_STARS-SMI.com]Sent: Thursday, April 05, 2001 1:47     PMTo: Multiple recipients of list ORACLE-LSubject: OT     RE: Select won't work for view create     Yea, I noticed
    that.
    <FONT
    face="Courier New"> 
    Lisa musta gotta
    raise.
    <FONT
    face="Courier New"> 
    <FONT
    face="Courier New">(congrats!)
    <BLOCKQUOTE dir=ltr
    style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

      <FONT face="Times New Roman" 
      size=2>-----Original Message-----From: Kevin Kostyszyn 
      [mailto:kevin_at_dulcian.com]Sent: Thursday, April 05, 2001 1:27 
      PMTo: Multiple recipients of list ORACLE-LSubject: 
      RE: Select won't work for view create
      <FONT face=Arial color=#0000ff 
      size=2>Now that is one fancy signature!
      


        <FONT face=Tahoma 

        size=2>-----Original Message-----From: root_at_fatcity.com 
        [mailto:root_at_fatcity.com]On Behalf Of Koivu, LisaSent: 
        Thursday, April 05, 2001 1:03 PMTo: Multiple recipients of 
        list ORACLE-LSubject: RE: Select won't work for view 
        create


        <SPAN 

        class=768480816-05042001>Hi Dan, 


        <SPAN 

        class=768480816-05042001> 


        <SPAN 

        class=768480816-05042001>are you referencing public synonyms in your 
        statement? 


        <SPAN 

        class=768480816-05042001><FONT face=Arial color=#0000ff 
        size=2> 
        
        


        <TABLE style="mso-cellspacing: 0in; mso-padding-alt: 0in 0in 0in 0in" 

        cellSpacing=0 cellPadding=0 border=0>
          
          
            <TD 
            style="PADDING-RIGHT: 0in; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; PADDING-TOP: 0in" 
            vAlign=top colSpan=2>
              
              
              <SPAN 
              style="FONT-SIZE: 15pt; COLOR: navy; FONT-FAMILY: Papyrus; mso-bidi-font-size: 12.0pt">Lisa 
              Rutland Koivu<SPAN 
              style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: 'Monotype Corsiva'"><SPAN 
              style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Verdana">Oracle 
              Database Administratorlkoivu_at_qode.com<SPAN 
              style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana"><IMG 
              id=_x0000_i1026 height=20 
              src="http://www.neom.com/images/email_img/1px.gif" width=1 
              border=0 NOSEND="1"><IMG id=_x0000_i1027 height=26 
              alt=NeoMedia 
              src="http://www.neom.com/images/email_img/neomlogo.gif" width=135 
              border=0 NOSEND="1"><IMG id=_x0000_i1028 height=2 
              src="http://www.neom.com/images/email_img/1px.gif" width=1 
              border=0 NOSEND="1">4850 N. State Rd. 7, 
              #G104
              <SPAN 
              style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana">Ft. 
              Lauderdale, FL 33319
              <SPAN 
              style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana">Phone: 
              954.484.3191
              <SPAN 
              style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana">Fax: 
              954.484.2933
              <SPAN 
              style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana"><A 
              href="http://www.neom.com/">www.neom.com<A 
              href="http://www.paperclick.com/">www.paperclick.com<A 
              href="http://www.qode.com/">www.qode.com<IMG 
              id=_x0000_i1029 height=20 
              src="http://www.neom.com/images/email_img/1px.gif" width=1 
              border=0 NOSEND="1">
          
            <TD 
            style="PADDING-RIGHT: 0in; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; PADDING-TOP: 0in">
              <A 
              href="http://www.paperclick.com/home.htm"><IMG id=_x0000_i1030 
              height=37 alt="P a p e r C l i c k . c o m" 
              src="http://www.neom.com/images/email_img/PaperclickLogoFrameW.gif" 
              width=63 border=0 NOSEND="1">
            <TD 
            style="PADDING-RIGHT: 0in; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; PADDING-TOP: 0in">
               
              
              <SPAN 
              style="DISPLAY: none; mso-hide: all">
          
            <TD 
            style="PADDING-RIGHT: 0in; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; PADDING-TOP: 0in">
              
            <TD 
            style="PADDING-RIGHT: 0in; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; WIDTH: 45pt; PADDING-TOP: 0in" 
            width=60>
               
               
         
        
          <FONT face=Tahoma 
          size=2>-----Original Message-----From: Dasko, Dan 
          [mailto:Dan.Dasko_at_cdicorp.com]Sent: Thursday, April 05, 
          2001 12:36 PMTo: Multiple recipients of list 
          ORACLE-LSubject: Select won't work for view 
          create
          <SPAN 
          class=755183615-05042001>I have a select that works fine.  
          However, it doesn't work fine when I try to create a view of the 
          result set.  There is nothing particularly fancy about the query, 
          just a plethora of outer joins from the main table to the secondary 
          tables.  I get an error back about one of the tables not 
          existing, but like I said, it works as a select, just not as a create 
          view as ... 
          <SPAN 
          class=755183615-05042001> 
          <SPAN 
          class=755183615-05042001>FWIW Oracle 8.0.6 on 
DG-UX
          <SPAN 
          class=755183615-05042001> 
          <SPAN 
          class=755183615-05042001>Dan