data unload in oracle 11g unix

Special Forums UNIX and Linux Applications data unload in oracle 11g unix

03-09-2011

Registered User

10, 0

Join Date: Dec 2009

Last Activity: 10 September 2014, 5:18 PM EDT

Posts: 10

Thanks Given: 0

Thanked 0 Times in 0 Posts

data unload in oracle 11g unix

hi,

i work with ids and i've got a task now to load some data from oracle table to ids table. I'm trying to unload data from oracel tables.

I use UNLOAD TO <filename> SELECT * FROM <table1>; sql in IDS to unload data to a unl. Is there a equivalent sql in oracle? Or is there any other way that i can achieve this?

Thanks

divak

View Public Profile for divak

Find all posts by divak

Previous Thread | Next Thread

1 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'. I've tried the following with no success. su - oracle -c "<< EOF1 sqlplus -s "/ as sysdba" << EOF2 whenever sqlerror exit sql.sqlcode;...

LEARN ABOUT DEBIAN

font::ttf::coverage

Font::TTF::Coverage(3pm)				User Contributed Perl Documentation				  Font::TTF::Coverage(3pm)

NAME

       Font::TTF::Coverage - Opentype coverage and class definition objects

DESCRIPTION

       Coverage tables and class definition objects are virtually identical concepts in OpenType. Their difference comes purely in their storage.
       Therefore we can say that a coverage table is a class definition in which the class definition for each glyph is the corresponding index in
       the coverage table. The resulting data structure is that a Coverage table has the following fields:

       cover
	   A boolean to indicate whether this table is a coverage table (TRUE) or a class definition (FALSE)

       val A hash of glyph ids against values (either coverage index or class value)

       fmt The storage format used is given here, but is recalculated when the table is written out.

       count
	   A count of the elements in a coverage table for use with add. Each subsequent addition is added with the current count and increments
	   the count.

METHODS

   new($isCover [, vals])
       Creates a new coverage table or class definition table, depending upon the value of $isCover. if $isCover then vals may be a list of glyphs
       to include in order.  If no $isCover, then vals is a hash of glyphs against class values.

   read($fh)
       Reads the coverage/class table from the given file handle

   out($fh, $state)
       Writes the coverage/class table to the given file handle. If $state is 1 then the output string is returned rather than being output to a
       filehandle.

   $c->add($glyphid[, $class])
       Adds a glyph id to the coverage table incrementing the count so that each subsequent addition has the next sequential number. Returns the
       index number of the glyphid added

   $c->signature
       Returns a vector of all the glyph ids covered by this coverage table or class

   @map=$c->sort
       Sorts the coverage table so that indexes are in ascending order of glyphid.  Returns a map such that $map[$new_index]=$old_index.

   $c->out_xml($context)
       Outputs this coverage/class in XML

AUTHOR

       Martin Hosken Martin_Hosken@sil.org. See Font::TTF::Font for copyright and licensing.

perl v5.10.1							    2011-02-25						  Font::TTF::Coverage(3pm)

UNIX and Linux Applications