I have 28 records in:
what is it that I needed to keep the 28 records without been filter away by line 6 statement... but then, I need the line 6 statement to meet the critera....
---------- Post updated at 02:54 PM ---------- Previous update was at 02:25 PM ----------
I tried this but it gives me duplicate records when it meets both condition =/
---------- Post updated at 02:58 PM ---------- Previous update was at 02:54 PM ----------
I wish to implement this aft where can anyone gimme an approach?
---------- Post updated at 03:05 PM ---------- Previous update was at 02:58 PM ----------
any tips to rephrase this line?
---------- Post updated at 03:28 PM ---------- Previous update was at 03:05 PM ----------
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Hi
i need code to get sql queries through a shell script for a text file input which contain the service ids
iputfile
I-H-2048-10GB-M
I-H-4096-12GB-M
I-H-2048-p1000-M
the code should contain below queries among which service_id is replacable with value from input file.
... (4 Replies)
readNOW=$(date +"%Y%m%d%H%M")
read readTerminal #input B
terminalc=$readTerminal
echo eqpt_list_QC_$terminalcT_$readNOW
how to get display result it:
eqpt_list_QC_BT_201209121530 (2 Replies)
Hi ,
I have a txt file with contents like:
1234
2345
3456
7891
I need to write a script which takes input file as txt file..run a sql query for that number and place the output of query in another file..
select * from bus_event where acct_nbr='1234'( from input txt file)
the query... (20 Replies)
Hi All
I have a problem with one of my scripts which checks for he status of an Oracle database.
Here's the script:
#!/bin/ksh
sqlplus -s '/nolog' <<EOF
connect / as sysdba
set heading off
spool db_status.txt
select OPEN_MODE from v\$database
/
exit
EOF
db_status=$(more... (4 Replies)
Hi,
I need confirmation whether the same functionality exists when running the sql's.
For ex. let us consider there exists a sql file with name june.When running in sql mode does:
@june.sql and start june.sql does the same functionality.
Someone help me.
Thanks
Ashok. (1 Reply)
Hi all,
I have a script which takes in sqlfile as argument and executes the sql
execSqlFile()
{
sqlFile=$1
sqlplus -S $DBLOG/$DBPWD@$DBSVR < $sqlFile
}
This works fine if the sql file is plain, simple and pre-defined statment. But i want to have a sql file which itself... (2 Replies)
Hi All,
I have a Sqlplus report which will create a file.
I need a FTP Script that will be executed inside the Sqlplus Report to FTP the report output file to unix server.
Thanks,
Previn (0 Replies)