Re: [Squirrel-sql-users] The stored procedures

On Oracle, you can get all your source code from a system view that filte=
rs
for each user his sources:

select * from user_source;

Where you can filter with where clauses by TYPE (FUNCTION, PROCEDURE,
PACKAGE, ...) or NAME.

You cannot edit this code with update querys, but.

Dani.

----- Original Message -----=20
From: "Colin Bell" <Col...@as...>
To: "'aj...@wo...'" <cz0...@ti...>;
<squ...@li...>
Sent: Friday, August 08, 2003 5:24 AM
Subject: RE: [Squirrel-sql-users] The stored procedures


> To create a stored procedure in SQuirreL means executing a CREATE
PROCEDURE
> SQL statement. Something like
>
> CREATE OR REPLACE PROCEDURE PROC01
> AS
> SELECT * FROM TAB01;
>
> Consult the documentation that came with your SQL server for more
> information.
>
> To retrieve the source for your stored procedure is a little trickier.
There
> is no vendor-neutral way using JDBC to retrieve the source for a stored
> procedure. Instead you'll have to consult the documentation that came w=
ith
> your SQL server to see how to do this. Usually its stored in a table in
your
> system database.
>
> Col
>
> > -----Original Message-----
> > From: aj...@wo... [mailto:cz0...@ti...]
> > Sent: Thursday, 7 August 2003 17:07
> > To: squ...@li...
> > Subject: [Squirrel-sql-users] The stored procedures
> >
> >
> > Please can someone tell me how I can create and edit the
> > stored procedures
> > in Squirrel? Thanks.
> >
> >
> > Betty
> >
> >
> > ___________________________________________________________________
> > Nakreslete si svoji mapu a vyhrajte ceny z letn=ED kolekce!
> > Soutezte s MapClubem na http://mapy.tiscali.cz
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email sponsored by: Free pre-built ASP.NET sites includin=
g
> > Data Reports, E-commerce, Portals, and Forums are available now.
> > Download today and enter to win an XBOX or Visual Studio .NET.
> > http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet
> > _072303_01/01
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
>
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/=
01
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>