12-10-2007
select count(*) in sqlplus into variable unix shell
Need to select count(*) from table to check for zero result in unix script
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Could anybody help me how can I assign the value of "select count(*) from table1" to a variable in an unix shell script. Thanks. (4 Replies)
Discussion started by: nguda
4 Replies
2. UNIX for Advanced & Expert Users
hi fellows,
can any body tell me how to pass unix variables to oracle
code is...
#! /bin/ksh
echo ENTER DATE VALUE's
read START_DATE END_DATE
sqlplus xyx/abc@oracle
select * from table1 where coloumn1 between $START_DATE and $END_DATE;
is this is correct way...........
Thanks in... (1 Reply)
Discussion started by: chiru
1 Replies
3. Shell Programming and Scripting
Hi,
I am writing a script which creates an external table using a shell script. My requirement is like this.
Usage: . ./r.ksh <table_name> - this should create an external table.
e.g . ./r.ksh abc - this should create an external table as abc_external.
How do i achieve this? Please... (5 Replies)
Discussion started by: Anaramkris
5 Replies
4. Shell Programming and Scripting
Can someone tell me why I'm getting error when I try to run this?
#!/bin/csh -f
source ~/.cshrc
#
set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus
#
set count=`$SQLPLUS -s ${DB_LOGIN} << END
select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;... (7 Replies)
Discussion started by: gregrobinsonhd
7 Replies
5. Shell Programming and Scripting
Hi All,
I have browsed through the forums for a similar topic, but there is no topic which explains about this problem, when the backend is DB2.
I want to assign the output of a select count(*) from tablename to a unix variable in a shell script.
I am using ksh.
The database used to... (3 Replies)
Discussion started by: Siddarth
3 Replies
6. Shell Programming and Scripting
I am trying to import a sqlplus output into a shell variable but it doesnt seem to be working.
set -x
export DEPENDENT_CR_NO=`sqlplus -s /nolog <<EOF
conn username/passwd
set heading off
select dependency from custom_patches where patch_name='PATCH.zip';
exit;
EOF`
echo $DEPENDENT_CR_NO
... (2 Replies)
Discussion started by: beginer314
2 Replies
7. Shell Programming and Scripting
hi,
i have a requirement where i need to connect sqlplus from unix and i am able to do so by following command:
cust_count=`sqlplus -s $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID << EOF
set pagesize 0
set feedback off
set verify off
... (1 Reply)
Discussion started by: lovelysethii
1 Replies
8. Shell Programming and Scripting
echo "set echo off"; echo "set feedback off"; echo "set linesize 4000"; echo " set pagesize 0"; echo " set sqlprompt ''"; echo " set trimspool on";
Select statement is mentioned below
echo "select res.ti_book_no from disney_ticket_history res where res.ti_status =${STATUS} and... (7 Replies)
Discussion started by: aroragaurav.84
7 Replies
9. Shell Programming and Scripting
Hi ,
I am using below code :
for i in `ps -ef|grep pmon|awk {' print $8 '}|cut -f3 -d'_'|grep -v '^grep'`
do
ORACLE_SID=$i
export ORACLE_SID;
dest=`sqlplus "/ as sysdba" <<EOF
set heading off feedback on verify off
select DESTINATION from v\\$archive_dest where target in... (5 Replies)
Discussion started by: admin_db
5 Replies
10. UNIX for Beginners Questions & Answers
hi guys
i have a sqlplus :
sqlplus -s username/password << EOF
@mysql.sql
EOF
in mysql.sql there is a count of a table, i want to write in a variabile unix.
how can i do?
Thanks a lot
Regards
Francesco. (3 Replies)
Discussion started by: Francesco_IT
3 Replies
LEARN ABOUT PHP
fbsql_fetch_field
FBSQL_FETCH_FIELD(3) 1 FBSQL_FETCH_FIELD(3)
fbsql_fetch_field - Get column information from a result and return as an object
SYNOPSIS
object fbsql_fetch_field (resource $result, [int $field_offset])
DESCRIPTION
Used in order to obtain information about fields in a certain query result.
PARAMETERS
o $
result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).
o $field_offset
- The numerical offset of the field. The field index starts at 0. If not specified, the next field that wasn't yet retrieved by
fbsql_fetch_field(3) is retrieved.
RETURN VALUES
Returns an object containing field information, or FALSE on errors.
The properties of the object are:
o name - column name
o table - name of the table the column belongs to
o max_length - maximum length of the column
o not_null - 1 if the column cannot be
NULL
o type - the type of the column
EXAMPLES
Example #1
fbsql_fetch_field(3) example
<?php
fbsql_connect($host, $user, $password)
or die("Could not connect");
$result = fbsql_db_query("database", "select * from table")
or die("Query failed");
# get column metadata
$i = 0;
while ($i < fbsql_num_fields($result)) {
echo "Information for column $i:<br />
";
$meta = fbsql_fetch_field($result);
if (!$meta) {
echo "No information available<br />
";
}
echo "<pre>
max_length: $meta->max_length
name: $meta->name
not_null: $meta->not_null
table: $meta->table
type: $meta->type
</pre>";
$i++;
}
fbsql_free_result($result);
?>
SEE ALSO
fbsql_field_seek(3).
PHP Documentation Group FBSQL_FETCH_FIELD(3)