Sponsored Content
Contact Us Forum Support Area for Unregistered Users & Account Problems Creation of Oracle table through shell scripting Post 302937559 by vbe on Friday 6th of March 2015 07:39:03 AM
Old 03-06-2015
This room i for registering or account problems...
Please register if you wish to post in our forums, thanks
Thread closed
 

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 Replies)
Discussion started by: ann_124
2 Replies

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 Replies)
Discussion started by: sveera
3 Replies

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... (3 Replies)
Discussion started by: sveera
3 Replies

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... (1 Reply)
Discussion started by: rparavastu
1 Replies

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 (1 Reply)
Discussion started by: ultimatix
1 Replies

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 (2 Replies)
Discussion started by: ken002
2 Replies

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 . (2 Replies)
Discussion started by: honey26
2 Replies

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'... (2 Replies)
Discussion started by: karthick.cho
2 Replies

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";... (5 Replies)
Discussion started by: ankit.mca.aaidu
5 Replies

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... (1 Reply)
Discussion started by: ankit.mca.aaidu
1 Replies
CIPUX_CAT_WEB_MODULE(1p)				User Contributed Perl Documentation				  CIPUX_CAT_WEB_MODULE(1p)

NAME
Program to register, deregister and list a CAT modules. SYNOPSIS(1) cipux_cat_web_module [OPTIONS] --register --object <NAME>| --all(2) cipux_cat_web_module [OPTIONS] --deregister --object <NAME>| --all(3) cipux_cat_web_module [OPTIONS] --list-registered(4) cipux_cat_web_module [OPTIONS] --list-deregistered OPTIONS
Options for all commands: -D | --debug : print debug messages for developers -h | --help : print help (this message + options) -l | --login ID : uses ID as UID to authenticate -V | --version : print only version --verbose : print more messages -w | --password CRED : uses CRED as credential to authenticate Additional options for registering and deregistering: -a | --all : (de)register all pending objects Additional options for registering: -e | --enable : enable module(s) -m | --add-member : add object (user or group) to ACL USAGE SPECIFIC
OPTIONS(1) register --add-member <NAME> : do add object to the ACL, so that this object can access the modules. An object could be a group or a user. -e | --enable : do enable the module during registration; module is disabled by default -a | --all : register all modules or -o | --object <NAME> : or register only one module(2) deregister -a | --all : deregister all modules or -o | --object <NAME> : or deregister only one module The URL of the CipUX XML-RPC server is taken from cipux-cat-web.ini file. The default location for CipUX-CAT-Web. If you would like to use a different URL change catweb_rpc_server in the base section. DESCRIPTION OF OPTIONS
-a Same as option --all -add-member NAME Adds NAME to the ACL of that module(s). -all Register all CAT modules. -D Same as option --debug. --debug To see more output, what the internals is doing, you can enable the --debug option and see more message printed to STDOUT. -e Same as option --enable. --enable Enable the object during registration. -h Same as option --help --help Prints brief help message. -l UID Same as option --login UID. --login UID Use UID as identity to authenticate against RPC server. -o Same as option --object --object This option is used to specify the object on which the command is operating. Make sure you choose the right object. Of course this will also fail when the object is not fetchable with (in the objects list of) --task. --password SECRET Use SECRET as credential to authenticate against RPC server. -V Same as option --version. --version Prints the version and exits. --verbose Not implemented yet. -v Same as option --verbose. -w SECRET Same as option --password SECRET. perl v5.14.2 2012-12-07 CIPUX_CAT_WEB_MODULE(1p)
All times are GMT -4. The time now is 05:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy