Sponsored Content
Full Discussion: SQL in Unix
Top Forums UNIX for Dummies Questions & Answers SQL in Unix Post 302297480 by vbe on Friday 13th of March 2009 02:35:04 PM
Old 03-13-2009
SQLplus is oracle product and you will find it $ORACLE_HOME/bin
(Usually ~oracle/product/<vesrion>/bin)
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SQL Commands in Unix

Hi gurus, Being a newbie not sure whether iam asking the right question? can we use oracle commands in unix for ex: to read a count on a table. if so, what needs to be configured and etc.. any kind of help is appreciated. Thanks sish (6 Replies)
Discussion started by: sish78
6 Replies

2. Shell Programming and Scripting

Using SQL in Unix

Please tell me how i can use SQL in my unix scripts. Please give examples. I just want to start writing some scripts for my use. Looking for ur cooperation. thanks (2 Replies)
Discussion started by: Mohit623
2 Replies

3. Shell Programming and Scripting

sql through unix.

when we are spooling query o/p to certain txt file,in that file how we can get headers in the query.(through unix shell scripting). for exmple q1="slect * from XXXXXX;"; sqlplus XXX/XXXX@XXXXX spool XXXX.txt $q1 spool off in the text file i want the headers of the query..... ... (1 Reply)
Discussion started by: bhagya.puccha
1 Replies

4. Shell Programming and Scripting

unix variables from sql / pl/sql

How do I dynamically assign the below output to unix shell variables so I can build a menu in a shell script? Example: var1 = 1 var2= SYSTEM var3 = 2 var4= UNDOTBS1 and so on, then in the shell script I can use the variables to build a menu. set serveroutput on declare... (2 Replies)
Discussion started by: djehres
2 Replies

5. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies

6. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

7. Programming

Doing a SQL rollup in unix

If anyone is familiar with Oracle, there is a way to trace a file. Then there is is a script called tkprof that will generate a report that includes a rollup of some values. The problem with this script is that it only does the rollup properly if the query is finished. So I need something quick and... (2 Replies)
Discussion started by: guessingo
2 Replies

8. Shell Programming and Scripting

Unix and SQL server

Hi All, I am accessing Unix through putty (i.e. unix is installed on other server and i am accessing it remotely through putty). I am having SQL Server 2008 installed on my computer. Now i want to access sql server via. unix. Could some one please help me in this!!! Thanks (2 Replies)
Discussion started by: preetpalkapoor
2 Replies

9. Shell Programming and Scripting

Formatting sql in UNIX

hi folks am running the shell script below #!/bin/bash sqlplus 'scott@orcl/tiger'<<ENDSQL >> outputlogfile.csv SET PAGES 0 SET HEAD ON SET ECHO OFF SET FEEDBACK OFF SET LINESIZE 100 SET PAGESIZE 100 SET SERVEROUTPUT ON --# Fire the query on database select * from employee; ... (2 Replies)
Discussion started by: coolboy98699
2 Replies

10. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
newinv(1)						      General Commands Manual							 newinv(1)

NAME
newinv - Updates distribution kit master inventory SYNOPSIS
/usr/bin/newinv mi-file input-path... OPERANDS
The pathname of the master inventory file to be processed. If no master inventory file exists, you must create an empty one before using the newinv command. The name of the product hierarchy to be scanned for files belonging in the inventory. All files and directories found below the input-path are processed as belonging in the inventory. DESCRIPTION
The newinv command interactively maintains the master inventory files used for producing distribution kits in setld format. The program updates the master inventory for a product when changes are made to the hierarchy of files that are to be packaged in the subsets which constitute the product. The product hierarchy is scanned to produce a list of component path names relative to input-path. The list of pathnames is processed against the mi-file to produce a list of files that have been removed from the product hierarchy and a list of files that have been added. The user is then given an opportunity to intervene and direct the inventory maintenance by editing these lists. The user is placed in the editor with each list available for editing. The editor used is the one specified by the EDITOR environment variable. If EDITOR is not set, vi is used. When editing the list of files that have been removed from the product, the user is expected to verify that the removals were intentional and confirm the intent by removing the associated records from the file. When editing the list of added files, the user is expected to provide options and subset information for each new file, transforming the elements of the list into master inventory records. To produce a new copy of the master inventory file, both of these lists are merged with the records for the files which existed in the pre- vious version and are still included. RESTRICTIONS
The default text editor, if not specified in $EDITOR, is /usr/ucb/vi. Files in the product hierarchy cannot be excluded from the master inventory. Files can be blocked from being kitted in the final distribu- tion kit by setting the subset field of the master inventory record to a minus sign (-). ERRORS
The mi-file specified on the command line cannot be found. The input-path directory specified on the command line does not exist. EXAMPLES
To update the hypothetical master inventory file OAT100.mi from the hierarchy beginning at /var/kits/input, type: newinv OAT100.mi /var/kits/input FILES
Backup copy of master inventory The list of files missing from the product The list of files new to the product Intermediate join file List of all files in the product SEE ALSO
invcutter(1), kits(1), vi(1), setld(8) stl_mi(4) environ(5) Guide to Preparing Product Kits newinv(1)
All times are GMT -4. The time now is 02:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy