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');

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.

How to join two tables in a single query using oracle?

0 Answers  

---

What is a data dictionary and how can it be created?

0 Answers  

---

how to create a new database in oracle?

6 Answers   TCS,

---

Respected sir, Please send me technical questions related to oracle apps..

0 Answers  

---

Explain coalesce function?

0 Answers  

---

Is it possible to enter only time value into a column of a table in sql?

2 Answers  

---

Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 Answers  

---

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

---

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

2 Answers   IBM,

---

I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!

1 Answers  

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

0 Answers   ESS,

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

0 Answers   Infosys,

---