http(s)?:\/\/([a-z-A-Z-0-9]+(\.))+([a-z-A-Z]+)(\/[a-z-A-Z-0-9]*)*(\?((\&)?(.)+=(.)+)*)?
The regex above can be tested here
http(s)?:\/\/([a-z-A-Z-0-9]+(\.))+([a-z-A-Z]+)(\/[a-z-A-Z-0-9]*)*(\?((\&)?(.)+=(.)+)*)?
The regex above can be tested here
| BEGIN | |
| FOR c IN (SELECT table_name from user_tables) | |
| LOOP | |
| EXECUTE IMMEDIATE ('DROP TABLE ' || c.table_name || ' | |
| cascade constraints PURGE'); | |
| END LOOP; | |
| END; |