Answer Posted / 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');

How different is ms access and oracle?

986

---

What are the restrictions in a oracle read only transaction?

963

---

What is an oracle user role?

936

---

How do I reset a sequence in oracle?

1047

---

What do you mean by redo log file mirroring?

974

---

How many types of synonyms in Oracle?

1062

---

How to use in conditions in oracle?

992

---

How to insert a new row into a table in oracle?

1087

---

What are the uses of synonyms?

1079

---

What is the difference between view and materialized view in Oracle?

1090

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2410

---

What is the recommended interval at which to run statspack snapshots, and why?

2859

---

Why do we use bulk collect in oracle?

1007

---

What is the difference between translate and replace?

1010

---

How to pass parameters to procedures?

970

---