scope of oracle plsql development /unix shell scripting Post: 302560759

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

UNIX shell scripting for retrieving from oracle

Hello folks, Please find the below code:(sample5.sh -> filename) echo "Selecting dat afrom Cause code" echo "set appinfo Causecode $preamble set serveroutput on size 10000 select * from RMI003_CAUSE_CODE /" | sqlplus -S $username@$hoststring/$password >> test2.dat When i tried executing...

2. Programming

UNIX Shell Script to Create a Document of a PLSQL code.

Hi All, I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not...

3. Shell Programming and Scripting

what is the maximum length of a unix shell variable which can be can passed to plsql

what is the maximum length of a unix shell variable which can be can passed to plsql variable:(

4. Shell Programming and Scripting

To get value from Oracle Anonymous PLSQL block

Hi All, i need you help while accessing the value from anonymous PL/SQL block. Initially our requirement was to get the value from SQL statement. I was doing like... But now i need to use dbms_application_info.set_module in it. So i have planned to use anonymous block instead of SQL...

5. Shell Programming and Scripting

Xapture Plsql Error from Unix Shell cript

Hi Friends, Need your help . I have a shell script which executes the plsql procedure proc_p1. I want to capture the error message when the procuder throws some error message. I codeed in the following way . But it shows Job Success. Kindly anyone give some better idea to over come this ...

6. What is on Your Mind?

Scope of Shell Programming and scripting

Hi all, I want to know what is the scope and job status of shell Programming and scripting. Does it have any attractive jobs?

7. UNIX for Dummies Questions & Answers

Unix Shell Scripting( Calling from Unix to PLSQL)

Hello Experts, I have the following questions to be discussed here at this esteemed discussion forum. I have two Excel sheets which contain Unix Commands llike creating directory the structure/ftp/Copy/Zip etc to basically create an environment. I need help in understanding some of...

8. Shell Programming and Scripting

Connecting+Firing plsql to Oracle DB in one go

Hi, I am using the below command to connect to a remote Oracle DB from my unix shell script. sqlplus -s user1/password1@remotedbhost:1252/demo @/tmp/PROC_MS.prc But I get the below error. 1. Can you confirm if my code is correct ? 2. Can you help me overcome the error ?

9. UNIX for Dummies Questions & Answers

Oracle cursors in UNIX shell scripting

Hello, I need to get all the members information from an oracle table whose flag value is enabled. Later on i need to perform several computation based upon the flag value and other columns. For example, Member ID Flag Frequency date 1 ...

10. UNIX for Beginners Questions & Answers

Export Oracle multiple tables to multiple csv files using UNIX shell scripting

Hello All, just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table. Can you please suggest why? or any better idea? export FILE="/abc/autom/file/geo_JOB.csv" Export= `sqlplus -s dev01/password@dEV3...

LEARN ABOUT OPENSOLARIS

disown

disown(1)							   User Commands							 disown(1)

NAME

       disown - ksh93 built-in function to disassociate a job with the current shell

SYNOPSIS

       disown [job ...]

DESCRIPTION

       The  ksh93  disown command prevents the current shell from sending a HUP signal to each of the specified jobs when the current shell termi-
       nates a login session.

       If job is omitted, disown sends the HUP signal to the most recently started or stopped background job.

OPERANDS

       The following operands are supported:

       job    Specifies the job or jobs on which disown operates.

	      Specify job as one of the following:

	      number	  Refers to a process ID.

	      -number	  Refers to a process group ID.

	      %number	  Refers to a job number.

	      %string	  Refers to a job whose name begins with string.

	      %?string	  Refers to a job whose name contains string.

	      %+ or %%	  Refers to the current job.

	      %-	  Refers to the previous job.

EXIT STATUS

       0     Successful completion.

       >0    One or more specified jobs does not exist.

EXAMPLES

       Example 1 Disowning a Job

       The following example disowns job 1:

	 example% disown %1

AUTHORS

       David Korn, dgk@research.att.com

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Uncommitted		   |
       +-----------------------------+-----------------------------+

SEE ALSO

       bg(1), jobs(1), ksh93(1), wait(1), attributes(5)

SunOS 5.11							    18 Apr 2007 							 disown(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

UNIX shell scripting for retrieving from oracle

Discussion started by: sundar_ravi4

2. Programming

UNIX Shell Script to Create a Document of a PLSQL code.

Discussion started by: gauravsachan

3. Shell Programming and Scripting

what is the maximum length of a unix shell variable which can be can passed to plsql

Discussion started by: alokjyotibal

4. Shell Programming and Scripting

To get value from Oracle Anonymous PLSQL block

Discussion started by: Amit.Sagpariya