SQLPLUS command with more than 1 select statement Post: 302901290

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Need to select count(*) from table to check for zero result in unix script

2. UNIX and Linux Applications

Oracle Select IN statement

If I recall, when I used informix I could do a sql statement like: SELECT Value from Table WHERE ID in (100,200,300); How do I do this in Oracle? I believe I am using Oracle 10 if that matters. Thanks.

3. Shell Programming and Scripting

In a csh script, can I set a variable to the result of an SQLPLUS select query?

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;...

4. Shell Programming and Scripting

redirecting oracle sqlplus select query into file

So, I would like to run differen select queries on multiple databases.. I made a script wich I thought to be called something like.. ./script.sh sql_file_name out.log or to enter select statement in a command line.. (aix) and I did created some shell script wich is not working.. it...

5. UNIX for Advanced & Expert Users

SQLPlus Select with Grep

I m trying to grep 'select * from' from a script, but the problem is with the * ... I think its taking * as some special character ... when I try to do grep '*' test (test is my test file) its displaying * But when I am trying to do grep 'select * from' test its not showing anything...

6. UNIX and Linux Applications

linux sqlplus select results writes into file twice

Hello, This is my first post and its because I could not find solution for myself I decided to ask help here. What I want to do; I want to get some data from a table 1 on server 1 and insert those datas into a table 2 on server 2. ( lets say schema names are server1 and server 2 also )....

7. Programming

SQLPlus Case statement on a substring

Hi, I have an SQL query that returns a substring of a field and I want to work a case statement on it, but either I get a syntax error or in it's current manifestation the case is ignored all together. select distinct dbms_lob.substr(msg_body,1,4) as networkId, A_STATUS, count(*) from...

8. Shell Programming and Scripting

Connecting sqlplus from UNIX with multiple select statement

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 ...

9. Shell Programming and Scripting

Use sqlplus statement inside case sentence

Hello, I have a problem. I want to launch a different sql queries for different shell parameter values, something like this. #/bin/bash case $1 in "A") sqlplus -s user/pass << SQL query A; SQL "B") sqlplus -s user/pass << SQL2 ...

10. Shell Programming and Scripting

How to pass Variable from shell script to select query for SqlPlus?

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...

LEARN ABOUT CENTOS

vfs_preopen

VFS_PREOPEN(8)						    System Administration tools 					    VFS_PREOPEN(8)

NAME

       vfs_preopen - Hide read latencies for applications reading numbered files

SYNOPSIS

       vfs objects = preopen

DESCRIPTION

       This VFS module is part of the samba(7) suite.

       This module assists applications that want to read numbered files in sequence with very strict latency requirements. One area where this
       happens in video streaming applications that want to read one file per frame.

       When you use this module, a number of helper processes is started that speculatively open files and read a number of bytes to prime the
       file system cache, so that later on when the real application's request comes along, no disk access is necessary.

       This module is stackable.

OPTIONS

       preopen:names = /pattern/
	   preopen:names specifies the file name pattern which should trigger the preopen helpers to do their work. We assume that the files are
	   numbered incrementally. So if your file names are numbered FRAME00000.frm FRAME00001.frm and so on you would list them as
	   preopen:names=/FRAME*.frm/

       preopen:num_bytes = BYTES
	   Specifies the number of bytes the helpers should speculatively read, defaults to 1.

       preopen:helpers = NUM-PROCS
	   Number of forked helper processes, defaults to 1.

       preopen:queuelen = NUM-FILES
	   Number of files that should be speculatively opened. Defaults to the 10 subsequent files.

VERSION

       This man page is correct for version 3.3 of the Samba suite.

AUTHOR

       The original Samba software and related utilities were created by Andrew Tridgell. Samba is now developed by the Samba Team as an Open
       Source project similar to the way the Linux kernel is developed.

       The PREOPEN VFS module was created with contributions from Volker Lendecke and the developers at IBM.

Samba 4.0							    06/17/2014							    VFS_PREOPEN(8)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Discussion started by: struggle

2. UNIX and Linux Applications

Oracle Select IN statement

Discussion started by: benefactr

3. Shell Programming and Scripting

In a csh script, can I set a variable to the result of an SQLPLUS select query?

Discussion started by: gregrobinsonhd

4. Shell Programming and Scripting

redirecting oracle sqlplus select query into file

Discussion started by: bongo