can someone show some oracle sql stmt, I want to compare that with MYSQL in linux rh 9.0
developer
linux?
thanks!
DJ
"developer" <deve...@earth.com> wrote in message
news:bh3u2u$sr...@imsp212.netvigator.com...
select * from emp;
happy now?
SQl is SQL is SQL, which ever db you use (in most cases), its a standard
Hans Forbrich
Look at http://otn.oracle.com/sample_code/content.html for some samples.
Anything that starts with 'SELECT', 'INSERT', 'UPDATE' or 'DELETE' is a SQL
statement. While you are there, yo might want to search for the DDL on 'EMP,
DEPT' and possibly check for 'schema definitions for SCOTT & HR' to help
understand the table definitions.
<soapbox>
Just be aware, the way many developer work:
- in a MySQL or PostgreSQL environment you typically a) write external programs
to interact with the database.
- in Oracle you can: a) write external programs to interact with the database;
b) write 'internal' programs to work inside the database space; c) have the
external programs in 'a)' leverage these extension; d) extend the database by
leveraging these internal programs; e) have external programs leverage the
extended database; and f) have the extended database interact with external
programs on it's own.
So far I have not found how to easily replicate the extra Oracle capabilities
in MySQL or PostgrSQL. AFAICT most of the others sem to stop at 'c)'.
</soapbox>
developer
Hans Forbrich <forb...@telusplanet.net> wrote in message
news:3F359E32...@telusplanet.net...
normally I write php and use dbtools to interact with mysql table. I have
not use oracle before.
q1. is there any version of oracle suitable for installation in rh 9.0 ( the
server is co-location) and I have server with similar capacity at home for
testing.
q2. what is the external language for interact? ( the external language in
web-based is php) then apache to do the web -based programming.
( my first lanaguage is not english)
developer
>
Hans Forbrich
>
> normally I write php and use dbtools to interact with mysql table. I have
> not use oracle before.
>
> q1. is there any version of oracle suitable for installation in rh 9.0 ( the
> server is co-location) and I have server with similar capacity at home for
> testing.
You can download the latest version of Oracle free-of-charge from
http://otn.oracle.com. I strongly encourage using the latest version as the
older ones will all be out-of-full-support soon.
The latest version is Oracle9i Release 2. It is suitable for rh AS-2.1 and
other certified combinations (as well as Windows, every unix that matters,
etc.). People have tried to install on rh9 and there seem to be some install
headaches - suggest you web-search on 'oracle install red hat'
>
> q2. what is the external language for interact? ( the external language in
> web-based is php) then apache to do the web -based programming.
I suspect you are in for a bit of a learning curve. Please look at the sample
code and the documentation areas of http://otn.oracle.com. I strongly encourage
you to read chapters 1-3 of the Oracle Concepts Manual found in the
documentation section (http://otn.oracle.com >> documentation >> database >>
version >> view >> list all books >> Concepts)
Please note that the database comes with a built-in Apache web server and that
server has a number of mods that are very useful to working with Oracle. Also
note these mods are not easily moved to other versions of Apache.
There are a number of FAQs around - web-search ORACLE FAQ and check them out.
Norman Dunbar
>> - in Oracle you can: a) write external programs to interact with the
database;
>> b) write 'internal' programs to work inside the database space; c)
have the
>> external programs in 'a)' leverage these extension; d) extend the
database by
>> leveraging these internal programs; e) have external programs
leverage the
>> extended database; and f) have the extended database interact with
external
>> programs on it's own.
<BEGIN RANT>
Stop using 'leverage' - I'd rather set COMPRESS=Y on an exp tahn use
leverage as a verb in a sentence !!!!! :o)
The word is 'use' - why extend a three letter word just for the sake of
it !
That makes me soooooooo angry.
<END RANT>
Right having said that, I'm off round Billy's place for a coffeee :o)
Cheers,
Norm.
quarkman
wrote:
Has he architected you a nice cup to drink it from??
Or will you be leveraging the cheap china?
~QM
Norman Dunbar
(up, down or strange by the way ?)
>> Has he architected you a nice cup to drink it from??
>> Or will you be leveraging the cheap china?
In the words of 'the brigadier' from Monty Python :
"Stop it, stop it now"
Cheers,
Norm.
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
Noons
news:E2F6A70FE45242488C86...@lnewton.leeds.lfs.co.uk...
> (up, down or strange by the way ?)
charmed.
>
> >> Has he architected you a nice cup to drink it from??
>
> >> Or will you be leveraging the cheap china?
>
> In the words of 'the brigadier' from Monty Python :
> "Stop it, stop it now"
I feel so leveraged...
--
Cheers
Nuno Souto
wizo...@yahoo.com.au.nospam
Norman Dunbar
:o)
Cheers,
Norm.
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
Paul Drake
"Exploit" is far better than "leverage" or "utilize".
It makes it seem like something or someone is being taken advantage
of. ;)
I think that the game Scrabble (TM) should have more of the letter
"Z", just to make things a bit more interesting.
Paul
Hans Forbrich
>
> <BEGIN RANT>
> Stop using 'leverage' - I'd rather set COMPRESS=Y on an exp tahn use
> leverage as a verb in a sentence !!!!! :o)
> The word is 'use' - why extend a three letter word just for the sake of
> it !
> That makes me soooooooo angry.
> <END RANT>
Apologies, cap'n. I'll try to exploit 'em in the future.
Hans Forbrich
> <BEGIN RANT>
> Stop using 'leverage' - I'd rather set COMPRESS=Y on an exp tahn use
> leverage as a verb in a sentence !!!!! :o)
> The word is 'use' - why extend a three letter word just for the sake of
> it !
> That makes me soooooooo angry.
> <END RANT>
>
Apologies, cap'n. Those three letter words ... I'll try to exploit 'em
iffn I visit again. That certainly would be better'n having you edge
t'wards four letter words.
Niall Litchfield
news:E2F6A70FE45242488C86...@lnewton.leeds.lfs.co.uk...
> :o)
This I hate to relate,
but I have to tell thee,
You've forgotten three.
up,down,top,bottom,strange and charmed are the 6 'flavours' of quark.There
are on the other hand only 3 colours for quarks but these *do* have
anti-colours for the anti-quarks.
Makes exploiting the word leverage where the word use would be better
utilized seem marvellously clear.
errm, I'll get me coat.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
ctc...@hotmail.com
select smp.id,
corr(
(select val from a where a.expID=exp.id and a.smpID=2),
(select val from a where a.expID=exp.id and a.smpID=smp.id)
)
from
(select distinct expID as id from a) exp,
(select distinct smpID as id from a) smp
group by smp.id
You're welcome.
Xho
--
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service New Rate! $9.95/Month 50GB
quarkman
wrote:
> Hi Quarkman,
>
> (up, down or strange by the way ?)
Charmed, actually!
Next you'll be talking about my bottom.
Uggggh.
:-)
>
>>> Has he architected you a nice cup to drink it from??
>
>>> Or will you be leveraging the cheap china?
>
> In the words of 'the brigadier' from Monty Python :
> "Stop it, stop it now"
I agree. This is just getting silly.
~QM
quarkman
I feel a gluon coming on.
Funny thing about quarks. Named after James Joyce's line in Ulysses, "A
quark, a quark/For Muster Mark" (and hence "quark" rhymes with "Mark") they
nevertheless should be pronounced as 'qwarwks', because Murray Gell-Mann
who invented them decided he knew better than James Joyce.
It's a bit like "Lye-nux" versus "Lin-ucks", I suppose.
Me? I'm a 'qwahrk' man, and hate Lyenux. I make my own choices.
~QM
Keld Nielsen
"quarkman" <quar...@myrealbox.com> wrote in message
news:oprtrijz0tzkogxn@haydn...
Great to have you back.
Nuno Souto
>
Don't get me started on Higgins boson.
Which caused Eliza Doolitle to burst into
raucuous singing: "Just you wait, Henry Higgins!"
<donning the anti-muons>
>
> ~QM
you got mail at yahoo, dude.
Cheers
Nuno Souto
wizo...@yahoo.com.au.nospam
quarkman
Ah. I'd forgotten that. I shall check immediately.
Cheers
HJR
Norman Dunbar
three, four - who cares.
I always expected the 'Large Hadron Collider' to be mis-spelt in a
science mag one day :o)
Conjurs up a horrid picture though !!!
Cheers,
Norm.
PS. Stick with being a DBA, the poetry isn't all that great !
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Niall Litchfield [mailto:n-litc...@audit-commission.gov.uk]
Posted At: Monday, August 11, 2003 4:07 PM
Posted To: server
Conversation: can someone show some oracle sql stmt, I want to compare
that with MYSQL in linux rh 9.0
Norman Dunbar
Cheers,
Norm.
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Hans Forbrich [mailto:forb...@telusplanet.net]
Posted At: Monday, August 11, 2003 4:06 PM
Posted To: server
Conversation: can someone show some oracle sql stmt, I want to compare
that with MYSQL in linux rh 9.0
Norman Dunbar
wasn't it the Higgs Boson and not Mrs Higgin's Bosom ?
Cheers,
Norm.
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: wizo...@yahoo.com.au (Nuno Souto)
[mailto:wizo...@yahoo.com.au]
Posted At: Tuesday, August 12, 2003 3:35 AM
Posted To: server
Conversation: can someone show some oracle sql stmt, I want to compare
that with MYSQL in linux rh 9.0
Subject: Re: OT particle physics and english, was something about redhat
etc
Noons
news:E2F6A70FE45242488C86...@lnewton.leeds.lfs.co.uk...
> wasn't it the Higgs Boson and not Mrs Higgin's Bosom ?
>
I always thought there was something
suss about those "H"s that blew off candles:
a normal, proper person would have set the house
on fire after a coupla gins!
And don't get me started on the rain in Spain
that falls mainly on the plane: someone was
low-flying around the sherry cabinet!
(What the heck was this about? I've got all
the hadrons spinning the wrong way...
Pass the coffee, Billy!
舌
Niall Litchfield
news:E2F6A70FE45242488C86...@lnewton.leeds.lfs.co.uk...
>
> PS. Stick with being a DBA, the poetry isn't all that great !
You should see the DBAing :(
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Billy Verreynne
> Pass the coffee, Billy!
Make your own coffee dammit - you're not getting mine! [mad laughter]
--
Billy
Norman Dunbar
ah well, mine terminates on Friday this week. I'm no longer required
here :o(
B*gg*r !
Cheers,
Norm.
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Niall Litchfield [mailto:niall.li...@dial.pipex.com]
Posted At: Tuesday, August 12, 2003 10:50 PM
Posted To: server
Conversation: can someone show some oracle sql stmt, I want to compare
that with MYSQL in linux rh 9.0
Subject: Re: can someone show some oracle sql stmt, I want to compare
that with MYSQL in linux rh 9.0
Niall Litchfield
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Norman Dunbar
I'm sure someone somewhere must want a half decent DBA - don't they ?
My wife has a list of jobs as long as both my arms - most of which
involve stuiff I don't like - gardening, painting & decorating, ironing,
cooking, shopping .......
I can always write a book I suppose :o)
Cheers,
Norm.
PS. I'll still be lurking around somewhere.
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Niall Litchfield [mailto:n-litc...@audit-commission.gov.uk]
Posted At: Wednesday, August 13, 2003 12:52 PM
Posted To: server
Conversation: can someone show some oracle sql stmt, I want to compare
that with MYSQL in linux rh 9.0
Subject: Re: can someone show some oracle sql stmt, I want to compare
that with MYSQL in linux rh 9.0
Noons
and don't let the wife lure you into doing
all those yourself! ;)
Hope you're back into it soon.
--
Cheers
Nuno Souto
wizo...@yahoo.com.au.nospam
news:E2F6A70FE45242488C86...@lnewton.leeds.lfs.co.uk...
>
Norman Dunbar
I'll be checking this list almost every morning - when she's off to work
and I have a quiet hour or two to myself.
I have a few (lot of) applications on the go at the moment - just
waiting to hear is the worst bit.
Cheers,
Norm.
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Noons [mailto:wizo...@yahoo.com.au]
Posted At: Wednesday, August 13, 2003 2:08 PM
Posted To: server
Conversation: can someone show some oracle sql stmt, I want to compare
that with MYSQL in linux rh 9.0
Subject: Re: can someone show some oracle sql stmt, I want to compare
that with MYSQL in linux rh 9.0
Brian Peasland
Cheers,
Brian
Norman Dunbar wrote:
>
> Thanks Nuno.
>
> I'll be checking this list almost every morning - when she's off to work
> and I have a quiet hour or two to myself.
> I have a few (lot of) applications on the go at the moment - just
> waiting to hear is the worst bit.
>
> Cheers,
> Norm.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman...@LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
> -----Original Message-----
> From: Noons [mailto:wizo...@yahoo.com.au]
> Posted At: Wednesday, August 13, 2003 2:08 PM
> Posted To: server
> Conversation: can someone show some oracle sql stmt, I want to compare
> that with MYSQL in linux rh 9.0
> Subject: Re: can someone show some oracle sql stmt, I want to compare
> that with MYSQL in linux rh 9.0
>
> yes please.
> and don't let the wife lure you into doing
> all those yourself! ;)
> Hope you're back into it soon.
> --
> Cheers
> Nuno Souto
> wizo...@yahoo.com.au.nospam
> "Norman Dunbar" <Norman...@lfs.co.uk> wrote in message
> news:E2F6A70FE45242488C86...@lnewton.leeds.lfs.co.uk...
> >
> > PS. I'll still be lurking around somewhere.
> >
--
===================================================================
Brian Peasland
dba@remove_spam.peasland.com
Remove the "remove_spam." from the email address to email me.
"I can give it to you cheap, quick, and good. Now pick two out of
the three"
Noons
<G>
--
Cheers
Nuno Souto
wizo...@yahoo.com.au.nospam
"Brian Peasland" <dba@remove_spam.peasland.com> wrote in message news:3F3A4F5D.39504573@remove_spam.peasland.com...