Rem Copyright (c) 2009 ArKZoYd. All rights reserved.
Rem 
Rem $Header: arkzoyd_sqlcode.sql v0.13 gguillou Exp $
Rem
Rem  Name
Rem    arkzoyd_sqlcode.sql
Rem
Rem  Description
Rem    Package that proposes functions and procedures to parse and 
Rem    manage SQL Code.
Rem
Rem  Notes
Rem    Very limited set of features for now:
Rem         - remove_comments take a SQL command and remove the 
Rem           comments from it.
Rem         - get_renamed_tables take a "rename" command and
Rem           returns the old and new name of the object to
Rem           rename.
Rem
Rem  Known issues:
Rem      remove_comments does not Manage Q-Quote String Pattern
Rem
Rem  History (MM/DD/YY)  
Rem     gguillou   03/29/09  - Creation
Rem
Rem

create or replace package arkzoyd_sqlcode is
   type ddl_rename_output_t
        is record (old_table_name varchar2(40),
                   new_table_name varchar2(40));
                   
   function remove_comments(sqltext in clob) return clob;
   function get_renamed_tables(sqltext in clob) return ddl_rename_output_t;
end;

/

create or replace package body arkzoyd_sqlcode wrapped 
a000000
369
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
b
2b9e b16
r18PXzQjqr0B6RkPFzpwz6fL0CEwg82jeV6G3y+5Fz+VGRAtEEbINuiCLuz/V/Th0UrNA40d
g/YAPlPdjvH2fBAT5M7yP/dsk592U5hhgoGmUopMzQWMVY1GF0pyR7Y277/AvW2Blqo7+TTL
LKrtnaNMgHBEEhKmqRDHX+Zdde/9Ludj9u/rKSiw6KQONeYtnOSBz79fG8csNam4dbgpPuqS
bBcqfd1GP0bcVgcZWmaShEH2Zz7Igj45pFolCaGwhW7KLBlY+c530hJiuMG0EwsEBblaqPPY
JpEEIuk62sAuYAPKWQcRt5pQYXYa+EGt+jYNStrUyYyBDdcbY2U5iII9PexlDa2N/gkkLsH/
BLriHSLsvrtpV58Xgl2PZygZgwRMcEtuWfYs7r5PP/pWDoznLM4lhKLLqL1WwRTSWV/3uzao
QBVv4H5n1KuY+Tb1sYTLY3S47lZzhREIXWiNKGjIaIBJfRWZWC+ik57UlsR/ZVLwiDvKv8pd
pgqo6bkh9XKp98JNbD+gahtB246Wj9z9U1VYDpkETBWFwFm1ZaB2WUfSx1jFUpR7XVYmD5sf
AqpFkNwHMWUywaKlRswmY4bHeM/av3+eDqXGZzfR0BaECPI7tg6ih0b6ifEUoA5mpgbpMSl0
+/RVBOcGnZDaF44/26jDHSKmNMm6z9fQZrI+MW4oxc/uhSWhWEf6kSNfOUQLi0rxoXqhJ8Bs
+trhwa1Ex1gaJIpdwyvdZ5bUSq5Sl9AhuifrsENcz8SjJ9KTDLqAKAqaUaUngaUvYoaAO3Uf
PkKYVTnxQd2jPzAYDSunJl8hZFz0CTWTu6t50USBB4P2eUsCQdk18H2NoREf3H+ZKgZWJS8K
X7qIJZEUwyXFQEGKKsCyYXzjSPbdaUPEi9hsxipwVdfH7UwAvxQSuaUu7fKAwsEZdkgBTZto
7vh4LkIM4hKaZ9G72opyzB2SpHG/Vpi5jw6HjAv6MoZeT8MbC/2ujf6r4wq4h4Sv2r67VLgP
8kGzrkwsVoNhJgQFXtkouJg7zxcT+zkFMu0AK2+hC+W6auKoKhrKH7X5aSboXO5yNX+OZvdk
pFTkvDHn2/pjeVqG+H466QduEIwcTWRsoSTcGHkSiu+271/JQR63g00fQ1NEIRZiSnegeYxx
YfQQ3jqrhZ89Pt0fFVeSpkxXqcqj2GRIONNVmgBolbOjjEZiLtX8Zh69kmrRhJwvuZLaSiRO
5UPIJpW6YjkKlVd0s3r1ODhXScgGkmE4B0knI/7Ms0H7QZVWddAU+JePt9H9rUnOw2Tm75wV
X83WlLkKyqTf915BmCaGRrw0JKAaL71O4c4mrxxSfBqdGWYbU7rxOlMI9xfrv/JzFLOsYTtW
umGg/gzXFnKfskdX6d+fhEVoFqaRjlogNgHgaaqF4Eysmzx9Z4KGU2Z3cFnJ1z+k8fx6FkU1
nvM6iJpkHLuneJiA9Hhdk8xmy5psYPXF8vJ0Ep4hH/aALbjosTom6TwXRYdpiHB7Maz3EdIY
XaQp+2rbvRWTjp5xBEDM/6ulm9v3cVVA9Vjl+EzvKSfV6M6ArDpJ5nsXYNDYwr4Mr7qsUv0b
CrBPuYzWxK4KV6xEk1us4fYlfGPJjF/Kax6WBEN+55dGdbfNPn7MVcxQkYNlBN9OKh75ji2W
gEy9kS29t8M+svwTK6nm605+9n4lTOMvOrweHlvt3LDred41NOiTAWFTtUINP+PiKozC+gnG
tmJkoQQ19uxl4xXXa/p5R41W2d+tkmqKyZ3V1FiaDrOCq4zXKoSKYT4Pwh7xm8zOu4kpvqHJ
dlrs8oeksP0Wj/dGrsTqZyzpeL/ZhAbehAVFlugpGuZdLbQGHYQ9p22MpLkh7MnDj4ACNj6O
oeDYfn1DPL6AoxfSgDSHcZW+ahwq8nVh/2y9fl0fluF9X4YA958K9a6zUn9Xx+aX1o0yRQFB
n7owKy1KtjRIUvn56KXP3p9ayOyWA0y+fXuAt6RiIAa64Rb7fC5rzPCZh2rWq36la8op9DZx
46lxtwNDK2rm1a4LDQnwxie91+XhGQGiCtvqynEqBNfx6Xy8K41Gz7XDy/kXshDwh/hVRaWq
JbR4d/zpCHIGXL5hJFH2+CizPVUGHNTEmexNRpUQl5W7Fl15AMGePGRq3FYPzUezAGXld8K9
4xdFT/lDkt46dYBoXQ8AlfrRnVFS+twUbXiKbl57R3bjgJAUdWvQdsdg/CfAz14Qg61YtIje
n/nsdpKRm722jWeYYRiMHxci/T4ocdsftGFa1P/K6qd1t/fCyO2sJfp4evigQxsYajKgcchB
Yl8fGmMZ7t1jYFQBQlY0Kw8cmXue30Pu0qfvLFw9ye1SRS8GiWtnlqvFo3zBFIwv06fawPLf
SG1sC9GEiGRAo6tjJUXY5w5TCY2nssOfNUVsYvihfWeuRVKbqZGGkCrJI+fZ72MOnF/Roz4/
kd+EDVVcmNDP55218z9QnmLOezU2d97c6iVkDewNw2NHsaN/XxbCoINoIgS41vTNEELe+ju0
/HtTVu2gTNrZnzie3UyGVBdUlEs1DZ35cRqY/rGp3qySdHAXwvkDMKq9PDCRsh4O6edPTxQt
Cj7+OyfdNuUQKao2XzCBZo7x35+MKtZmh3NPxyQP/6SFzqd4lSe/sRg48DeSNukwUCHWsL1o
NcG1QTaH5swD3oainaphdv+REDQ6auYigffCYyrOfhWBHqxexWEJqFUMzSo60CqymmBnsYZt
QypoABXAlGrhm2ED5vh+LrcO9PFQsUMNL6iwllm1itr+wNMbYS5Qj22d++VGZmQ=

/