You can use SQL Loader to load number of image files.
The code for this is as follows:
LOAD DATA
INFILE *
INTO TABLE image_table
FIELDS TERMINATED BY ","
(
image_id INTEGER(5),
file_name CHAR(30),
image_data LOBFILE (file_name) TERMINATED BY EOF
)
BEGINDATA
001,1.gif
Image file shoud be in a admin folder from where you are executing...
rahulkoshti
Last Activity: Feb 15 '08, 11:53 AM
Joined: Jan 4 '08
Location: New Delhi
-
You want to learn ORACLE,PL/SQL etc. Start with quick starters and understand the basic concepts.Once you got basics then start to Practicals.
Lot's of books are available but start with one book and complete it..
If you are using internet then go for this site :
http://www.java2s.com/
You will get all practically performed things whatever you wnat to learn...
Leave a comment:
-
U can't use return statement in procedures..
For that purpose you can use OUT parameter type..As
create or replace procedure_name ( variable1 OUT data_type)
---
begin
---
end;Leave a comment:
-
I think u want to take table_name as parameter and wana to use that table_name into ur query.
Use can Use:
EXECUTE IMMEDIATE str;
str STRING will contain your dynamic query string.
It's useful for DDL statements...Tr y This
Leave a comment:
-
Reply
Seeee This=====>
Consider the column which must hold up to a maximum of 20 characters and other application which supports multilingual column.Everythi ng works fine until we try of fill the column with 20 two-byte characters
All of a sudden the column is trying to store twice the data it was before and we have a problem.
VARCHAR2(20)
VARCHAR2(20 BYTE)
VARCHAR2(20...Leave a comment:
No activity results to display
Leave a comment: