Skip to content

Instantly share code, notes, and snippets.

View reisdev's full-sized avatar
📱
Creating amazing iOS apps

Matheus dos Reis de Jesus reisdev

📱
Creating amazing iOS apps
View GitHub Profile
@reisdev
reisdev / url_regex.md
Last active October 1, 2019 19:20
Regular Expression to match URL's

Regular Expression to match URL's

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

Step by Step

@reisdev
reisdev / drop_all_tables_oracle.sql
Last active October 1, 2019 12:32
Drops All Tables for Oracle DB PL/SQL
BEGIN
FOR c IN (SELECT table_name from user_tables)
LOOP
EXECUTE IMMEDIATE ('DROP TABLE ' || c.table_name || '
cascade constraints PURGE');
END LOOP;
END;