Home » SQL & PL/SQL » SQL & PL/SQL » help me for a table with lob datatype
help me for a table with lob datatype [message #222329] Fri, 02 March 2007 21:30 Go to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
HI
I don't know how to create a table with lob(blob,clob,nlob...)
I have creted a table with blob and another one with bfile but i could not insert any value.
But later when i drop that tables, a new table(BIN$KrfT1y....) is automatically added to my schema for every table(with lob) i drop.

Please Help...
Thnx in advance.
Re: help me for a table with lob datatype [message #222331 is a reply to message #222329] Fri, 02 March 2007 21:58 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
create table demo
( id        int primary key,
   theBlob   blob,
   theClob   clob
)
/
Re: help me for a table with lob datatype [message #222333 is a reply to message #222329] Fri, 02 March 2007 22:44 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The BIN$ tables are the tables that you dropped and now reside in the Recycle Bin. Read What Is the Recycle Bin? for more information.
Re: help me for a table with lob datatype [message #222335 is a reply to message #222333] Fri, 02 March 2007 22:56 Go to previous messageGo to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
hi

Thank you for giving me knowledge about BIN tables.
I want to know how to insert into lob data type tables.
please help.
Re: help me for a table with lob datatype [message #222336 is a reply to message #222329] Fri, 02 March 2007 23:00 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>please help.
Are you unwilling or incapable of using GOOGLE?
Results 1 - 10 of about 447,000 for insert blob Oracle
Are you claiming that NONE answer your question?

http://asktom.oracle.com has many, many fine coding examples

[Updated on: Fri, 02 March 2007 23:03] by Moderator

Report message to a moderator

Re: help me for a table with lob datatype [message #222337 is a reply to message #222336] Fri, 02 March 2007 23:36 Go to previous message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
Firstly I apologise for my last reply.
actually i was not proper in my reply, i would not have reply in that way. I am very sorry for that.
I tried very much on google to find coding examples on lob tables but failed. But still i will try to search asktom.com as you suggested.
Thankyou very much.
Previous Topic: finding time of inserted record
Next Topic: execution of procedure
Goto Forum:
  


Current Time: Sat Dec 10 20:47:42 CST 2016

Total time taken to generate the page: 0.10671 seconds