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

State and explain the different types of data models?

938

---

How to update values on multiple rows in oracle?

1031

---

What is the difference between translate and replace?

1055

---

What is different types of joins?

1018

---

What is an oracle user role?

984

---

How to delete a user account in oracle?

962

---

How many types of tables supported by oracle?

1070

---

What is recovery manager in Oracle?

1050

---

What happens to the current transaction if a ddl statement is executed?

1006

---

How to convert a string to a date in oracle database?

1046

---

How to connect ms access to oracle servers?

997

---

How to create a new tablespace in oracle?

979

---

How is it different from a normal table?

1026

---

Why should I use oracle database?

984

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2966

---