How to pass parameter from file to sqlplus in UNIX?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How pass the input parameter to a file in the script ?

OS version: RHEL 6.7 myTextFile.txt file is referred within Script1.sh script, I only execute Script1.sh and I want the input variable to be passed inside myTextFile.txt . Any idea how I can do this ? $ cat script1.sh cat myTextFile.txt $ cat myTextFile.txt $1 Requirement1....

2. Shell Programming and Scripting

How to pass the parameter in xml file in UNIX shell script?

Hi, I have an XML file like the following... <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ONDEMAND_JOB VERSION="5.1" LOCALE="en_US"> <IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"...

3. Shell Programming and Scripting

How to pass the parameter in xml file in UNIX shell script?

4. UNIX for Dummies Questions & Answers

SQLPLUS Password Parameter file being used when logging in

Good day to everyone. This is my first time posting and just barely above basic Unix training. I think i have search thoroughly to ensure my question hasn't already been posted. But on the off chance the answer has been posted, please be nice as I am not 100% sure I know what I am looking for. I...

5. UNIX for Dummies Questions & Answers

Passing a Unix parameter to SQLPlus login command

hi All, i m trying to pass a user choice paramter from unix to sqlplus connect command here i want the user to enter the username and password he wants to connect in sql plus through read in unix and then automatically connect to that instance. sqlplus -s $1/$2 where $ 1 and $2 will b...

6. Shell Programming and Scripting

Pass value from file to parameter

Hi Guys, I have a file in the format Parmater=value. I want to read the value and pass it to corresponding Variable. The Parameter file is as follows Number=23 Text1=mango Text2=yup 'Number' value needs to be read and passed to ID variable. Also, 'Text1' value needs to be passed to...

7. Shell Programming and Scripting

How to pass parameter from sqlplus(procedure completed) to your shell script

if then # mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com echo "FILE does not exist" exit 1 fi echo "FILE EXIST" size=-1 set $(du /export/home/oracle/nas/scott21.dmp.gz) while do echo "Inside the loop" size=$1 set $(du...

8. Shell Programming and Scripting

To pass the .sql file as a paramter to sqlplus through shell programming

Hi, Currently i have a .sql file 1.sql. I need to pass that as a parameter through a shell script to the sqlplus inside the same shell script. How I should I do.can anyone help me pls. I have an req where I need to send the .sql file and the place where the script has to create a .csv...

9. Shell Programming and Scripting

Pass tablename as a parameter in the Control File -- sqlldr

Just wanted to know if there is a way to pass the table name as a parameter in the control file. I have two tables...Table A and Table B. LOAD DATA append INTO TABLE TABLE_B FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY '"' AND '"' TRAILING NULLCOLS Rather than hard coding...

10. UNIX for Advanced & Expert Users

How to pass unix variable to SQLPLUS

hi fellows, can any body tell me how to pass unix variables to oracle code is... #! /bin/ksh echo ENTER DATE VALUE's read START_DATE END_DATE sqlplus xyx/abc@oracle select * from table1 where coloumn1 between $START_DATE and $END_DATE; is this is correct way........... Thanks in...

LEARN ABOUT OSX

moose::cookbook::roles::applicationtoinstance

Moose::Cookbook::Roles::ApplicationToInstance(3)	User Contributed Perl Documentation	  Moose::Cookbook::Roles::ApplicationToInstance(3)

NAME

       Moose::Cookbook::Roles::ApplicationToInstance - Applying a role to an object instance

VERSION

       version 2.0604

SYNOPSIS

	 package MyApp::Role::Job::Manager;

	 use List::Util qw( first );

	 use Moose::Role;

	 has 'employees' => (
	     is  => 'rw',
	     isa => 'ArrayRef[Employee]',
	 );

	 sub assign_work {
	     my $self = shift;
	     my $work = shift;

	     my $employee = first { !$_->has_work } @{ $self->employees };

	     die 'All my employees have work to do!' unless $employee;

	     $employee->work($work);
	 }

	 package main;

	 my $lisa = Employee->new( name => 'Lisa' );
	 MyApp::Role::Job::Manager->meta->apply($lisa);

	 my $homer = Employee->new( name => 'Homer' );
	 my $bart  = Employee->new( name => 'Bart' );
	 my $marge = Employee->new( name => 'Marge' );

	 $lisa->employees( [ $homer, $bart, $marge ] );
	 $lisa->assign_work('mow the lawn');

DESCRIPTION

       In this recipe, we show how a role can be applied to an object. In this specific case, we are giving an employee managerial
       responsibilities.

       Applying a role to an object is simple. The Moose::Meta::Role object provides an "apply" method. This method will do the right thing when
       given an object instance.

	 MyApp::Role::Job::Manager->meta->apply($lisa);

       We could also use the "apply_all_roles" function from Moose::Util.

	 apply_all_roles( $person, MyApp::Role::Job::Manager->meta );

       The main advantage of using "apply_all_roles" is that it can be used to apply more than one role at a time.

       We could also pass parameters to the role we're applying:

	 MyApp::Role::Job::Manager->meta->apply(
	     $lisa,
	     -alias => { assign_work => 'get_off_your_lazy_behind' },
	 );

       We saw examples of how method exclusion and alias working in Moose::Cookbook::Roles::Restartable_AdvancedComposition.

CONCLUSION

       Applying a role to an object instance is a useful tool for adding behavior to existing objects. In our example, it is effective used to
       model a promotion.

       It can also be useful as a sort of controlled monkey-patching for existing code, particularly non-Moose code. For example, you could create
       a debugging role and apply it to an object at runtime.

AUTHOR

       Moose is maintained by the Moose Cabal, along with the help of many contributors. See "CABAL" in Moose and "CONTRIBUTORS" in Moose for
       details.

COPYRIGHT AND LICENSE

       This software is copyright (c) 2012 by Infinity Interactive, Inc..

       This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.

perl v5.16.2							    2012-09-19			  Moose::Cookbook::Roles::ApplicationToInstance(3)

Programming