03-27-2013
Regarding executing sql query in shell script
Hi,
I have one SQL file prepared in UNIX and one script that is executing that.
In SQL i have Update and create queries.
I want to introduce conditions in SQL file (in UNIX) that if either of the create or update query failes whole transaction should be rollback.
I just have 1 create and 2 update and i dont want to work on SQL as i want this to be sorted out using shell scripting,
Thanks
Abhii
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I cannot figure out how to run a SQL script, or just a sqlplus query, from a shell script (bash or ksh). Basically, I need to su - oracle from root and run a query, then test the exit status. (3 Replies)
Discussion started by: 98_1LE
3 Replies
2. Shell Programming and Scripting
HI ALL
i have a requirement like this. i have to write a shell script to run a sql query. DB is oracle. once the query is run, the results of the query has to be published in a data file. can you please advice me how to go about it. i am absolutely new to shell scripts and this is a part of my job. (14 Replies)
Discussion started by: ragha81
14 Replies
3. Shell Programming and Scripting
Hi ALL,
I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know.
select query returns multiple values( say select name from emp)
Thanks in advance
LM (1 Reply)
Discussion started by: lijju.mathew
1 Replies
4. Shell Programming and Scripting
Hello,
I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?
Thanks (2 Replies)
Discussion started by: kingluke
2 Replies
5. Shell Programming and Scripting
query sql using shell script, is it possible?
my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script?
thanks in advance! (2 Replies)
Discussion started by: kingpeejay
2 Replies
6. UNIX for Dummies Questions & Answers
I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful. (3 Replies)
Discussion started by: nathanvaithi
3 Replies
7. Shell Programming and Scripting
Hi,
I need to call a shell script present on solaris server from within a PL / SQL block.
Kindly suggest..
Thanks
Sudhir (1 Reply)
Discussion started by: sudhird
1 Replies
8. Shell Programming and Scripting
Hi all,
My reqirenet goes like this.
Need to execute one select statement within the script and send a mail to the users with the number of records fecthed from the query.
Please help..
Thanks. (3 Replies)
Discussion started by: Achiever
3 Replies
9. Red Hat
hey , i am using this code to store value of a sql query and and then use
it in other query but after some time , but it is not working. please help
#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup... (5 Replies)
Discussion started by: ramsavi
5 Replies
10. UNIX for Beginners Questions & Answers
Hello~
I have a requirement to write a shell script which will connect to the oracle database and run a select count(*) query on a table.
The script should succeed only when the count returns a number greater than zero. If the count returns zero, the script should fail.
Can someone please... (3 Replies)
Discussion started by: Naren.N
3 Replies
LEARN ABOUT PHP
sql-types-with-pdo_4d-and-php
SQL-TYPES-WITH-PDO_4D-AND-PHP(3) 1 SQL-TYPES-WITH-PDO_4D-AND-PHP(3)
SQL types with PDO_4D and PHP - SQL types with PDO_4D and PHP
Supported SQL types
+-----------------+--------------------------------------+---+
| Type SQL 4D | | |
| | | |
| | Equivalent 4D | |
| | | |
| | Note | |
| | | |
+-----------------+--------------------------------------+---+
| ALPHA_NUMERIC | | |
| | | |
| | TEXT | |
| | | |
| | | |
| | T{ VARCHAR | |
| | | |
| | TEXT | |
| | | |
| | | |
| | T{ TEXT | |
| | | |
| | TEXT | |
| | | |
| | | |
| | T{ TIMESTAMP | |
| | | |
| | DATE | |
| | | |
| | | |
| | T{ INTERVAL | |
| | | |
| | HOUR | |
| | | |
| | | |
| | T{ DURATION | |
| | | |
| | HOUR | |
| | | |
| | | |
| | T{ BOOLEAN | |
| | | |
| | BOOLEAN | |
| | | |
| | | |
| | T{ BIT | |
| | | |
| | BOOLEAN | |
| | | |
| | | |
| | T{ BYTE | |
| | | |
| | INT32 | |
| | | |
| | | |
| | T{ INT16 | |
| | | |
| | SMALLINT | |
| | | |
| | | |
| | T{ SMALLINT | |
| | | |
| | SMALLINT | |
| | | |
| | | |
| | T{ INT32 | |
| | | |
| | INT32 | |
| | | |
| | | |
| | T{ INT | |
| | | |
| | INT32 | |
| | | |
| | | |
| | T{ INT64 | |
| | | |
| | INT64 | |
| | | |
| | | |
| | T{ NUMERIC | |
| | | |
| | INT64 | |
| | | |
| | | |
| | T{ REAL | |
| | | |
| | REAL | |
| | | |
| | Unsupported (use VARCHAR conversion) | |
| | | |
| FLOAT | | |
| | | |
| | FLOAT | |
| | | |
| | Unsupported (use VARCHAR conversion) | |
| | | |
|DOUBLE PRECISION | | |
| | | |
| | FLOAT | |
| | | |
| | | |
| | T{ BLOB | |
| | | |
| | BLOB | |
| | | |
| | Must use a prepared statement, and | |
| | PDO::PARAM_LOB | |
| | | |
| BIT VARYING | | |
| | | |
| | BLOB | |
| | | |
| | Must use a prepared statement, and | |
| | PDO::PARAM_LOB | |
| | | |
| CLOB | | |
| | | |
| | TEXT | |
| | | |
| | | |
| | T{ PICTURE | |
| | | |
| | PICTURE | |
| | | |
| | Must use a prepared statement, and | |
| | PDO::PARAM_LOB | |
| | | |
+-----------------+--------------------------------------+---+
PHP Documentation Group SQL-TYPES-WITH-PDO_4D-AND-PHP(3)