Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Binary types

Re: Binary types

From: <bilal_z_at_my-dejanews.com>
Date: Wed, 31 Mar 1999 15:42:20 GMT
Message-ID: <7dtfoq$vc3$1@nnrp1.dejanews.com>


In article <37016182.A30A3DF3_at_gwl.com>,   Dogan Cibiceli <dcib_at_gwl.com> wrote:
> bilal_z_at_my-dejanews.com wrote:
>
> > I have 2 questions:
> >
> > How can you enter a binary file into a table in Oracle 8? I know that you
> > declare the datatype as 'raw', but how exactly is a .gif (for instance)
> > entered. Also, how do you create a new schema? I cant figure that
> > out...uptill now all my tables are part of the System schema.
> >
> > I'd appreciate it if someone can help me out.
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
> Hi bilal,
> first of all , you should read your gif file into a buffer and then insert
> it using this buffer. Look oci or Pro*c for examples.second is create schema
> should be your answer :)

Thanks Dogan,
The problem is...I cannot find 'create schema' anywhere in the schema manager. The only 'create' there is for all the schema objects, but nothing for a new schema itself.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 09:42:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US