Re: Deleting SQL*Menu application via sql code

In article <2un5jv$1pmn_at_source.asset.com>, dymmd_at_source.asset.com (David Robert Dymm) writes...
>I am looking for sql that will allow me to delete a SQL*Menu
>application. In this way, I can delete the application automatically
>from a script rather than having to enter Sqlmenu to do this work.
>I am using version 7.0.15 of Oracle and version 5.0.11 of SQL*Menu.
>Please e-mail the code directly to me.
>Thanks.
>
> David Dymm
>
> dymmd_at_source.asset.com
>

THE FOLLOWING IS NOT SUPPORTED BY ORACLE. Oracle does not have a supported way of doing this. We've been using it for two months and it works great.

We call it maize. :-) We call it DELETE_MENU.SQL.

======================Cut here===================================

DELETE FROM MENU_B_PRIV WHERE APPLICATION_NAME='&1';
DELETE FROM MENU_B_REF WHERE APPLICATION_NAME='&1';
DELETE FROM MENU_B_PROCEDURE WHERE APPLICATION_NAME='&1';
DELETE FROM MENU_B_APPL WHERE APPLICATION_NAME='&1';
DELETE FROM MENU_B_APPL_GRP WHERE APPLICATION_NAME='&1';
DELETE FROM MENU_B_INFO WHERE APPLICATION_NAME='&1';
DELETE FROM MENU_B_OPTION WHERE APPLICATION_NAME='&1';
DELETE FROM MENU_B_PARAM WHERE APPLICATION_NAME='&1';
DELETE FROM MENU_B_PARM_XREF WHERE APPLICATION_NAME='&1';

• Cut here ===================

To run it, say:
 SQLPLUS user/pass _at_DELETE_MENU menuname

Jeff Received on Tue Jun 28 1994 - 17:54:29 CEST