|
From: Dani H. <dhe...@pi...> - 2003-08-23 01:16:51
|
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 > > |
