Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

sql page server Oracle mysql csv database wordpress error php code drupal date replace script security search xml function text order textmate update file query data list table excel backup customer load login ASP codeigniter magento simple user windows convert joomla math find copy json Business directory number path images Online log links template link Development api twitter best web format object cache mail email html javascript actionscript apache color download service android animation browser aspnet ajax

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged Oracle

« Prev 1 2 3 4 5 6 Next »

SQL Oracle LENGTH Function

A few examples of the LENGTH function

Oracle

0 974 posted 8 years ago by bbrumm

SQL Oracle LTRIM Function

A few examples of the Oracle LTRIM function.

Oracle

0 1011 posted 8 years ago by bbrumm

SQL Oracle INSTR Function

A few examples of the Oracle INSTR function.

Oracle

0 1028 posted 8 years ago by bbrumm

SQL Oracle RTRIM Function

A few examples of the Oracle RTRIM function.

Oracle

0 1025 posted 8 years ago by bbrumm

SQL Oracle CASE Expression

A few examples of the Oracle CASE expression

Oracle

0 865 posted 8 years ago by bbrumm

SQL Oracle REPLACE Function

A few examples of the Oracle REPLACE function

Oracle

0 881 posted 8 years ago by bbrumm

SQL Oracle GREATEST Function

A few examples of the GREATEST function

Oracle

0 1017 posted 8 years ago by bbrumm

SQL Oracle LEAST Function

A few examples of the Oracle LEAST function

Oracle

0 1021 posted 8 years ago by bbrumm

SQL Oracle LISTAGG Function with Examples

Some examples of the Oracle LISTAGG function, including setting up the tables.

Oracle

0 1466 posted 8 years ago by bbrumm

SQL Oracle NVL2 Function

Some examples of the NVL2 function in Oracle, including setup table.

Oracle

0 1075 posted 8 years ago by bbrumm

SQL Oracle CONCAT Function

A few examples of the CONCAT function, including setting up the example tables.

Oracle

0 1025 posted 8 years ago by bbrumm

SQL Oracle TO_CHAR Examples

A few examples of the Oracle TO_CHAR function, which works on numbers and dates.

Oracle

0 880 posted 8 years ago by bbrumm

SQL Oracle TO_DATE Examples

These are some examples of the Oracle TO_DATE Function

Oracle

0 874 posted 8 years ago by bbrumm

SQL Get all procedures from Oracle packages

This only shows public procedures, not the privates one declares only in packages body.

Oracle

0 1065 posted 10 years ago by Igeco

SQL Find a blocking session and kill it

La premiÃ¨re commande liste les sessions bloquantes, la deuxiÃ¨me les kill

Oracle

0 1145 posted 10 years ago by Igeco

SQL List locked object Oracle Database

List locked object Oracle Database using V$LOCKED_OBJECT view

Oracle

0 1096 posted 12 years ago by ceduard0

SQL CASE statement to transpose rows in to columns

This SQL would help you to transpose a rows into columns in SQL

Oracle

0 2689 posted 12 years ago by mprabhuram

SQL Ver tablas asignadas a un usuario por privilegios

ver tablas que tiene un usario asiganadas por privilegio

Oracle

0 4989 posted 12 years ago by thescorpion

SQL Grant y Revoke sobre objetos - dinamico

Uso de Grant y Revoke de objetos masivos de distintos user

Oracle

0 1057 posted 12 years ago by thescorpion

SQL Creacion de DBLINK con Full name service

Cuando se da el caso que tienes 2 servidores diferentes y el ServiceName de oracle es el mismo...En el momento de crear un dblink hay que especificar bien la cadena de coneccion para que se direccione al otro servidor y no escoja el serviceName del e...