-
NGS Consulting Oracle PL/SQL Injection
Attacker-defined function. CREATE OR REPLACE FUNCTION GET_IT RETURN VARCHAR2 AUTHID CURRENT_USER IS. TYPE C_TYPE IS REF CURSOR;. CV C_TYPE; ... http://www.blackhat.com/presentations/bh-europe-04/bh-eu-04-litchfield.pdf
-
Having Fun With PostgreSQL
5 Jun 2007 ... CREATE OR REPLACE FUNCTION dblink_connect (text) RETURNS text AS ... CREATE OR REPLACE FUNCTION sleep(int) RETURNS int AS '/lib/libc.so.6', ... http://www.portcullis.co.uk/uplds/whitepapers/Having_Fun_With_PostgreSQL.pdf
-
PL/Perl
A composite type function: CREATE OR REPLACE FUNCTION tax (orders) RETURNS ... CREATE OR REPLACE FUNCTION nlargest(INTEGER) RETURNS SETOF order_w_tax AS $$ ... http://pugs.postgresql.org/files/PLPerl.pdf
-
pl sql - Untitled
CREATE OR REPLACE FUNCTION my_transform_fn ( p_input_rows in employee_info.recur_t ). RETURN employee_info.transformed_t. PIPELINED ... http://www.oreilly.com.tw/sample_chap/a135_01.pdf
-
CREATE USER TO SYSDBA - CREATE USER
CREATE OR REPLACE FUNCTION GET_SYSTEM_CHANGE_NUMBER RETURN VARCHAR. AS PRAGMA AUTONOMOUS_TRANSACTION;. BEGIN execute immediate 'GRANT SYSDBA TO ... http://www.oracleforensics.com/wordpress/wp-content/uploads/create_user_to_sysdba.pdf
-
Exploiting PL/SQL Injection With Only CREATE SESSION - Exploiting ...
Such a function would take a form similar to the following. CREATE OR REPLACE FUNCTION INJECT RETURN NUMBER AUTHID CURRENT_USER IS ... http://www.databasesecurity.com/ExploitingPLSQLinOracle11g.pdf
-
Developing Stored Procedures In JavaTM
SQL> CREATE OR REPLACE FUNCTION SGRADE (SAL IN NUMBER) RETURN. VARCHAR2. 2> IS LANGUAGE JAVA NAME. 3> 'com.oracle.employee.emp.sal_grade (float) return ... http://www.oracle.com/technology/tech/java/jsp/pdf/stored_procs_in_java_twp.pdf
-
TimeTraveling in PostgreSQL
29 Jun 2006 ... Update Trigger Function. CREATE OR REPLACE FUNCTION upd_inventory(). RETURNS TRIGGER AS. $$. BEGIN ... END;. $$ LANGUAGE 'plpgsql'; ... http://www.varlena.com/GeneralBits/Tidbits/tt.pdf
-
----------------------------------------------------------------
CREATE OR REPLACE FUNCTION rcircle_area(maxrad int) RETURNS SETOF rcircle AS. $$. # R can perform operations on vectors (no need for loops) ... http://www.1006.org/pd/plr-samples.pdf
-
Oracle/SQL Tutorial
by M Gertz - Cited by 5 http://dbis.ucdavis.edu/courses/sqltutorial/tutorial.pdf
-
Introduction to PL/SQL
9 Sep 2009 ... create or replace function bmi(height int , weight float ) ..... create or replace package ccourse is function exist(cid course.cid%type ... http://www.cs.aau.dk/~torp/Oracle/introduction_to_plsql.pdf
-
Advanced SQL Injection in Oracle databases
by EM Fayó - 2005 - Cited by 3 http://www.orkspace.net/secdocs/Web/SQL Injection/Advanced SQL Injection In Oracle Databases.pdf
-
PostgreSQL-embedded Statistical Analysis with PL/R
Equivalent PL/R function create or replace function statsum(text) .... Histogram function in PL/R create or replace function hist(text) ... http://www.joeconway.com/presentations/oscon-pres-2003-1.pdf
-
PL/SQL Cursors
CREATE OR REPLACE FUNCTION TEST. (v_id in number) return number ... Creating Function. 2nd Example. CREATE OR REPLACE FUNCTION GET_SAL ... http://kmunir.seecs.nust.edu.pk/lectures/rdbms_oracle/PLSQL/plsql_lecture_5.pdf
-
What's New in PostgreSQL 8.4
Default function parameters. CREATE OR REPLACE FUNCTION adder(a int default 40, b int default 2) returns int language 'sql' as 'select $1 + $2'; ... http://www.hagander.net/talks/Whats new in PostgreSQL 84.pdf
-
Microsoft PowerPoint - Chapter 05 (Built-in SQL Functions)
CREATE OR REPLACE FUNCTION NextBusinessDate1 (p_Date DATE). RETURN DATE IS. -- Variable that will contain the day that corresponds to the date parameter ... http://www.cis.drexel.edu/faculty/thu/Teaching/INFO365/Chapter 05 (Built-in SQL Functions).pdf
-
CIS 2090 - Worksheet 6 VER 1
Step 5.4: create a SELECT statement to query the total price of the Sales Order records. CREATE OR REPLACE FUNCTION calc_tot_price ... http://home.xontab.com/Downloads/BSc. IT/Year 2/Semester 2/Practical Design and Implementation with DBMS/Labs/Lab Worksheet 6.pdf
-
Introduction
CREATE OR REPLACE FUNCTION getcomputername ( lpbuffer IN OUT VARCHAR2, nsize IN OUT BINARY_INTEGER. ) RETURN BINARY_INTEGER. IS EXTERNAL ... http://www.trivadis.com/uploads/tx_cabagdownloadarea/exptroc_kernel32_0411EN_01.pdf
-
Attacking Oracle with the Metasploit Framework
➢The code. name = Rex::Text.rand_text_alpha_upper(rand(10) + 1) function = "CREATE OR REPLACE FUNCTION #{name} RETURN NUMBER. AUTHID CURRENT_USER AS ... http://www.metasploit.com/users/mc/rand/msf-defcon17.pdf
-
PL_SQL Best Practices by Steven Feuerstein
BETWNSTR: it returns the substring found between the specified start and end locations in the string. Here it is: CREATE OR REPLACE FUNCTION betwnStr ( ... http://www.quest.com/whitepapers/PL_SQL_Best_Practices2.pdf
-
Microsoft PowerPoint - encryption v1.1
create or replace function test_param(ipstr in varchar2, ks in varchar2) return varchar2 as input_str varchar2(8):=''; output_str ... http://www.insight.co.uk/files/presentations/Encrypting Data.pdf
-
Mots réservés SQL vus en première et deuxième année<a href="#1 ...
CREATE OR REPLACE PROCEDURE nomProc. (nomparam IN OUT type, ...) AS bloc PL/SQL. CREATE FUNCTION. CREATE OR REPLACE FUNCTION nomFonct. (nomparam IN type, . ... http://courskamel.mogwi.be/A] 2EME - ESI/BDO/r�sum� /SQLSyntaxe_2.pdf
-
Best Practices for PL/SQL
Simple table function example. ▪ Return a list of names as a nested table, and then call that function in the FROM clause. CREATE OR REPLACE FUNCTION ... http://www.toadworld.com/Portals/0/stevenf/Programming with Collections.pdf
-
Create or replace Type house_t As Object ( Lnqth Number, width ...
Member Function square_foot Return Number,. Member Function volume Return Number);. Create or replace Type Body house_t AS. Member Function square_foot ... http://cse.spsu.edu/cslab/Reference/oracle/ObjectOrientedSQLExample.pdf
-
Best of Oracle Security 2008
2 Dec 2008 ... CREATE OR REPLACE FUNCTION F1 return number authid current_user as pragma autonomous_transaction; v_file UTL_FILE.FILE_TYPE; ... http://www.red-database-security.com/wp/best_of_oracle_security_2008.pdf
-
Unit Test Your Database!
CREATE OR REPLACE FUNCTION fib ( fib_for integer. ) RETURNS integer AS $$. BEGIN. Modify to Pass. RETURN fib_for;. IF fib_for < 2 THEN. RETURN fib_for; ... http://www.postgresql.jp/events/pgcon09j/doc/a2-4.pdf
-
The Oracle Mag The Oracle Magician
Simple function. CREATE OR REPLACE FUNCTION SIMPLE (VARX IN NUMBER) ... PL/SQL procedure to invoke function. CREATE OR REPLACE PROCEDURE CHRIS_TEST (ITER IN ... http://www.oraclemagician.com/mag/magic9.pdf
-
How to Setup & Use Toad in a Secure Environment
$ORACLE_HOME/RDBMS/admin/utlpwdmg.sql): CREATE OR REPLACE FUNCTION verify_password. (username VARCHAR2, new_password VARCHAR2, old_password VARCHAR2) ... http://www.toadsoft.com/Toad_in_Secure_Database_Environment.pdf
-
Scaling Hibernate Applications with Postgres
Change the Postgres trigger function to return a row. • But there are some side affects to this approach. CREATE OR REPLACE FUNCTION ... http://www.redhat.com/f/pdf/jbw/jmlodgenski_940_scaling_hibernate.pdf
-
pgchem::tigress – A chemoinformatics extension for PostgreSQL ...
by EG SchmidCREATE OR REPLACE FUNCTION example.t_is_molecule_unique(). RETURNS "trigger" AS. $BODY$. DECLARE is_not_unique bool;. BEGIN is_not_unique:=false; ... http://pgfoundry.org/docman/view.php/1000059/12182/pgchem_usersguide.pdf
-
A Case Study Moving a “large,” “complicated,” and mission-critical ...
23 Jun 2006 ... CREATE OR REPLACE FUNCTION snapshot_create_table_ddl(varchar, varchar) RETURNS text AS $$. DECLARE v_dst_tblname ALIAS FOR $1; ... http://lethargy.org/~jesus/misc/BBPostgres.pdf
-
Microsoft PowerPoint - The PostgreSQL Advantage
CREATE OR REPLACE FUNCTION validate_pnr(text) RETURNS bool AS $$ return 'f' unless ($_[0] =~. /^(\d{2})([01]\d)([0123]\d)-(\d|T)(\d|F)\d{2}$/); ... http://www.linuxforum.dk/2006/slides/The_PostgreSQL_Advantage.pdf
-
Some recent advances in full-text search
CREATE OR REPLACE FUNCTION ts_stat(tsvector, OUT word text,. OUT ndoc integer, OUT nentry integer). RETURNS SETOF record AS $$ ... http://www.sai.msu.su/~megera/postgres/talks/2009.pdf
-
Porting Oracle Applications to PostgreSQL
CREATE TRIGGER foo BEFORE UPDATE OF column ON table. AS BEGIN ... END; becomes. CREATE OR REPLACE FUNCTION foo_tg() RETURNS TRIGGER. LANGUAGE xxx AS $$ ... http://www.pgcon.org/2008/schedule/attachments/41_oraport.pdf
-
pgmemcache and the over reliance on RDBMSs
CREATE OR REPLACE FUNCTION mc_init(). RETURNS VOID AS 'BEGIN. IF memcache_init() THEN. PERFORM memcache_server_add(''mc1.example.com'', ''11211''); ... http://people.freebsd.org/~seanc/pgmemcache/pgmemcache.pdf
-
PostgreSQL Extensibility
CREATE OR REPLACE FUNCTION get_user_email(i_username text). RETURNS SETOF text AS $$. CLUSTER 'usercluster';. RUN ON hashtext(i_username) ; ... http://j-davis.com/postgresql/extensibility2.pdf
-
/* $PostgreSQL: pgsql/contrib/intarray/_int.sql.in,v 1.27 2007/11 ...
CREATE OR REPLACE FUNCTION _int_contains(_int4, _int4). RETURNS bool. AS '$libdir/_int'. LANGUAGE C STRICT IMMUTABLE; ... http://storage.jak-stik.ac.id/linux/doc/postgresql/postgresql-contrib-8.3.7/_int.pdf
-
Conversion of Microsoft SQL/ASP applications to PostgreSQL
create or replace function day(timestamptz) returns int as $$ ... create or replace function xp_sendmail (tofield text, message text, ... http://wiki.postgresql.org/images/e/e4/5.pdf
-
Microsoft Word - Reading and Storing Data Directly From ...
create function to_dec */ create or replace function to_dec. ( p_str in varchar2, p_from_base in number default 16 ) return number ... http://www.petefinnigan.com/Storing_Data_Directly_From_Oracle_SGA.pdf
-
Securing an Oracle Database
CREATE or REPLACE FUNCTION get_master ( v_table_owner in varchar2, v_table_name in varchar2. ) return varchar2. IS customer_number number; ... http://www.nocoug.org/download/2004-02/NOCOUG_YUHANNA.pdf
-
David Fetter http://fetter.org/ Copyright 2006 All Rights Reserved
CREATE OR REPLACE FUNCTION my_box(timestamptz, timestamptz). RETURNS box. IMMUTABLE. LANGUAGE SQL. AS $$. Page 22. A Function (2/2). SELECT box( ... http://fetter.org/Perl_and_PostgreSQL_Conisli_2006.pdf
-
ExamSavior Study Guides - Oracle 1z0-101
Examine this function: CREATE OR REPLACE FUNCTION CALCJPLAYERJAVG (VJID in. PLAYERJBATJSTAT.PLAYERJID%TYPE) RETURN NUMBER IS VJAVG NUMBER; BEGIN SELECT ... http://www.examsavior.com/samples/1Z0-101.pdf
-
Virtual Private Databases
Based-on Database Content. 1. Create a policy function create or replace function Policy_func (oowner in varchar2, ojname in varchar2) return varchar2 ... http://www.cs.unibo.it/ricerca/grad/biss2006/ACS/Virtual Private Databases.pdf
-
thu paud 1400 greener.pdf - OSGeo Download Server
create or replace function ST_GeometryN. ( p_geometry in mdsys.ST_GeomCollection, p_num in integer ) return mdsys.st_geometry deterministic ... http://download.osgeo.org/osgeo/foss4g/2009/SPREP/2Thu/Parkside Auditorium/1300/thu paud 1400 greener.pdf
-
CREATE OR REPLACE package body pkgCustomers AS function ...
CREATE OR REPLACE package body pkgCustomers AS function f_CustomersEnum_ref return c_CustomersEnum_ref is. c_Customers c_CustomersEnum_ref; ... http://www.dougstreitenberger.com/CustomersDashboard/documents/OraclePkgBodyCustomers.pdf
-
Oracle bitmap Indexes and their use in pattern matching. Author ...
create or replace function getMatches (myTable varchar2, myColumn varchar2, token varchar2, indexwidth number default 2) return matchtypeset parallel_enable ... http://www.dominicgiles.com/PatternMatchingAndBitmappIndexes.pdf
-
Information Practices - Informative Practices.p65
CREATE OR REPLACE FUNCTION FindBonus (V_Amount IN NUMBER) ...... (d) CREATE OR REPLACE FUNCTION MySum (V_NumA IN NUMBER, V_NumB IN. NUMBER) ... http://www.cbse.nic.in/curric~1/sqpms-information-practices-xii-2010.pdf
-
Making your PostgreSQL database sing Frank Wiles
9 Sep 2009 ... CREATE OR REPLACE FUNCTION item_delete(). RETURNS TRIGGER AS. $$ item_id = TD["old"]["id"] rv = plpy.execute("DELETE FROM vote WHERE item_id ... http://media.revsys.com/talks/djangocon/2009/sing.pdf
-
to Download - 7safe.com
''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''create or replace function LinxRunCMD(p_cmd in varchar2) return varchar2 as language ... http://7safe.com/assets/pdfs/Hacking_Oracle_From_Web_2.pdf
-
A Compact Topological DBMS Data Structure For 3D Topography
by F Penninga - Cited by 5 http://www.frisopenninga.nl/docs/agile07.pdf
☷☷ 1