Re: [Newbie] Oracle

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 27 May 2005 13:29:21 -0700
Message-ID: <1117225501.901982@yasure>

Mark Bole wrote:
> Ed Prochak wrote:
>

>> Mark Bole wrote:

>
>

>>> HansF wrote:
>>>
>>>> On Thu, 26 May 2005 14:25:43 -0700, DJP interested us by writing:
>>>>
>>>>> I had a n00b question about Oracle.

>
> [...]
>

>>
>> They should first read the concepts manual. Kind of like freshman 
>> calculus, if they make it thru that, they might just be worthwhile 
>> after more years of training.
>>
>> (Me? I'm just a hopefully competent programmer that is always learning 
>> something new in ORACLE.)
>>

>
> Well put, better than what I said.
>
> (In regard to HansF, I was trying to gently chide him on his false
> modesty; I think the quality of his postings here has shown him to be
> quite a bit more than "barely competent".)
>
> Chapter 1 of the 1978 Kernighan/Ritchie book on C programming introduced
> me to a great concept -- the "hello world" program, which is now the de
> facto first exercise for learning almost any programming language.
>
> What I would like to see is the same approach used for persons such as
> the OP, the equivalent of a "hello world" for Oracle:
>
> "Here's the Oracle download site, here's the online documentation, when
> you can successfully demonstrate the on-line commands for determining
> what tables are in the SCOTT schema and what they contain, then we'll
> talk some more..."
>
> How this exercise is handled will tell you a lot about whether it's
> worthwhile investing more time in helping the individual.
>
> -Mark Bole

CREATE OR REPLACE FUNCTION hello RETURN VARCHAR2 IS

BEGIN
   RETURN 'Hello oracle.world';
END hello;
/

SELECT hello FROM dual;

How about the stored procedure versions? You get your choice of an OUT or IN OUT? ;-)

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Fri May 27 2005 - 15:29:21 CDT