leovoel
/ basic_bot.py
Last active
January 25, 2024 04:19
discord.py's basic_bot.py converted to use "cogs".
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from discord.ext import commands | |
| description = '''An example bot to showcase the discord.ext.commands extension | |
| module. | |
| There are a number of utility commands being showcased here.''' | |
| # this specifies what extensions to load when the bot starts up | |
| startup_extensions = ["members", "rng"] |
luzfcb
/ oracle_database_schema_tables_views.sql
Last active
March 13, 2025 05:54
sql for introspection information about schema, tables, views and other for various database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- basic doc: http://docs.oracle.com/cd/B19306_01/network.102/b14266/admusers.htm#i1008832 | |
| -- get all database schema's name from Oracle Database | |
| -- http://www.orafaq.com/wiki/List_of_default_database_users | |
| -- http://www.adp-gmbh.ch/ora/misc/known_schemas.html | |
| SELECT DISTINCT OWNER | |
| FROM ALL_OBJECTS | |
| WHERE OWNER NOT IN ('APEX_030200', 'CTXSYS', 'DBSNMP', 'EXFSYS', | |
| 'MDSYS', 'OLAPSYS', 'ORDDATA', 'ORDPLUGINS', | |
| 'ORDSYS', 'PUBLIC', 'SYS', 'SYSTEM', 'WMSYS', |