Hi All,
I have written 4 sql queries . Now I want to write one SHELL SCRIPTING program for all these queries...
i.e
1.select * from head;
2. select * from detail;
3. delete from head;
4. delete from detail;
Please let me know how to write a shell script...
Thank you (1 Reply)
Hello Guys...
I want a small help from you guys.
Actually in Oracle, we are having a utlity called spool through which can store whatever SQL statements executed and other queries and the output of those queries in a file
So, similarly in Unix, if I start a session executing a number of Unix... (2 Replies)
I'm having problems with writing my sql results to a file:
sqlplus -S username/password@DB <<!!
set echo off
set verify off
set showmode off
set feedback off
set timing off
set linesize 250
set wrap off
set pagesize 0
set newpage none
set tab off
set trimspool on
set colsep... (1 Reply)
While assisting a forum member, I recommended running SQL/Plus in a coprocess (to make database connections and run a test script) for the duration of his script rather than starting/stopping it once for every row in a file he was processing.
I recalled I made a coprocess example for folks at... (2 Replies)
Hi,
I am new to linux...
How to Assign SQL Query Results to Variables in Linux,i want ti generate it in param files, Can anyone please explain me.
Ex: SQL> Select * from EMP;
O/P: Emp_No Emp_Name
1 AAA
2 BBB
3 CCC
and I want expected... (5 Replies)
Requirement 1) I need to execute 15 SQL queries in oracle through linux script. All these query results needs to be stored in array variables.
Requirement 2) And these 15 queries needs to be executed in parallel.
Requirement 3) Once all the queries executed then the shell script should... (3 Replies)
how to store the count of queries in variables inside a filein shell script
my output :
filename
-------
variable1=result from 1st query
variable2=result from 2nd query
.
.
.
. (3 Replies)
Hi All,
I have a file queries.txt as follows :
SELECT COLUMN1 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN1 FROM SCDEMA2.TABLE2;
SELECT COLUMN2 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN2 FROM SCDEMA2.TABLE2;
SELECT COLUMN3 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN3 FROM SCDEMA2.TABLE2;
SELECT... (2 Replies)
How to run multiple Queries in a ksh Script
I have a KSH script that has one SQL Query and generates and emails output of the query in HTML format. I want to change the script so that it has three SQL queries and the last query generates and emails the HTML output page of just that query.
So far... (5 Replies)
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)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT PHP
pkginfo
pkginfo(1) User Commands pkginfo(1)NAME
pkginfo - display software package information
SYNOPSIS
pkginfo [-q | -x | -l] [-p | -i] [-r] [-a arch] [-v version] [-c category...] [pkginst...]
pkginfo [-d device] [-R root_path] [-q | -x | -l] [-a arch] [-v version] [-c category...] [pkginst...]
DESCRIPTION
pkginfo displays information about software packages that are installed on the system (with the first synopsis) or that reside on a par-
ticular device or directory (with the second synopsis).
Without options, pkginfo lists the primary category, package instance, and the names of all completely installed and partially installed
packages. It displays one line for each package selected.
OPTIONS
The -p and -i options are meaningless if used in conjunction with the -d option.
The options -q, -x, and -l are mutually exclusive.
-a arch Specify the architecture of the package as arch.
-c category Display packages that match category. Categories are defined with the CATEGORY parameter in the pkginfo(4) file. If more
than one category is supplied, the package needs to match only one category in the list. The match is not case specific.
-d device Defines a device, device, on which the software resides. device can be an absolute directory pathname or the identifiers
for tape, floppy disk, removable disk, and so forth. The special token spool may be used to indicate the default installa-
tion spool directory (/var/spool/pkg).
-i Display information for fully installed packages only.
-l Specify long format, which includes all available information about the designated package(s).
-p Display information for partially installed packages only.
-q Do not list any information. Used from a program to check whether or not a package has been installed.
-r List the installation base for relocatable packages.
-R root_path Defines the full path name of a directory to use as the root_path. All files, including package system information files,
are relocated to a directory tree starting in the specified root_path.
-v version Specify the version of the package as version. The version is defined with the VERSION parameter in the pkginfo(4) file.
All compatible versions can be requested by preceding the version name with a tilde (~). Multiple white spaces are replaced
with a single white space during version comparison.
-x Designate an extracted listing of package information. The listing contains the package abbreviation, package name, package
architecture (if available) and package version (if available).
OPERANDS
pkginst A package designation by its instance. An instance can be the package abbreviation or a specific instance (for example,
inst.1 or inst.2). All instances of a package can be requested by inst.*. The asterisk character (*) is a special character
to some shells and may need to be escaped. In the C-Shell, "*" must be surrounded by single quotes (') or preceded by a
backslash ().
EXIT STATUS
0 Successful completion.
>0 An error occurred.
FILES
/var/spool/pkg default installation spool directory
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO pkgtrans(1), pkgadd(1M), pkgask(1M), pkgchk(1M), pkgrm(1M), pkginfo(4), attributes(5)
Application Packaging Developer's Guide
SunOS 5.10 6 Nov 2000 pkginfo(1)