|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
SQL in Unix
Post 302297480 by vbe on Friday 13th of March 2009 02:35:04 PM
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
LEARN ABOUT OSF1
kreg
kreg(8) System Manager's Manual kreg(8) NAME
kreg - Maintains the system file that registers kernel layered products SYNOPSIS
/sbin/kreg -d subset [-c NAME] | -l vendor subset path [-c NAME] OPTIONS
Causes the specified layered product to be loaded or deleted from the NAME.list file for the given name in addition to the /usr/sys/conf/.product.list file. Note that the NAME parameter is case sensitive and must exactly match the NAME prefix for the desired NAME.list file. Deletes the entry for the specified layered product when you remove it from the system. Loads the data that controls how to include the layered product in the kernel build process. DESCRIPTION
The kreg command maintains the /usr/sys/conf/.product.list system file, which registers static kernel layered products. The kreg command creates the file if it does not exist. The file enables system utilities or user supplied commands to locate the kernel parts of a layered product, and it provides information about layered products. The kernel tools use the /usr/sys/conf/.product.list file to build a layered product into the kernel. You can use the file to register a static kernel layered product that has been loaded into the system. The file also can be used by the layered product's Software Control Program (SCP), which is called by the setld command. You copy the /usr/sys/conf/.product.list file into the file that is used to extend the kernel configuration files and that has the follow- ing syntax: /usr/sys/conf/NAME.list The NAME variable specifies the system name that also is used in the system configuration file that has the following syntax: /usr/sys/conf/NAME The doconfig command also will copy the /usr/sys/conf/.product.list file. You can use the -c option to load or delete your layered product into a specific NAME.list file as well as the file. This is useful if you want to load your layered product into a specific NAME.list file without requiring the user to either copy the entire file to the NAME.list file or to manually edit the NAME.list file. The kreg command must be invoked from the root (/) directory. The command can be used only for subsets that are loaded by using the setld command. Also, you must be superuser to use the kreg command. FILES
Contains kernel layered product information. Used to extend the kernel configuration files. SEE ALSO
Commands: doconfig(8), setld(8) System Administration kreg(8)