Partial view of user created views
VPSJan 17 2007 — edited Jan 27 2007Friends,
sql>select text from user_views
where view_name='SMCLIENT_FOLDER_MAP_V';
when i run the above query im able to see the text but the below are missing how come?
CREATE OR REPLACE FORCE VIEW "SMCLIENT_FOLDER_MAP_V"
(
"FOLDER_ID",
"CLIENT_ID"
)
AS
The view which iam having is...
CREATE OR REPLACE FORCE VIEW "SMCLIENT_FOLDER_MAP_V"
(
"FOLDER_ID",
"CLIENT_ID"
)
AS select
f.id folder_id,
h.id client_id
from SMclient_only_folder_v f,
SMBreakableLinks b,
SMclient_v h
where
f.id = b.lhsid
and h.id = b.rhsid
/
thanks
sathyguy
Message was edited by:
sathyguy