Re: Newbie sp_ Question

u've got me men!

"Steve McDaniels" <steve.mcdaniels_at_sierra.com> wrote in message news:8qojvh$mf1$1_at_spiney.sierra.com...
> 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 Wed Sep 27 2000 - 14:36:24 CDT