If you already have shell script front end, would it be acceptable to prompt
for the input in the shell script rather than in the procedure?
#!/bin/ksh
echo "ENTER LOGIN"
read USER
echo "ENTER PASSWORD"
stty -echo
read PASS
stty echo
echo "ENTER WHAT IT IS"
read INPUT
sqlplus -s <<-XXX
${U
-
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list yo
Larry is God.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
needed in
> the LD_LIBRARY_PATH. Could be you need some system libs to
> do your linking.
>
> Try doing "echo $LD_LIBRARY_PATH" to see what else is in it.
>
> Jared
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMA
1000 lines in my data file. I want to add
> '(comma) at the begining and end of each line.
>
> For example,
>
> abf
> jd
> djkhk
> jd3
>
> Shold be convrted to
>
> 'abf',
> 'jd',
> 'djkhk',
> 'jd3',
>
Oh, and I almost forgot a ksh example
(Perl? What's Perl?)
cat your_file | while read LINE; do echo "'$LINE'"; done
Or
while read LINE; do echo "'$LINE'"; done < your_file
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Au
How about:
select sum(bytes) from dba_segments where segment_name = 'TABLE_NAME';
-Original Message-
Hi All,
Could somebody help me in finding the actual size of an oracle table in
GB.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
-- --
> > > > > SYSTEM893
> > > > >
> > > > > 1 row selected.
> > > > >
> > > > > SQL> /
> > > > >
> > &
Just one transaction. Nothing else going on.
> -Original Message-
>
> Stephen,
>
> Was this the only running transaction?
>
> No background stuff going on?
>
> Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
I
1 row selected.
> >
> > SQL> /
> >
> > USERNAMEX
> > -- --
> > SYSTEM 3181
> >
> > 1 row selected.
> >
> > SQL> /
> >
> > USERNAME
does seem a little weird.
>
> Jared
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
I saw that on cnn.com too. Didn't the article say the guy has broken his
neck three times? Maybe that tells you something.
> -Original Message-
>
> British Company Declares War On Internal E-mail
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
-
SYSTEM 3181
1 row selected.
SQL> /
USERNAMEX
-- --
SYSTEM 3204
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
F
S_STATS and CBO
>
>
>
> To avoid any sparse file issues in future, I recommend you to copy the
> tempfiles to another name using cp, then rename back,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Se
sultant as
> they work. Non-dba access to the datafiles is just stupid,
> and anyone
> who would allow it deserves everything they get.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Servi
gt; Note that the index create blew up immediately, so the
> original tempfile
> > never grabbed any space. So, I think I can say that is
> definitely didn't
> > run out of space; but maybe somebody walked across the
> space the t
Sorry about the last post. Forgot to change the subject. Duh!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
ginal tempfile
never grabbed any space. So, I think I can say that is definitely didn't
run out of space; but maybe somebody walked across the space the tempfile
thought it was going to get in the future.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen
http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself
containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED
> Cary is referring to. Which means you'll have to buy a new book.
>
> As for Cary's book, I have it on order at Amazon as well, but
> according
> to the site today, it's still not released. :(
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Au
n't think it handles
> some of the newer data types.
>
> I think the OP meant from within SQL rather than SQL*Plus.
>
> kind regards
>
> Pete
>
> In article <[EMAIL PROTECTED]>, Stephen Lee
> <[EMAIL PROTECTED]> writes
> >
> >The COPY comman
information right into the
select statement. Can it be done?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
E-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself f
: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself
Maybe find something at http://sunsolve.sun.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
And for you cobol users out there:
we have been told that the bug related to setting
cursor_sharing=force
when using cobol has been fixed in 9.2.0.4.
So maybe that will help keep the 4031 bug in its box.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
but it doesnt work with chmod 755
> It says permission denied then.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.c
-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE
gt; make the situation
> even worse, because in time, the LRU and freelists get even
> longer, thus one
> scan takes more time to complete or fail.
>
> >
> > _kghsidx_count = 1
>
> (The correct name is _kghdsidx_count)
>
--
Please see the official ORACLE-L FAQ: http://www.or
There is
a parameter (so I have been told)
_kghsidx_count = 1
that makes the shared pool one big memory area.
One of the "fixes" in 9.2.0.4 is to make this the default now (so I have
been told).
> -Original Message-----
> From: Stephen Lee
> Sent: Thursday, September 11,
are still stuck with
by guess and by golly fiddling with the shared pool.
> -Original Message-
>
> Anyone have any negative experiences with 9.2.0.4 yet?
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat
}'
> -Original Message-
>
> I need to export the data from an Oracle 8.1.7 database HPUX 64 and
> import it back into an old 7.3.4 HPUX 32 database.
> The 7.3.4 import doesn't like the 8.1.7 export file.
>
> Any ideas?
--
Please see the offici
event,
total_waits,
total_timeouts,
time_waited/100 time_waited,
average_wait
from v$system_event
order by time_waited
/
ttitle off
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Servi
1. Maybe,
maybe not. To make a point, take it to a ridiculous extreme: Suppose you
have a tablespace of 100M with two rollback segments made of 1M extents
sizes. Then each segment must use 2M each (minextents must be at least 2)
which means either segment could possibly grow to use 98M
.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list,
,
s.osuser,
s.sid,
s.serial#,
s.process "USER PRCS",
p.spid "SVR PRCS"
from v$process p,v$session s
where p.addr = s.paddr
and s.username <> ' '
/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephe
Oh wow! And Tie Fighter too?!!
> -Original Message-
>
> Actually there is a Linux clone of MechWarriors
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-5
--
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> a
If the job is running, I think you have to kill the session running the job
after removing the job.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
E-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE y
ficial ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hostin
er cluster to beat it.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
n to
> check it more closely against your requirements.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://ww
em all uniform in size?
>
> I would think having multiple datafiles that could be spread across
> drive volumes would be beneficial, am I wrong? (Wouldn't be the first
> time :)
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EM
x27;t blatant favoritism, I don't
think it will be a problem.
> -Original Message-
>
> How do you balance the load among your team?
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Servi
h. My guidance counselor insisted I gild the
> lily and take the
> exams again. I showed up that morning with no sleep, a
> throbbing hangover,
> and eyes looking like fried eggs pasted to my head...
>
> ...scored 60 points better...
>
>
>
> on 8/4/03 11:
t;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and we
t; commands.
>
> But in your case, I think you got ahold of a MSDOS/Windows text file.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Cal
ference. boot
> into windows and
> every thing works fine.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing l
No no! Not EDS. That was Ed's. As in:
"Ed's plumbing, welding, and database admin"
( and "professional dancing")
> -Original Message-
>
> Didn't the UK outsource their IT function to EDS?
>
--
Please see the official ORACLE-L FAQ: http:
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
d to the max.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
amp; his greedy deputy Chaney.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Maili
a
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Maili
Not Elizabeth Hurley ... :-))) !!
> -Original Message-
>
>
> Everything looks like a big hammer to you,
> doesn't it Stephen?
>
> ;)
>
\
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTE
ll if he is right, but he has a
> better inside track to the Oracle gossip that I do.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
15k servers with RAC, ostensibly
> for scalability. Some nodes are populated with 78 CPU's and 288
> Gig of RAM. ( yes, that is correct ).
>
> Jared
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City
g LMTs, then the recursive SQL
> shouldn't be too
> bad.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-505
; then
> unset ORACLE_SID
> fi
> # If operating system SunOS then dynamic library path must be set
> if [ `uname -s` = "SunOS" ]; then
> # 30 Nov 99
> # Following added if using Oracle 8.1.5. The "proc" utiltiy (pro*c
> compi
nded...
>
> No wonder I failed my first try at the 9iOCP upgrade exam.
> Yes, I'll try
> again, once the lobotomy scars heal...
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-
and not found
bash: nawk: command not found
bash: nawk: command not found
bash: nawk: command not found
bash: nawk: command not found
bash: nawk: command not found
ORACLE_HOME = [/oracle/app/oracle] ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EM
t; ... and they
> don't even have Umlaute ;).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity
There's nothing like a good high colonic to make you want to have kids!
> -Original Message-
>
> not very slick but I used MINUS yesterday to find parents with no
> children so as to purge them
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
or these requirements; it was not my idea...
This is 9.2.0 on Sun Solaris.
Thanks,
Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
running Oracle on WINE and IBM dropping
AIX..
What a joke...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
For something a little different, play with the attached free.sql script.
-Original Message-
where can i find a script to find segments which can't extend due to low of
space in tablespace .
-ak
free.sql
Description: Binary data
pu power and
> requires bandwidth.
> Correct me if I'm wrong please.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,
check?
Platform is Windows 2000, Oracle FAILSAFE.
Oracle version 9.0.1.4.0...
Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
t; select username
> 2 from dba_users
> 3 where username like '%MC%' ;
>
> Is it possible to specify the prompt that shows on
> continuation lines (or otherwise pad it out) in sql*plus?
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
extproc's that Dick was talking about
and for ease of testing upgrades than for any other pressing reason.)
Auditors are a funny breed... they want total separation even at the expense
of practicality.
April Wells
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephe
Title: Message
One possibility --
probably a slim possibility: If the remote site can hook up a console server to
the box, then you connect to the console server, and it will be like you are
right there at the console ... That's the theory
anyway.
-Original Message-From: Nelson,
angement.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
cat file
sed '' file
awk '{print}' file
while read LINE; do echo "$LINE"; done < file
> -Original Message-
> hi all ,
>
> how can I read a text file and print line by line.
>
--
Please see the official ORACLE-L FAQ: http://www.o
nit.ora
> copy of it.
>
> There is some sort of checksum going on, even though it looks like
> ASCII
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
and use grep.
>
> And if your programmers practice safe sequences, it will be
> in their code instead of the database anyway.
>
> Although if they're *really* good, it will be in a package, and
> it *will* show up in dba_source.
>
> Jared
>
>
>
easy to find those tables to use sequences but I
failed. dba_sequence don't give too much info. Is there any idea?
Thanks in advance
Mitchell
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 85
box is failing to resolve a name,
how to check if it's using a domain server and/or of the name is registered
with the server.
-
Now here's something else for you to test: The security considerations when
exporting file systems for NFS mounts.
Answer: Involves not allowing SUID fi
t)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
ould return 100.
>
> Is this possible and if yes, how ? I tried some ways but
> couldn't find any way.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San D
he official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, July 14, 2003 4:09
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
dbf and cdx files
Looks like foxpro files . Trying to open using
odbc driver .
-ak
- Original Message -
From:
Stephen
Lee
T
Are the dbf files
dbase files? If so, I have something that you might be able to use or
adapt to your purposes.
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, July 14, 2003 1:29
PMTo: Multiple recipients of list ORACLE-LSubject: dbf
and cdx files
I hav
d I/O.
> -Original Message-
>
> Separating tables from indexes is one of those mythical things.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
I forgot to say: the first listing is the tnsnames.ora on the client(s).
> -Original Message-
> From: Stephen Lee
> Sent: Wednesday, July 02, 2003 3:06 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: service name, sid ..
>
>
>
> Example us
. isn't it ( ? ) .
Can some one clarify with some examples .
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web h
st PLEASE STOP SINGING!!!"
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing li
target host or object
> does not exist
>
> Occasionally it lets me on.
>
> People at the other site tell me that they can connect ok
>
> Anyone know what might be causing the problem?
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen
You should be more environmentally conscious and pipe this through compress
prior to sending it to lpt1.
> -Original Message-
>
> dd if= of=/dev/lpt1
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat
below statement in order to
improve performance in query.
Any workaround ?
select mas.salesrep_id,sum(del.qty*del.price)-sum(del.discount)
from
sales_master mas,
sales_details del
where
mas.transaction_id =del.transaction_id
group by
mas.salesrep_id.
Thanks in advance
--
Please see the
hanks,
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
ere
mas.transaction_id =del.transaction_id
group by
mas.salesrep_id.
Thanks in advance
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
need to do sys.v_$session.
> -Original Message-
>
> E.g. Query:
>
> Select sys_context('USERENV','IP_ADDRESS') from v_$session;
>
> Return NOTHING :(
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
e a contiguous
> section of disk space. The file could be scattered across
> the file system.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.co
me||';' from
> dba_tab_privs where owner = 'BUBBA';
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 h
--
>
> Does anyone has script which can check "grant
> privilege" on a table and generate output for future
> usage?
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-50
the authors of graduate Math
> texts to come
> > up with Advanced Queuing.
>
> somehow this makes me glad i work for cheap places that don't
> use any of
> that.;-)
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL
1 - 100 of 356 matches
Mail list logo