Some simple scripts to have some fun while using Oracle Database in the SQL*Plus command line.
Who said you couldn't have fun with Oracle Database?
Note: Some messages, comments and variable names are in Brazilian Portuguese.
Set the SQLPATH environment variable to point to the scripts location or copy the scripts you want to the same folder you keep your custom scripts.
- Please, use the command
@oracle-funto display a list of commands in this package. - Scripts with colored output require a terminal that can handle ANSI escape sequences.
- If output on some scripts are missing, truncated or messed up, please, try the following:
- Adjust the terminal window dimensions (width, height)
- Adjust the terminal window font family and size
- Set a larger line size for script output on SQL*PLUS:
SET LINESIZE 1000 - Enable server output:
SET SERVEROUTPUT ON SIZE UNLIMITED - Try setting some reasonable defaults for SQL*PLUS
@banner "Hello Oracle"- Prints a message in ASCII art@bannerbg "Hello Oracle"- Prints a message in ASCII art with a big font@bannerc "Hello Oracle"- Prints a message in ASCII art with a bigger font
SQL> @banner "Hello Oracle"
_ _ _ _ ___ _
| | | | ___ | | | | ___ / _ \ _ __ __ _ ___ | | ___
| |_| | / _ \ | | | | / _ \ | | | | | '__| / _` | / __| | | / _ \
| _ | | __/ | | | | | (_) | | |_| | | | | (_| | | (__ | | | __/
|_| |_| \___| |_| |_| \___/ \___/ |_| \__,_| \___| |_| \___|
@cal_simp- Prints a simple calendar@cal_color- Prints a calendar formatted as a table@cal_tab- Prints a colored calendar
- All
chart_XXXcommands require that the label/group/category column be aliased aslbland the value/numeric column must be aliasedval. - You pass a simple one-line query as a parameter. The query should be delimited by double-quotation marks.
@chart_horiz "select 'Sample ' || lpad(rownum, 2, '0') as lbl, trunc(dbms_random.value(1, 1000)) as val from dual connect by level <= 15 order by 1"
@chart_bar "select '#' || lpad(rownum, 2, '0') as lbl, trunc(dbms_random.value(1, 1000)) as val from dual connect by level <= 15 order by 1"
@chart_3d "select '#' || lpad(rownum, 2, '0') as lbl, trunc(dbms_random.value(1, 1000)) as val from dual connect by level <= 15 order by 1"
@chart_color "select '#' || lpad(rownum, 2, '0') as lbl, trunc(dbms_random.value(1, 1000)) as val from dual connect by level <= 15 order by 1"
@chart_donut "select chr(64 + rownum) as lbl, trunc(dbms_random.value(1, 1000)) as val from dual connect by level <= 9 order by 1"
@guitar_fretboard- Prints a guitar fretboard@guitar_note A- Prints a guitar fretboard showing all positions for a given note@guitar_color A,B,C- Prints a guitar fretboard with notes in color
@ansi_colors- Print some helpful information on how to use ANSI escape sequences to have colored output on SQL scripts.@brasil- Prints the Brazilian Flag in ASCII using an SQL query.@gfx_gradient1,@gfx_gradient2,@gfx_gradient3and@gfx_misc- Prints some graphical patterns@xghand@xgh_big- Prints a small and a big ASCII art logo for the Only Truly "Agile" Methodology that is used by everyone (even by Tesla).
