how to write utl file pkg in SQL
Answer / pankajsharma
l_utlfile=utl_file_type;
l_utlfile=utl_file.fopen('filepath','filename','mode')
Is This Answer Correct ? | 5 Yes | 1 No |
what is the difference between binary_integer and pls_integer
What found sql?
how do you login to mysql using unix shell? : Sql dba
What is the difference between nested table and varray?
Explain the order of sql statement execution?
What is a parameter query?
In a table only one column how to update rows
I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.
What are all the different types of indexes?
Difference between views and materialized views?
What is dml statement?
How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }