Answer Posted / avi007

--Read file

DECLARE
fileHandler UTL_FILE.FILE_TYPE;
BEGIN
fileHandler := UTL_FILE.FOPEN('/tmp', 'myfile', 'R');
UTL_FILE.GETF(fileHandler, 'Look ma, I''m writing to a
file!!!\n');
UTL_FILE.FCLOSE(fileHandler);
EXCEPTION
WHEN utl_file.invalid_path THEN
raise_application_error(-20000, 'ERROR:
Invalid path
for file or path not in INIT.ORA.');
END;
/

What is the difference between sql, mysql and sql server?

1013

---

How to write a query to show the details of a student from students table whose

937

---

How we can update the view?

1004

---

What is sql in oracle?

1001

---

What is column?

939

---

Can sql developer connect to db2?

985

---

what is a trigger? : Sql dba

973

---

How can I get the number of records affected by a stored procedure?

999

---

What is exception? What are the types of exceptions?

1030

---

What is mutating trigger?

968

---

Is null operator in sql?

978

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1584

---

What is the difference between jpql and sql?

1021

---

What is sql data?

922

---

Which is faster joins or subqueries?

929

---