Creation of Oracle table through shell scripting Post: 302937544

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

update a oracle table using shell script

Hi, I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure) While the command is running,I am able to view the log file created in the Unix machine.After the command...

2. Shell Programming and Scripting

Store return code of shell script in oracle table

Hi friends, I have to do the following things : 1) there should be a shell script returning the returning the return code of the script. and i have to add some more details like on which machine is has run , at what time and other details and then using plsql i have to add a row to Oracle...

3. Shell Programming and Scripting

updating a column in oracle table using shell script

Hi friends, i am having a variable declared in .profile.i am changing its value in a shell script and then i am connecting to oracle and then from there i am calling a .sql called update.sql STATUS is the variable declared in the .profile =============================== if sqlplus <<END...

4. Shell Programming and Scripting

Help in Shell scripting to modify the User Creation script in oracle database.

Hi, I have several users to create on my test Oracle database taking the scripts from the Production Oracle database. I have a separate text file where I have user-id and passwords maintained. I need help in writing a shell script to go thru the user creation scripts and replace VALUES...

5. Shell Programming and Scripting

Create a table using shell scripting

Hi Can we create a rectangular table as i have attached in the query . This is primarily for populating the created table with data gathered . Hope I made myself clear ... Pls suggest Thanks

6. Shell Programming and Scripting

Shell script to query Oracle table

Hi, unix gurnis I need help for following requirement for writing a shell scritp. log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file. Thanks in advance

7. Shell Programming and Scripting

Shell script to export data from Oracle table .

Hi, I want to write a shell script which will export data from oracle table . I don't want to save that data . I want the queries . Right now i am right clicking on the table and clicking on export as to my desktop . Please let me know if any one have any idea .

8. Shell Programming and Scripting

How to update a Oracle table through shell scripting?

My Code is get_week_date() { `sqlplus -s ${DQM_SQL_LOGON}@${DQM_SID} << EOF SET ECHO OFF SET FEEDBACK OFF SET PAGES 0 SET SERVEROUTPUT ON SET VERIFY OFF SET TRIMSPOOL ON (update file_level_qc fq set FQ.DATA_FILE_NAME='Hyvee_Pharmacy_Solutions_201304_v1.txt'...

9. Shell Programming and Scripting

Please help in populating output in table using shell scripting

Below is my code where i tried using table tag to print out put in table but its not working #!/bin/ksh #] && . ./.profile 2>/dev/null if test -f '.profile'; then . ./.profile; fi; #. .profile LOG_DIR=/app/rpx/jobs/scripts/just/logs sendEmail() { pzCType="$1";...

10. UNIX for Advanced & Expert Users

How can i populate the record in to table using shell scripting?

LOG_DIR=/app/rpx/jobs/scripts/just/logs sendEmail() { pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7" ( echo "From: $pzFrom\nTo: $pzTo\nSubject: $pzTitle${pzReplyTo:+\nReply-To: $pzReplyTo}" ] && echo...

LEARN ABOUT DEBIAN

viewsu

VIEW-OS(1)						      General Commands Manual							VIEW-OS(1)

NAME

       viewsu - change (virtual) user ID or become (virtual) superuser

SYNOPSIS

       viewsu [options] [username]

DESCRIPTION

       The viewsu command is used to become another user during a login session. Invoked without a username, viewsu defaults to becoming the supe-
       ruser. The optional argument - may be used to provide an environment similar to what the user would expect had the user logged in directly.
       This  command  is  the  View-OS	counterpart  of  the  su(1)  command.	The  value of $PATH is reset to /bin:/usr/bin for normal users, or
       /sbin:/bin:/usr/sbin:/usr/bin for the superuser. This may be changed with the ENV_PATH and ENV_SUPATH definitions in /etc/login.defs.

OPTIONS

       The options which apply to the viewsu command are:

       -c, --command COMMAND
	   Specify a command that will be invoked by the shell using its -c.

       -, -l, --login
	   Provide an environment similar to what the user would expect had the user logged in directly.

	   When - is used, it must be specified as the last viewsu option. The other forms (-l and --login) do not have this restriction.

       -s, --shell SHELL
	   The shell that will be invoked.

	   The invoked shell is chosen from (highest priority first):

	   o   The shell specified with --shell.

	   o   The shell indicated in the /etc/passwd entry for the target user.

	   o	/bin/sh if a shell could not be found by any above method.

SEE ALSO

       su(1), linux.defs(5)

AUTHORS

       View-OS is a project of the Computer Science Department, University of Bologna. Project Leader: Renzo Davoli.
       <http://www.sourceforge.net/projects/view-os>

       Howto's and further information can be found on the project wiki <wiki.virtualsquare.org>.

NOTE

       Most part of the text is taken from su(1).

VIEW-OS: a process with a view					  August 5, 2009							VIEW-OS(1)