Hi,
I know in oracle a .sql file is called by @ <path> /<filename>.
But how to call in sql 2005, I am opening the sql sessionwith sqsh, is there any command to execute there a .sql file (query in sql 2005) in K shell script. (0 Replies)
Hi I'm looking to query a table on a database and then iterate over the results in a loop. I believe this is the last part of my script that I need (after finding out threads for passing variables to other scripts and calling functions in other scripts). I've searched the forums but the best... (8 Replies)
Hi
I am new in unix. oracle and unix are installed in my sytem.i need the script
which could connect to the oracle using username ,password and schema and can run the select * from tab query.
Thanks
vijay (8 Replies)
HI,
i want to write a script (Linux) that:
1) connect to a database oracle
2) execute some store procedure.
Can anybody help me, please?
Thanks a lot
Andrew (3 Replies)
Below i have the sample code. i need to pass the entire query from file or as parameter and read the results and write into a output file.
here the number of columns are unknown. some times it may be 2,3 or entire columns from the table.
read all the column results and write into a comma... (0 Replies)
I've been sent the following script to finish. It's supposed to connect to an oracle database, query it, and send an email if the query result value is one or more. Currently it isn't connecting properly, just giving the following error:
ERROR: ORA-01017: invalid username/password; logon denied... (2 Replies)
I have a requirement and below is the detail.
Create a shell script and needs to run in server "a".
Connect to teradata database server "b".
execute the .sql file from server "a"
Save the output of the query to a file in server "a"
Schedule this shell script to run every day for every 4... (1 Reply)
Hi Experts,
Need your support.
Not able to use sql query alias in shell script.
Could you please help me in finding right way to use alias with sql query in shell script.
Below is the code i am using.
#!/bin/bash
sqlplus -s abc/abc@abc << EOF> bcd.csv
set trimspool on
select zone_id... (4 Replies)
Discussion started by: as7951
4 Replies
LEARN ABOUT DEBIAN
user_clusters
USER_CLUSTERS(5) Debian PostgreSQL infrastructure USER_CLUSTERS(5)NAME
user_clusters - File linking users to PostgreSQL clusters
DESCRIPTION
This file maps users against the database clusters to which they will connect by default. However, every user can override these settings
in ~/.postgresqlrc.
When scanning this file, the first matching line will be used. It is a good idea to provide a default explicitly, with a final line where
both user and group are set to *.
If there is no default, the implicit default is to connect to the cluster whose postmaster is listening on port 5432 and to the database
matching the user's login name.
FORMAT
Comments are introduced by the character #. Comments may follow data on a line; the first comment character terminates the data. Leading
whitespace and blank lines are ignored.
Each uncommented, non-blank line must describe a user, group or the default (where both user and group are set to *).
Fields must be given in the following order, separated by white space:
USER The login id of the Unix user to whom this line applies. The wildcard character * means any user.
GROUP The group name of the Unix group to which this line applies. The wildcard character * means any group.
VERSION
The major PostgreSQL version of the cluster to connect to.
CLUSTER
The name of a cluster to connect to. A remote cluster is specified with host:port. If port is empty, it defaults to 5432.
DATABASE
Within the cluster, the database to which the user will connect by default if he does not specify a database on the command line.
If this is *, the default database will be the one named by the user's login id.
NOTES
Since the first matching line is used, the default line must come last.
SEE ALSO pg_wrapper(1), postgresqlrc(5)Debian Feburary 2005 USER_CLUSTERS(5)