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 may join possible between (requisition with purchase order)

2185

---

How to start instance with a minimal initialization parameter file?

1002

---

Can we write insert statement in function in oracle?

1048

---

What is oracle rownum?

901

---

What is format trigger?

2030

---

Differentiate between pre-select and pre-query?

1063

---

What is an oracle wallet?

896

---

What do database buffers contain?

979

---

What is a parameter file in oracle?

1069

---

what is port in oracle? how is it related to database application.

1905

---

What is Undo Management Advisor in Oracle?

1056

---

How to create a table index in oracle?

1096

---

What are the advantages of oracle?

977

---

What is a tns service name?

960

---

What is a system tablespace and when it is created?

933

---