Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Newbie sp_ Question
Maybe Oracle stuff is just too difficult for you.
Like "most DBAs", I trying to add SYBASE (/ms-sql) to my belt because it's a far better skill to have than Oracle.
But help me out a little,
how do you implement this in MS-SQL / SYBASE:
create function my_func (a_param in number) returns STRING
:
:
so that I could use
my_string := my_func (1);
I can't seem to find that in the spectacular TRANSACT SQL manual.
"Lee J." <ljeznach_at_csi.com> wrote in message
news:3h7z5.10237$dZ2.3847165_at_news3.rdc1.on.home.com...
> REF CURSOR doesn't tell me anything and this is the last thing that I
would
> consider as a solution to my problem.
> There are some standards on the market today.
> If Oracle develop new tech then they should at least make some remarks in
> their publication about
> the differences etc. - most of the DBAs have experience with SYBASE and we
> learn new tech in comparison to that what we have already learned -
whether
> you like it or not. They simple force people to learn everything from the
> scratch, which will discourage many people from using their software.
>
> Thanks anyway.
>
> P.S. is temporary table feature added to new 8i v. the result of their
> (Oracle) bright technology?
>
>
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:969715079.8598.1.pluto.d4ee154e_at_news.demon.nl...
> > I'm amazed by this.
> > It definitely is covered under REF CURSOR.
> > Also you could look at http://osi.oracle.com/~tkyte/Resultsets.
> >
> > IMO, (as response to you more or less condescending remarks about
> > documentation), I don't understand why sqlserver types use stored
procedures
> > for even very simple selects. That is definitely unnecessary.
> > In short, you should try to learn the *oracle perspective* and put aside
> > your sqlserver or sybase habits. Otherwise you will end up with code
that
> > from the Oracle perspective is very inefficient.
> >
> > Oracle is not sqlserver nor sybase, it's much better than that.
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > "Lee J." <ljeznach_at_csi.com> wrote in message
> > news:jMPy5.5498$dZ2.1382333_at_news3.rdc1.on.home.com...
> > > I have an Oracle 8i Reference and PL/SQL Programming books (ORACLE
Press)
> > > and I couldn't find anything that would deal with stored procedures
that
> > > return a sample record set.
> > > Very basic problem from MS SQL or SYBASE prospective, which is not
covered
> > > by any of the books, mentioned above.
> > > If any of you guys know a good book dealing with sp properly then I
very
> > > appreciate your email.
> > > Sample code is very welcome.
> > > Lee.
> > >
> > >
> > >
> >
> >
>
>
Received on Mon Sep 25 2000 - 17:35:30 CDT