Note:
1.2 use the CREATE DIRECTORY feature instead of UTL_FILE_DIR for directory access verification.
2.Up to 8i, Oracle refused to access a file that is not pointed to in the utl_file_dir parameter in
the init.ora file.
In Oracle 9i, in order to access a file, either the utl_file_dir parameter must be set, or one has to create a directory.
3.First Availability
Oracle Version : 7.3.4
4.The UTL_FILE package is similar to the client-side TEXT_IO package currently provided by Oracle Procedure Builder. Restrictions for a server implementation require some API differences between UTL_FILE and TEXT_IO. In PL/SQL file I/O, errors are returned using PL/SQL exceptions.
5.Open Mode.
1.A append
2.R read
3.W write
Monday, February 2, 2009
Subscribe to:
Post Comments (Atom)
TOPICS
- Analyst (2)
- Bidah (1)
- Business (2)
- Business अनाल्य्स्त (1)
- Charity (1)
- Cloning (1)
- Database (1)
- DBV (1)
- DBVERIFY (1)
- Deal making (1)
- Differences (1)
- Directory Service (1)
- due diligence (1)
- Flinch (1)
- formating (1)
- Functional requirements (1)
- Headache (1)
- History of Oracle Technology Introductions (1)
- HTTP (1)
- HyperText (1)
- Infection (1)
- interview questions (1)
- interview क़ुएस्तिओन्स् (1)
- Islam (1)
- Islam And Women (1)
- JDBC (1)
- Manually Database Creation. (1)
- Meaning Of Charity (1)
- nasal (1)
- Negotiating Gambits (1)
- Negotiation (1)
- Nokia (1)
- Non-functional requirements (1)
- ORA-03297 (1)
- ORA-30013 (1)
- Oracle (8)
- Oracle Family of Database Products (1)
- PGA (1)
- Place of women in Islam (1)
- Process Analysis (1)
- Process Analysis Process Improvement (1)
- Process Bottleneck (1)
- Process Flow Diagram (1)
- Process Performance Measures (1)
- Real Time Exprience about DB Upgrade (1)
- Recovery Catalog (1)
- recreate (1)
- reset nokia (1)
- Resize (1)
- Responsibilities (1)
- RMAN (1)
- RMAN-06054: media recovery requesting (1)
- secret codes (1)
- Sinus (1)
- Sorting Enhancements (1)
- SQL Server 2000 (1)
- SQL Server 2005 (1)
- Symptoms (1)
- Systems (1)
- Table Copy From OneDB to AnotherDB (1)
- tablespace (1)
- Thin Client (1)
- Thin Client Models (1)
- Thin Driver (1)
- undo tablespace (1)
- utl_file plsql package. (1)
- Virtues of Charity (1)
- Web service (1)
- What is HTTP (1)
- Women's Prestige (1)
- workarea_size_policy (1)
- X-terminals (1)
No comments:
Post a Comment