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

What are the benefits of pl sql?

0 Answers  

---

What is a pdo connection?

0 Answers  

---

How do you update f as m and m as f from the below table testtable?

0 Answers  

---

What is the use of primary key?

0 Answers  

---

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  

---

Can we use ddl statements in stored procedure?

0 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

Which function is used to return remainder in a division operator in sql?

0 Answers  

---

what is online transaction processing (oltp)? : Sql dba

0 Answers  

---

How the execution will be done in exceptions?

2 Answers  

---

What is %s in sql?

0 Answers  

---

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

---