10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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.
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
2. Shell Programming and Scripting
I have a large number of input files with two columns of numbers.
I only wish to retain lines where the numbers fullfil two requirements. E.g:
To do this I use the following... (10 Replies)
Discussion started by: s052866
Is there any other editor, installed by 'default' in Sparc Solaris10, besides vi?
I'd like to avoid installing anything new.
If not, how to make vi more user-friendly?
thanks. (8 Replies)
Discussion started by: orange47
Hopefully there is someone out there on this forum who can help with this Oracle SQL Developer issue I have.
Here is the code:
CREATE OR REPLACE VIEW
E.FIRST_NAME || ' ' || E.LAST_NAME AS EMPLOYEE_NAME,
... (2 Replies)
Discussion started by: U_C_Dispatj
5. UNIX for Advanced & Expert Users
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
6. Shell Programming and Scripting
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
7. Shell Programming and Scripting
Hi techies ..
This is my first posting hr ..
Am facing a serious performance problem in counting the number of lines in the file. The input files i get will be in some 10 to 15 Gb of size or even sometimes more ..and I will load it to db
I have used wc -l to confirm whether the loader... (14 Replies)
Discussion started by: rajesh_2383
8. UNIX for Dummies Questions & Answers
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
ASDComplete... (1 Reply)
Discussion started by: reptile
I have a stored procedure that is failing. The current query behind it is:
<many, many values>
LEFT OUTER JOIN table2 ON
(select max (table2.key) from table2
where table2.key = table1.key) or
... (0 Replies)
Discussion started by: Elric of Grans
10. Shell Programming and Scripting
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini