Sponsored Content
Top Forums Shell Programming and Scripting Shell script to export data from Oracle table . Post 302547091 by ananthap on Saturday 13th of August 2011 08:36:36 PM
Old 08-13-2011
In the script
Quote:
sqlplus username/password@host_computer_name << HEREFILE
Set commands to make pagesize, noheading etc come here ;
Select sum(salary) from datatable ;
EXIT
HEREFILE
OK
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

export table from oracle database

i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it. thanks as usuall :rolleyes: (1 Reply)
Discussion started by: inquirer
1 Replies

2. 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

3. Shell Programming and Scripting

unix script to export data from csv file to oracle database

Hello people, Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies

4. Shell Programming and Scripting

help for writing shell script to export table data

Hi All, I need to write a shell script(ksh) to take the tables backup in oracle(exporting tables data). The tables list is not static, and those are selecting through dynamic sql query. Can any body help how to write this shell script. Thanks, (3 Replies)
Discussion started by: sankarg
3 Replies

5. Shell Programming and Scripting

problem running shell script (for oracle export) in crontab

Hello Gurus, I've been tasked with solving a problem at my new job and I'm stumped. We've got a script that dynamically builds an oracle export parameter files and then runs export from the shell. it runs fine when using the shell, but will NOT run (fails in one spot everytime) when entered... (1 Reply)
Discussion started by: jsheehan223
1 Replies

6. Shell Programming and Scripting

Script not reading Data from oracle table properly

Hi, I have a case where i am connecting to the oracle DB and reading a column value.... Script is in production...it was running fine,,,but suddenly now some times its started giving pain.... Script runs dailly....but sometimes its reading data from Oracle DB and sometimes its not rading the... (2 Replies)
Discussion started by: Sagarddd
2 Replies

7. Shell Programming and Scripting

How to export table data to xml file?

Hi , I would like to get some suggestion from the experts. My requirement is to export oracle table data as an xml file. Any unix/linux tools, scripts available? Regards, (2 Replies)
Discussion started by: LinuxLearner
2 Replies

8. 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

9. Shell Programming and Scripting

Data export UNIX shell script

Hi, I want to write a shell script which connect to my database with the following credentials : User name : user PWD : rap_user_1 Hostname : app.Unix.Gsm1900.Org Port : 7862 SID : PTNC1 Once connected to DB i want to fetch data with the help of a SQL statement and expoet... (4 Replies)
Discussion started by: neeraj617
4 Replies

10. Shell Programming and Scripting

Run the Script from any stage by updating data from Oracle Table.

I have 100 Scripts, each containing 10-15 SQL's in them. Each Script run for 40 mins to 1 hour 30 mins. In the event of Failure in any step, if i re-start the Script, it will start running from the beginning. Which is waste of time. So in order handle this, i made the script to run from the... (7 Replies)
Discussion started by: kiran1992
7 Replies
shexp(1)						      General Commands Manual							  shexp(1)

Name
       shexp - display password expiration information for a user

Syntax
       shexp [-q] [username]

Description
       The command is used to display a user's password expiration information.  The specified username, or logname if no username is supplied, is
       converted to a UID by searching through the passwd file.  The UID is then used to look up the user's entry in  the  Auth  Data  Base.   The
       password expiration information is then printed out in format.
       % shexp
       Expires Tue Dec	6 10:49:18 EST 1988
       If  the	password  has  already expired the word Expires will be replaced with the word Expired. If password expiration is disabled for the
       particular user in question the output of will be Never expires.

Options
       -q   Instead of displaying the expiration date and time in format, outputs it as three decimal numbers: the minimum password lifetime,  the
	    maximum password lifetime, and the password modification time.  All three numbers are displayed as they are found in the database.

Restrictions
       Only the super-user may obtain information about users with UIDs other than the real UID of the invoking process.

Diagnostics
       User not found in passwd data base.
       There is no entry in for the specified username.

       Cannot stat auth file.
       The database is missing (security features may not be enabled).

       Insufficient privilege.
       An insufficiently privileged user is asking for information about a username with a UID different then their current real-UID.

       An exit value of 0 indicates a successful operation, any other exit status indicates an error.

Files
See Also
       passwd(1), getauthuid(3), auth(5)
       Security Guide for Users

																	  shexp(1)
All times are GMT -4. The time now is 10:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy