I like your naming conventions :)
but shouldn't it be
from a_table_in_this_database ?
--- Jeffery Stevenson [EMAIL PROTECTED] wrote:
...and you created the view on the other side of the database link
where
none of the tables are remote tables? Basically, on the remote
system you
would
For a second there I thought it was Cobol.
-Original Message-
Sent: Friday, November 09, 2001 5:36 AM
To: Multiple recipients of list ORACLE-L
I like your naming conventions :)
but shouldn't it be
from a_table_in_this_database ?
--- Jeffery Stevenson [EMAIL PROTECTED] wrote:
Not to mention
select this,that
:)
-Original Message-
Sent: Friday, November 09, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L
I like your naming conventions :)
but shouldn't it be
from a_table_in_this_database ?
--- Jeffery Stevenson [EMAIL PROTECTED] wrote:
...and
Unfortunately, I don't think I can do that.. they query itself has a limiting
factor in the start with clause..
i.e.
start with key = (select something from
table_over_here,table_over_here2,table_over_here3,table_over_here4
where a bunch_of_stuff and x=:avaluethatchanges)
I can't make
That doesn't work.. same error. It doesn't like remote tables in the start
with clause whether it's a view or not.
On Thu, 08 Nov 2001 07:50:29 -0800, you wrote:
If all the remote tables are on the same database and you have privileges to
create a view on that remote database, then create a
...and you created the view on the other side of the database link where
none of the tables are remote tables? Basically, on the remote system you
would create a view like this:
create view call_this_from_somewhere_else as
select this and that
from a table in this database
start with primary