/* -- blocklists --*/
ul.blockList {
	list-style-type: none;
	margin: 20px 0;
}

ul.blockList li {
	margin-bottom: 20px
}
ul.blockList li h3,
ul.blockList li p.meta {
	display: inline;
	margin: 0;
	padding: 0;
}
ul.blockList li p.meta {
	font-size: 0.8em;
	margin-left: 1em;
	margin-top: 0;
}
ul.blockList li blockquote {
	border: none;
	margin: 0.5em 0 0 0;
	padding-left: 0;
	font-style: normal;
}

select * from User_Procedures; 

select * from DBA_Procedures;

select * from User_Source where name = 'stored_proc'; 

select * from DBA_Source where name = 'stored_proc';

1) Open a terminal.

2) cd into the directory where the dmg is located

3) Type this in (where newfile is the name of the iso you want, and yourfilename.dmg is the dmg)

hdiutil makehybrid -iso -o newfile.iso yourfilename.dmg

CREATE FUNCTION datediff (diffType Character Varying(15), date1 Date, date2 Date) RETURNS integer AS $$
DECLARE
	YEAR_CONST Character Varying(15) := 'year';
	MONTH_CONST Character Varying(15) := 'month';
	DAY_CONST Character Varying(15) := 'day';

	diffInInterval Interval;
	diffInDoublePrecision Double Precision := 0;
	diffInInteger Integer := 0;
	dateTemp Date;
BEGIN
	
	diffInInterval := age(date2, date1);

	IF lower($1) = lower(YEAR_CONST) THEN
		diffInDoublePrecision := date_part('Year', diffInInterval);
	ELSEIF lower($1) = lower(MONTH_CONST) THEN
		diffInDoublePrecision := (date_part('Year', diffInInterval) * 12) + date_part('Month', diffInInterval);
	ELSEIF lower($1) = lower(DAY_CONST) THEN
		diffInDoublePrecision := endDate - startDate;
	END IF;

	diffInInteger := CAST(diffInDoublePrecision as Integer);
	RETURN diffInInteger;
END;
$$ LANGUAGE plpgsql;

/**
 * Shorten a string
 **/
function format_shorten_string($string, $length = 15, $count_addition = 3) {
  if (drupal_strlen($string) > $length) {
    $out = theme('shorten_string', drupal_substr($string, 0, ($length - $count_addition)), $string, $count_addition);
  }
  else {
    $out = $string;
  }

  return $out;
}

/**
 * Function to theme the read more links
 * @ingroup themeable
 * @param $short_string The shortened string
 * @param $full_string The unshortened string, for display in the tooltip
 * @param $count_addition The amount of charanters that the calling function wants to be added. Defaults to three. Optional.
 */
function theme_shorten_string($short_string, $full_string, $count_addition = 3) {
  while ($i < $count_addition) {
    $i++;
    $addition .= '.';
  }

  return '<span title="'. $full_string .'">'. $short_string . $addition .'</span>';
}

function require_once_dir( $path ){
	$dir = dir($path);
	while(($file = $dir->read()) !== false)
		if( is_file($path .'/'. $file) and preg_match('/^(.+)\.php$/i', $file) )
			require_once($path .'/'. $file);		
	$dir->close();
}
#Example
require_once_dir( 'lib/db' );
require_once_dir( 'lib/email' );

extern FILE *yyin;

main() {
	do {
		yyparse();
	} while(!feof(yyin));
}

yyerror(s)
char *s;
{
	fprintf(stderr, "%sn", s);
}

#Example:
get_date_spanish(time(), true, 'month'); # return Enero
get_date_spanish(time(), true, 'month_mini'); # return ENE
get_date_spanish(time(), true, 'Y'); # return 2007
get_date_spanish(time());#return 06 de septiempre, 12:31 hs



