Home » SQL & PL/SQL » SQL & PL/SQL » datatype (oracle 9i)
datatype [message #607091] Sun, 02 February 2014 23:07 Go to next message
DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA
Junior Member
Hello,
in sql i have create a table and long raw datatype for image,can i use some another datatype for image,or can we use multiple datatype in one table for image,because in one table we can use only one long raw datatype,so what we can use in place of longraw..
Re: datatype [message #607093 is a reply to message #607091] Sun, 02 February 2014 23:15 Go to previous messageGo to next message
manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA
Senior Member

Use BLOB

Yes, you can have more than 1 LOB in a single table.
Re: datatype [message #607094 is a reply to message #607091] Sun, 02 February 2014 23:15 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
LONGRAW is obsoleted along with V9 Oracle from last Century.

>so what we can use in place of longraw
CLOB or BLOB
Re: datatype [message #607100 is a reply to message #607094] Mon, 03 February 2014 00:09 Go to previous messageGo to next message
DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA
Junior Member
but lob give error in oracle form when we use it there...
Re: datatype [message #607105 is a reply to message #607100] Mon, 03 February 2014 00:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Because you misuses it.

Re: datatype [message #607119 is a reply to message #607091] Mon, 03 February 2014 01:24 Go to previous messageGo to next message
DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA
Junior Member
in table we cannot use multiple long raw datatype ,so what we can use in place of that....
Re: datatype [message #607121 is a reply to message #607119] Mon, 03 February 2014 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

BLOB.

Re: datatype [message #607142 is a reply to message #607121] Mon, 03 February 2014 05:12 Go to previous messageGo to next message
DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA
Junior Member
blob give rep-0999 error in oracle report 6i
Re: datatype [message #607153 is a reply to message #607142] Mon, 03 February 2014 06:01 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Upgrade to a version of this century or change your table design (that is create a detail table for your images) or stay with your only one LONG RAW problem.

Previous Topic: copy table data to other table
Next Topic: SQL Query Scenario
Goto Forum:
  


Current Time: Thu Mar 28 17:46:08 CDT 2024