Re: Informix -> Oracle

From: Hrouda Peter <hrouda_at_eccon.vol.at> >> is there a compareable function in oracle: 1.) SQL
    unload to <abc>.unl select * from abc     load from <abc>.unl insert into abc
2.) PL/SQL
    fetch prev .... or fetch relative -x or fetch absolute
<<

For sql in sqlplus you can use a spool file. Look up the 'set' command to adjust things like linesize, echoing the sql, etc... 'spool filename' is the sqlplus command, and in pl/sql look up the utl_file package for reading/writing to a system file.

For pl/sql I know of no built-in capability to move around inside a cursor, but you can fetch the results of a cursor into pl/sql tables (single dimension arrays in 2.2 and below) and use array indexing to move through them. Multi-diminsional pl/sql arrays are coming, but I am not sure if they are available yet with any commonly available release.

Hope this helps.  

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Sun Mar 01 1998 - 00:00:00 CST