#Power by nicolaspar 2007 - especific proyect
function get_date_spanish( $time, $part = false, $formatDate = '' ){
    #Declare n compatible arrays
    $month = array("","enero", "febrero", "marzo", "abril", "mayo", "junio", "julio", "agosto", "septiempre", "diciembre");#n
    $month_execute = "n"; #format for array month

    $month_mini = array("","ENE", "FEB", "MAR", "ABR", "MAY", "JUN", "JUL", "AGO", "SEP", "DIC");#n
    $month_mini_execute = "n"; #format for array month

    $day = array("domingo","lunes","martes","miércoles","jueves","viernes","sábado"); #w
    $day_execute = "w";
    
    $day_mini = array("DOM","LUN","MAR","MIE","JUE","VIE","SAB"); #w
    $day_mini_execute = "w";

/*
Other examples:
    Whether it's a leap year
    $leapyear = array("Este año febrero tendrá 28 días"."Si, estamos en un año bisiesto, un día más para trabajar!"); #l
     $leapyear_execute = "L";
*/

    #Content array exception print "HOY", position content the name array. Duplicate value and key for optimization in comparative
    $print_hoy = array("month"=>"month", "month_mini"=>"month_mini");

    if( $part === false ){
        return date("d", $time) . " de " . $month[date("n",$time)] . ", ". date("H:i",$time) ." hs";
    }elseif( $part === true ){
        if( ! empty( $print_hoy[$formatDate] ) && date("d-m-Y", $time ) == date("d-m-Y") ) return "HOY"; #Exception HOY
        if( ! empty( ${$formatDate} ) && !empty( ${$formatDate}[date(${$formatDate.'_execute'},$time)] ) ) return ${$formatDate}[date(${$formatDate.'_execute'},$time)];
        else return date($formatDate, $time);
    }else{
        return date("d-m-Y H:i", $time);
    }
}

require 'unicode'

# Normalizes token text to lower case.
class UnicodeLowerCaseFilter
  def initialize(token_stream)
    @input = token_stream
  end
  
  def text=(text)
    @input.text = text   
  end
  
  def next()
    t = @input.next()
    
    if (t == nil)
      return nil
    end
    
    t.text = Unicode.downcase(t.text)
    return t
  end
end

class VietnameseAnalyzer < Ferret::Analysis::Analyzer
  include Ferret::Analysis
  
  # Standard Character mappings to remove all special characters
  # so only default ASCII characters get indexed
  CHARACTER_MAPPINGS = {
    ['á','à','ạ','ả','ã','ă','ắ','ằ','ặ','ẳ','ẵ','â','ấ','ầ','ậ','ẩ','ẫ'] => 'a',
    ['đ'] => 'd',
    ['é','è','ẹ','ẻ','ẽ','ê','ế','ề','ệ','ể','ễ'] => 'e',
    ['í','ì','ị','ỉ','ĩ'] => 'i',
    ['ó','ò','ọ','ủ','õ','ơ','ớ','ờ','ợ','ở','ỡ','ô','ố','ồ','ộ','ổ','ỗ'] => 'o',
    ['ú','ù','ụ','ů','ũ','ư','ứ','ừ','ự','ử','ữ'] => 'u',
    ['ý','ỳ','ỵ','ỷ','ỹ'] => 'y',
  } unless defined?(CHARACTER_MAPPINGS)
  
  def token_stream(field, str)
    ts = StandardTokenizer.new(str)
    ts = UnicodeLowerCaseFilter.new(ts)
    ts = MappingFilter.new(ts, CHARACTER_MAPPINGS)
  end
end

/*
* Subtracting months 
*/
update employee set dateOfBirth = dateOfBirth  - interval '1 months'

/*
* Adding months 
*/

update employee set dateOfBirth = dateOfBirth  + interval '1 months'
/*
* You can use one of the following intervals
*--------------------------------------------
* microseconds
* milliseconds
* second
* minute
* hour
* day
* week
* month
* quarter
* year
* decade
* century
* millennium
*/