how to insert the image in table
Answers were Sorted based on User's Feedback
Answer / s. senthil kumar
HOW TO CREATE TABLE FOR IMAGE FILE?
create table image_table (
file_id number,
file_desc varchar2(30),
file_loc bfile,
file_type varchar2(4));
HOW TO INSERT IMAGE FILE IN TABLE?
INSERT INTO image_table
VALUES(1,'Senthil
photo',bfilename('c:\photos','Kanneer.jpg'),'JPEG');
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / dinesh gawande
Photographs and pictures can be inserted in the database
using BLOB/CLOB datatypes. You can use BLOB to insert the
image. There is one more datatype called Longraw but I
think BLOB is better because one table can have only one
longraw data type.
This task is covered in the Oracle documentation:
http://download-
west.oracle.com/docs/cd/B10501_01/appdev.920/a88786/mm_uses.
htm#600943
All the best.
Is This Answer Correct ? | 2 Yes | 0 No |
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>
Difference between NO DATA FOUND and %NOTFOUND?
How you open and close a cursor variable.Why it is required?
how to do daily transactions with out sql* loader control file regesterd in apps?
What to do if the binary spfile is wrong for the default instance?
various types of joins
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What are the differences between lov and list item?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is the purpose of tables, private synonyms and public synonyms in Oracle?