-
Hi all,
If i have a long function and I want to create this function in the database. What I did was copy and paste it in SQL plus, and it stop at line 99.
what command in SQL plus I need type before I can copy and paste the whole thing to SQL Plus???
Thanks
-
do a select, click enter twice, write ed, dleete everything in text, paste the function now
close text editior
run
-
try to set high buffer value
eg ..
set buffer 999999
siva prakash
DBA
-
prakash43,
set buffer doesn't help, it still stop at line 99 in SQL Plus
Pando,
Could you elaborate your suggestion a little , I don't get it
thanks all
-
well when you write a query you can edit it afterwards right by writing ed right?
then just do that write any query then edit the file and paste the text there
-
or simple...
save comple function in .sql file and run that file in SQL*Plus
SQL> @myfunc.sql;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|