OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » reverse view

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

reverse view [message #39344]

Tue, 09 July 2002 07:34

Bob
Messages: 49
Registered: March 1999

Member

Hi i search a script it make a reverse view.
I explain. In user A i got a view name V1 et i want to generate the view in user B.

I use a ult_file but i have some trouble with the long datatype can you help me

Thanks everybody

Report message to a moderator

Re: reverse view [message #39346 is a reply to message #39344]

Tue, 09 July 2002 09:10

andrew again
Messages: 2577
Registered: March 2000

Senior Member

in sqlplus:
set linesize 2000
set long 1000
select * from user_views;

try something like this (untested)...
DECLARE
   v_str   VARCHAR2 (32767);
   v_handle UTL_FILE.file_type;
BEGIN
   SELECT text into v_str FROM user_views
   WHERE view_name = 'ABC';
   v_handle := UTL_FILE.fopen ('/tmp', 'my_view.sql', 'W', 32767);
   UTL_FILE.put_line (v_handle, v_str);
   UTL_FILE.fclose (v_handle);
END;
/

Report message to a moderator

Previous Topic:	please help me in these pl/sql !!
Next Topic:	Table Store In Array ...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 09:43:40 CDT 2024