Answer / deepak singh

throug the Text_io package

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

Answer / 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 do we need databases?

0 Answers  

---

What has stored procedures in sql and how we can use it?

0 Answers  

---

Does view contain data?

0 Answers  

---

How do I view a table in sql?

0 Answers  

---

Is big data nosql?

0 Answers  

---

What is sqlca in db2?

0 Answers  

---

How much does sqlite cost?

0 Answers  

---

what are the types of subquery? : Sql dba

0 Answers  

---

What are the parts of a sql statement?

0 Answers  

---

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

Why schema is used in sql?

0 Answers  

---

Can we use two order by clause in query?

0 Answers  

---