[gdal-dev] OGR2OGR - Define output naming from concatenated queries from a DB

D eloquence2 at gmail.com
Fri Aug 8 02:27:27 EDT 2008


>
>  Hi Mateusz,
>>
>> thanks for the help and the sample! I will try to implement it. I have
>> also
>> received a sample from an Oracle DBA how to create a Batch file with a
>> properly defined command line while executing an SQL script with some
>> PL/SQL
>> procedures.
>>
>
> Dejan,
>
> Sounds good.
>
> If interested, I will send it to you, when completed developing and testing
>> it.
>>
>
> IMO, mailing list (ie. as reply to this thread) is better place, so others
> can use it as well.
>

Here is the sample code to start with in PL/SQL and SQL in Oracle.

The typical 'preamble' for doing this in Sql*plus is

set heading off feedback off pagesize 0 newpage 0

Then you could do virtually anything
column dag noprint new_value dag
select to_char(sysdate,'yymmdd') dag
from dual;

spool exp_&dag..bat

select ....
from ....
spool off

host exp_&dag..bat
exit
Best regards,
Dejan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20080808/134e61ab/attachment-0001.html


More information about the gdal-dev mailing list