Answer Posted / avi007

DECLARE
fileHandler UTL_FILE.FILE_TYPE;
BEGIN
fileHandler := UTL_FILE.FOPEN('/tmp', 'myfile', 'W');
UTL_FILE.PUTF(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 serial sql?

979

---

what are ddl statements in mysql? : Sql dba

1201

---

What is rtm stands for?

1100

---

Can one improve the performance of sql*loader? : aql loader

1050

---

What is the order of sql select?

1041

---

What is normalization sql?

1063

---

Which version of sql do I have?

1060

---

Can a procedure in a package be overloaded?

1045

---

How do I make sql search faster?

1001

---

What is data type in database?

998

---

what is the difference difference between procedure and packages

10414

---

What is synonyms?

1059

---

Which kind of parameters cannot have a default value in pl sql?

1149

---

what are set operators in sql? : Sql dba

1057

---

Is sql a programming?

978

---