Search results for query: *

This probably isn't the problem but before you use UTL_FILE you must set the UTL_FILE_DIR init.ora parameter to define which directories the package can write to

You could use one of the Oracle Precompilers or the PL/SQL file I/O built-in package UTL_FILE to read the file and then perform inserts into the appropriate table. SQL*Loader is probably easiest unless you want to do some pretty complicated data cleansing etc.

You can use Oracle Forms 6i too (I assume Oracle for Netware doesn't pose any issues in this respect? They just run on Windows/NT)

I'm think I understand your question. There is not as I understand it a database directory. An Oracle database consists of a series of data files and these can be stored anywhere you want on the file system of the machine where the RDBMS is located. However a cold backup of database will...

It tells you that a shared row-level lock is being held (two of them in your case)

SELECT s.username, l.type, o.object_name, DECODE(l.lmode, 2, 'Row-S(SS)', 3,'Row-X(SX)', 4, 'Share', 5, 'S/Row-X(SSX)', 6, 'Exclusive', 'Other' Mode_Held, FROM...

If it is not possible to use CREATE TABLE...AS SELECT then use DBMS_SQL to create a table. The following procedure will execute a ddl statement as per the SQL string you pass it: PROCEDURE any_ddl (sql_string IN VARCHAR2) IS c1 INTEGER; BEGIN c1 := dbms_sql.open_cursor...

Quest Software offer loads of Oracle monitoring tools and they can be downloaded for evaluation purposes. Obviously they're not as cheap as SQL*Plus reports but much nicer to work with. If you're after scripts http://www.orsweb.com is always a good place to start. I definately reckon the SAFE...

Hints are available in version 7 of Oracle but the optimiser will ignore them if the init.ora paramter optimiser_mode is set to RULE. Bear in mind that the follwing will prevent the optimiser from using an index: -Using functions on the indexed column(s) in the WHERE clause -Performing NULL...