This gives me always 0. When I run from the GUI tool for count 13.
When I change the query to select count(*) from table I will get the correct result
please tell me how to change the SQL code so that it gives me correct result.
select count(*) from table order by start desc
It gives out the count.
Are you sure that the SELECT statement works ?
Apparently, start is reserved word and cannot be used as a column name in an Oracle table.
The only way to make it work (that I can think of) is to put start within double quotes in the CREATE TABLE statement.
But then, you'll have to use double quotes in your SELECT statement as well.
In that case, I guess the OP incorrectly believes that the shell variable "result" holds the record count of the table. It does not.
The value of "result" will be 0 if -
(i) the "sqlplus" command was run successfully, which means that the ORACLE_HOME was set, and
(ii) all commands in the sqlplus session ran successfully
That the record count of the table in the sqlplus session is <n>, is a different matter altogether. The value <n> will not be assigned to "result".
The OP's SELECT statement works, probably because the column (start, or whatever) is a VARCHAR2 and also, the LIKE operator works with a literal string as well.
Since the query works and sqlplus works in my environment, the shell script would run successfully as well, but the value of "result" will not be 2.
But if there's something wrong with the SELECT statement, then the error code will be non-zero:
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Hi,
I need to excute two .sql scripts sequentially within file.sh
sqlplus user/pass@db1 @/opt/Infor/Outbound_Marketing/7.2.2/custom/iadeploy1.sql
THEN
sqlplus user/pass@db2 @/opt/Infor/Outbound_Marketing/7.2.2/custom/iadeploy3.sql
Thanks,
Soph (4 Replies)
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
There are 4 parameters that I have to pass from korn shell to sql script.
1) I have to check if $1 , $2 , $3 and $4 are null values or not .
How can I do that ?
2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
I need help in the following script. I want to grep the sql errors insert into the error table and exit the shell script if there is any error, otherwise keep running the scripts.
Here is my script
#!/bin/csh -f
source .orapass
set user = $USER
set pass = $PASS
cd /opt/data/scripts
echo... (2 Replies)
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Guys,Please look at a simple shell which validates presence of a customer table in OASIS schema. SQL Query for validation is wrong(Table name in quotes should not have schema name OASIS.). And shell is working correctly (with exit 1) as it will never get count=1 with this query.
But it is... (2 Replies)
Hi,
I am able to insert the values into a database table from a flat file using SQL loader. Now can I do the same using only shell script.Can this be done without using sql loader and only with shell scripting(ie use of awk). Please put some light on this.
Thanks in advance (3 Replies)
Hi,
I have an issue. There is a file that has got some values seperated by commas. I have to write a shell script that would extrct these values and insert them into a table. How can this be done
Thanx in advance (3 Replies)