var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I faced on problem with files how i can achive this,This is relate of migration issue i.e
i have all scripts related source and target in directories and all scripts contain select statements,
My question in when i am run one script all of the source and target script must be
executed and the results are stored in the result table
How i can achive this
I'm not sure I understand the question.
You have "scripts" (these are files that contain some SQL statements) you want to run one script which will execute all "source" and "target" scripts (whatever they are). OK, no problem - put all script names into one file - don't forget the @ sign in front of them! results stored in the "result table"? What is the "result table"? Is it a file that'd contain spooled output? If so - spool it!
Here's an example: there are three files: a.sql, b.sql and caller.sql (which will call a.sql and b.sql):
Here's how you'd execute it:
select 'A' who_am_i from dual;
select 'B' who_am_i from dual;
And the "result.txt" file:
SQL> column who_am_i format a10
SQL> spool result.txt
SQL> spool off;
Is that what you are talking about? If not, try to explain it once again (or wait for another opinion - maybe someone did understand what you are saying).
SQL> spool off;
Its good idea and i am using that
But i have faced one more problem when i am useing this,
my script Name is ut.sql
it works fine when i am executing in SQL*PLUS...
but i need to execute this script(out.sql) in plsql blook.. Is it possible?
If yes means How? if No means Why?
I am trying to this
SQL> select'@'||'out.pdc' from dual;
execute immediate '@out.sql';
It is also gives an error;;
How i can achive this problem..
i need to execute the Out.pdc script in plsql.....
Thanks to all
Well, that would be a problem. Two workarounds: the first one you've already seen - call SQL scripts from another SQL script.
Another one is to "convert" SQL scripts into PL/SQL procedures and call those procedures from your PL/SQL procedure.
Otherwise, Google for "Oracle how to call SQL script from PL/SQL"; I'm afraid you won't be happy with the results.