| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Select won't work for view create
With
apologies to Oracle Corporation...
<IMG height=30 src="cid:783454116_at_05042001-17fe" width=127
v:shapes="_x0000_i1025">
Hope they don't sue me. ;-)
<FONT face=Tahoma
size=2>-----Original Message-----From: root_at_fatcity.com
[mailto:root_at_fatcity.com]On Behalf Of Kevin KostyszynSent:
Thursday, April 05, 2001 10:27 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Select won't work for view
create
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
Hi
Dan,
<SPAN
class=768480816-05042001>
<SPAN
class=768480816-05042001>are you referencing public synonyms in your
statement?
<SPAN
class=768480816-05042001><FONT color=#0000ff face=Arial
size=2>
<TABLE border=0 cellPadding=0 cellSpacing=0 style="mso-cellspacing: 0in; mso-padding-alt: 0in 0in 0in 0in">
<TD colSpan=2
style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; PADDING-TOP: 0in"
vAlign=top>
<SPAN
style="COLOR: navy; FONT-FAMILY: Papyrus; FONT-SIZE: 15pt; mso-bidi-font-size: 12.0pt">Lisa
Rutland Koivu<SPAN
style="COLOR: navy; FONT-FAMILY: 'Monotype Corsiva'; FONT-SIZE: 7.5pt"><SPAN
style="COLOR: navy; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Oracle
Database Administratorlkoivu_at_qode.com<SPAN
style="COLOR: navy; FONT-FAMILY: Verdana; FONT-SIZE: 7.5pt"><IMG
border=0 height=20 id=_x0000_i1026
src="http://www.neom.com/images/email_img/1px.gif" width=1
NOSEND="1"><IMG alt=NeoMedia border=0 height=26 id=_x0000_i1027
src="http://www.neom.com/images/email_img/neomlogo.gif" width=135
NOSEND="1"><IMG border=0 height=2 id=_x0000_i1028
src="http://www.neom.com/images/email_img/1px.gif" width=1
NOSEND="1">4850 N. State Rd. 7, #G104
<SPAN
style="COLOR: navy; FONT-FAMILY: Verdana; FONT-SIZE: 7.5pt">Ft.
Lauderdale, FL 33319
<SPAN
style="COLOR: navy; FONT-FAMILY: Verdana; FONT-SIZE: 7.5pt">Phone:
954.484.3191
<SPAN
style="COLOR: navy; FONT-FAMILY: Verdana; FONT-SIZE: 7.5pt">Fax:
954.484.2933
<SPAN
style="COLOR: navy; FONT-FAMILY: Verdana; FONT-SIZE: 7.5pt"><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 border=0
height=20 id=_x0000_i1029
src="http://www.neom.com/images/email_img/1px.gif" width=1
NOSEND="1">
<TD
style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; PADDING-TOP: 0in">
<A
href="http://www.paperclick.com/home.htm"><IMG
alt="P a p e r C l i c k . c o m" border=0 height=37 id=_x0000_i1030
src="http://www.neom.com/images/email_img/PaperclickLogoFrameW.gif"
width=63 NOSEND="1">
<TD
style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; PADDING-TOP: 0in">
<TD
style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; PADDING-TOP: 0in">
<TD
style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; PADDING-TOP: 0in; WIDTH: 45pt"
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
Received on Thu Apr 05 2001 - 11:53:32 CDT
 |
 |