Possibility of Using Unix Variables in Ctl Files

Author: asktom.oracle.com | Published: 11th Nov 2005 | Visited: 437 times | Add Comment
Filed in: Oracle FAQ

Is it possible to pass a parameter from unix to a ctl file? Something like: LOAD DATA INFILE 'abc.dat' APPEND INTO TABLE XYZ ( SEQ_ID "$SEQ_VAL" RECORD_NUM RECNUM, RC_VAL P...

Read Article

Sponsored Links

• ZipFS: Using ZIP files as virtual directories or read-only resource containers in ASP.NET A library to use a ZIP archive (with images, script files, resources and so on...) as if it is a virtual directory in ASP.NET applicat ...

• Notifying Windows Explorer about files in use How to notify Windows Explorer about which files are used and locked by your applicat ...

• Shared Variables in ASP.NET Variable types are often misused in ASP.NET applications. This article discusses the various types of shared variables in Delphi ASP.NET applicat ...

• Tuning sql with bind variables Hi Tom, Here is a sample sql from a package used for searching clients. The query is very fast when we remove the "OR" condition "ln_cl_id is null" from the WHERE condition. There are many columns with similiar OR condition, which I have remove ...

• ODP.NET - Working with Bind Variables together with OracleParameter ODP.NET - Working with Bind Variables together with OracleParameter With the help of OracleParameter, you can include bind variables within any SQL statement. These bind variables are nothing but run-time query parameters. The values in the SQL statement are bound at run time when we use bind... V ...

• Convert PBS Legacy Files to XML Legacy file formats, such as UN-EDIFACT with a record per line and fixed-length fields, still exists and are widely used for B2B transactions. A tool that can convert legacy files to human-readable XML might come in ha ...

• Velde.Utilities - C# Utility class for Active Directory, databases, files, networking etc... C# Utility class for Active Directory, databases, files, networking et ...

• How can CS2 help me manage my working files? Get the answer to this Adobe Creative Suite question from the experts at Ad ...

• Read data from XLS, XLSX or CSV files without the need for MS Excel This article describes how to read XLS, CSV or XLSX files by using .NET compo ...

• CodeSnip: How to Run Any Oracle Script File Through Shell Script in UNIX In this article, Deepankar demonstrates the usage of Shell scripts in UNIX and their ability to run any Oracle script file. After reading this code snippet, you will be able to execute a number of oracle queries at one go without any need to wait for the end of one query to run another. This techniq ...

Next: Oracle Patch question