Bruno J. Araujo felclef

## ora_dblinks.sql
create or replace
  type sysuser as object (
    user_client_name varchar(100),
    user_version varchar(50),
    user_name varchar(100),
    user_password varchar(100),
    user_db_host varchar(15)
  );
/

## ora_tablespace_space_ace.sql
select
  ts.tablespace_name as "Tablespace",
  round(sum(df.bytes) / (1024*1024), 2) as "Total (MB)",
  round(sum(df.bytes) / (1024*1024) - sum(fs.bytes) / (1024*1024), 2) as "Usado (MB)",
  round(sum(fs.bytes) / (1024*1024), 2) as "Livre (MB)",
  round(sum(fs.bytes) / sum(df.bytes) * 100, 4) as "Livre (%)",
  100 - round(sum(fs.bytes) / sum(df.bytes) * 100, 4) as "Usado (%)"
from
  dba_tablespaces ts
  inner join dba_data_files df

## ora_sh_t_solver.sql
declare

  entity_count integer := 0;

  type t_ct_cur is ref cursor;
  ct_cur t_ct_cur;

  type t_codmat is table of varchar2(255);

  blk_codmat t_codmat;

## ellano_links.html
<html>
	<head>
		<style type="text/css">
			a.opt1, a.opt2
			{
				color:#AAA;
			}
			a.opt1, a.opt2, a.opt1:hover, a.opt2:hover
			{
				color:#AAA;

## within-group-prog-count.sql
-- olc: select id_quadro, user_hash from ( select iq.id_quadro, user_hash, if( @prev <> iq.id_quadro, @rownum := 1, @rownum := @rownum+1 ) as g_rank, @prev := iq.id_quadro from  r7_inscricoes_quadros iq order by id_quadro, data_cadastro ) sq where g_rank <= 4

-- the sample uses some database wich I have not luvd... yet...

select
	id_quadro,
	user_hash
from
(
	select

## felclef.zsh-theme
# hints got at http://stevelosh.com/blog/2010/02/my-extravagant-zsh-prompt/

function collapse_pwd {
    echo $(pwd | sed -e "s,^$HOME,~,")
}

function prompt_char {
    git branch >/dev/null 2>/dev/null && echo '±' && return
    hg root >/dev/null 2>/dev/null && echo '☿' && return
    # echo '○'

## felclef.zsh-theme
# hints got at http://stevelosh.com/blog/2010/02/my-extravagant-zsh-prompt/

function collapse_pwd {
    echo $(pwd | sed -e "s,^$HOME,~,")
}

function prompt_char {
    git branch >/dev/null 2>/dev/null && echo '¬±' && return
    hg root >/dev/null 2>/dev/null && echo '‚òø' && return
    # echo '‚óã'

## httpd.conf
#
# Mac OS X / Mac OS X Server
# The <IfDefine> blocks segregate server-specific directives
# and also directives that only apply when Web Sharing or
# server Web Service (as opposed to other services that need Apache) is on.
# The launchd plist sets appropriate Define parameters.
# Generally, desktop has no vhosts and server does; server has added modules,
# custom virtual hosts are only activated when Web Service is on, and
# default document root and personal web sites at ~username are only
# activated when Web Sharing is on.

## httpd-vhosts.conf
#
# Virtual Hosts
#
# If you want to maintain multiple domains/hostnames on your
# machine you can setup VirtualHost containers for them. Most configurations
# use only name-based virtual hosts so the server doesn't need to worry about
# IP addresses. This is indicated by the asterisks in the directives below.
#
# Please see the documentation at
# <URL:http://httpd.apache.org/docs/2.2/vhosts/>

## ez-install.sh
#!/bin/bash
# once know as clf-ez-install.sh
# install deb package from url
# this script was once shamelessly copy-pasted from a gTalk conversation by the awful filipekiss faget,
# who uploaded here -> https://gist.github.com/4219057 <-
# before I could ever think of do the same. So I made this tribute <3
pkg=$( echo $1 | sed -r 's/^.+\/([^\/]+\.deb)/\1/g' )
wget $1 && dpkg -i $pkg
	create or replace
	type sysuser as object (
	user_client_name varchar(100),
	user_version varchar(50),
	user_name varchar(100),
	user_password varchar(100),
	user_db_host varchar(15)
	);
	/
	select
	ts.tablespace_name as "Tablespace",
	round(sum(df.bytes) / (1024*1024), 2) as "Total (MB)",
	round(sum(df.bytes) / (10241024) - sum(fs.bytes) / (10241024), 2) as "Usado (MB)",
	round(sum(fs.bytes) / (1024*1024), 2) as "Livre (MB)",
	round(sum(fs.bytes) / sum(df.bytes) * 100, 4) as "Livre (%)",
	100 - round(sum(fs.bytes) / sum(df.bytes) * 100, 4) as "Usado (%)"
	from
	dba_tablespaces ts
	inner join dba_data_files df
	declare

	entity_count integer := 0;

	type t_ct_cur is ref cursor;
	ct_cur t_ct_cur;

	type t_codmat is table of varchar2(255);

	blk_codmat t_codmat;
	<html>
	<head>
	<style type="text/css">
	a.opt1, a.opt2
	{
	color:#AAA;
	}
	a.opt1, a.opt2, a.opt1:hover, a.opt2:hover
	{
	color:#AAA;
	-- olc: select id_quadro, user_hash from ( select iq.id_quadro, user_hash, if( @prev <> iq.id_quadro, @rownum := 1, @rownum := @rownum+1 ) as g_rank, @prev := iq.id_quadro from r7_inscricoes_quadros iq order by id_quadro, data_cadastro ) sq where g_rank <= 4

	-- the sample uses some database wich I have not luvd... yet...

	select
	id_quadro,
	user_hash
	from
	(
	select
	# hints got at http://stevelosh.com/blog/2010/02/my-extravagant-zsh-prompt/

	function collapse_pwd {
	echo $(pwd \| sed -e "s,^$HOME,~,")
	}

	function prompt_char {
	git branch >/dev/null 2>/dev/null && echo '±' && return
	hg root >/dev/null 2>/dev/null && echo '☿' && return
	# echo '○'
	#
	# Mac OS X / Mac OS X Server
	# The <IfDefine> blocks segregate server-specific directives
	# and also directives that only apply when Web Sharing or
	# server Web Service (as opposed to other services that need Apache) is on.
	# The launchd plist sets appropriate Define parameters.
	# Generally, desktop has no vhosts and server does; server has added modules,
	# custom virtual hosts are only activated when Web Service is on, and
	# default document root and personal web sites at ~username are only
	# activated when Web Sharing is on.
	#
	# Virtual Hosts
	#
	# If you want to maintain multiple domains/hostnames on your
	# machine you can setup VirtualHost containers for them. Most configurations
	# use only name-based virtual hosts so the server doesn't need to worry about
	# IP addresses. This is indicated by the asterisks in the directives below.
	#
	# Please see the documentation at
	# <URL:http://httpd.apache.org/docs/2.2/vhosts/>
	#!/bin/bash
	# once know as clf-ez-install.sh
	# install deb package from url
	# this script was once shamelessly copy-pasted from a gTalk conversation by the awful filipekiss faget,
	# who uploaded here -> https://gist.github.com/4219057 <-
	# before I could ever think of do the same. So I made this tribute <3
	pkg=$( echo $1 \| sed -r 's/^.+\/([^\/]+\.deb)/\1/g' )
	wget $1 && dpkg -i $pkg