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;
/

Why is partition used in sql?

1130

---

how can we know the number of days between two given dates using mysql? : Sql dba

1053

---

Is sql low level language?

1029

---

What is trigger price?

1001

---

Why we use triggers in mysql?

998

---

Why are sql stored procedures used?

1065

---

What is interval partition?

1066

---

What are the different parts of a package?

1118

---

how to shut down the server with 'mysqladmin'? : Sql dba

1023

---

What is procedure explain with example?

971

---

Why use stored procedures?

1099

---

What is the use of primary key?

1018

---

Explain the difference between sql and mysql.

1069

---

What is sql*plus?

1085

---

What is on delete restrict?

1011

---