05-31-2011
Well, a product may have 1 to N parent categories, so you need a querying mechanism that can recurse the categories dynamically. Oracle has this, not sure about others.
You might do an N way join and case it so if this product's depth is not N, the missing categories resolve to '' and every n+1 query knows also case to ''. Now, you can concatenate categories and report the path.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
can nested SQl be run in Unix Script?
I tried some and found only simply sql(one select) can work well in unix script. (21 Replies)
Discussion started by: YoYo
21 Replies
2. Shell Programming and Scripting
Hi-
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
5 Replies
3. 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
4. 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
5. 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
6. Shell Programming and Scripting
Hi,
Would someone know if I can fire nested sql queries in a shell script? Basically what I am trying to do is as follows:
my_sql=$(sqlplus -s /nolog<<EOF|sed -e "s/Connected. *//g"
connect... (2 Replies)
Discussion started by: shrutihardas
2 Replies
7. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
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
6 Replies
8. UNIX for Advanced & Expert Users
Hi Experts:
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
3 Replies
9. Shell Programming and Scripting
Hi,
i m trying to create script which logic is like below.
if ; then
x=`cat /tmp/testoutput.log | grep STOP | wc -l`
y=`cat /tmp/testoutput.log | grep RUN | wc -l`
if ; then
echo "process stop"
if ; then
echo "process running "
else
echo "file not found"
fi
----------------... (2 Replies)
Discussion started by: tapia
2 Replies
10. Shell Programming and Scripting
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
QUIZ(6) BSD Games Manual QUIZ(6)
NAME
quiz -- random knowledge tests
SYNOPSIS
quiz [-t] [-i file] [question answer]
DESCRIPTION
The quiz utility tests your knowledge of random facts. It has a database of subjects from which you can choose. With no arguments, quiz
displays the list of available subjects.
The options are as follows:
-t Use tutorial mode, in which questions are repeated later if you didn't get them right the first time, and new questions are presented
less frequently to help you learn the older ones.
-i Specify an alternative index file.
Subjects are divided into categories. You can pick any two categories from the same subject. quiz will ask questions from the first cate-
gory and it expects answers from the second category. For example, the command ``quiz victim killer'' asks questions which are the names of
victims, and expects you to answer with the cause of their untimely demise, whereas the command ``quiz killer victim'' works the other way
around.
If you get the answer wrong, quiz lets you try again. To see the right answer, enter a blank line.
Index and Data File Syntax
The index and data files have a similar syntax. Lines in them consist of several categories separated by colons. The categories are regular
expressions formed using the following meta-characters:
pat|pat alternative patterns
{pat} optional pattern
[pat] delimiters, as in pat[pat|pat]pat
In an index file, each line represents a subject. The first category in each subject is the pathname of the data file for the subject. The
remaining categories are regular expressions for the titles of each category in the subject.
In data files, each line represents a question/answer set. Each category is the information for the question/answer for that category.
The backslash character (``'') is used to quote syntactically significant characters, or at the end of a line to signify that a continuation
line follows.
If either a question or its answer is empty, quiz will refrain from asking it.
FILES
/usr/share/games/bsdgames/quiz The default index and data files.
BUGS
quiz is pretty cynical about certain subjects.
BSD
May 31, 1993 BSD