failed to retrieve data from all_views from pl/sql [message #318394] |
Tue, 06 May 2008 14:38  |
yashora
Messages: 39 Registered: August 2006
|
Member |
|
|
Hello,
The following sql statement is fetchin records from SQL environment where as it is showing "No Data" in pl/sql procedure. Can you please let me know, why ths is happening and what should i do if i want to fetch the data from pl/sql too.
SELECT OWNER,VIEW_NAME,'DM_'||SUBSTR(OWNER,1,1)||SUBSTR(OWNER,INSTR(OWNER,'_',1)+1,1)||SUBSTR(OWNER,INSTR(OWNER,'_',1,2)+1)
||'_'||VIEW_NAME||'_'||'MV' MVNAME
FROM
ALL_VIEWS
WHERE
OWNER
LIKE
'SOP%';
Thanks and regards
Yashora
|
|
|
|
|
|
|
|