Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

update Oracle table query regex user sql code log template xml script body date java file function find form center best category Business Chennai Net ajax

Welcome To Snipplr

Everyone's Recent PL/SQL Snippets Tagged Oracle

« Prev 1 Next »

PL/SQL Mover de TableSpace un Objeto o tabla

comando para cambiar el tablespace de un objeto

Oracle

0 3993 posted 13 years ago by thescorpion

PL/SQL Strategy to identify duplicates in an ETL context (for example)

This sql statement enables to detect duplicates entries over a key and creates a seq column which says which one is the sequence of the duplicates. This way you can take only the seq = 1 and still be able to identify all duplicates

Oracle

0 3901 posted 14 years ago by xavsio4

PL/SQL Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user

I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.

Oracle

0 2413 posted 15 years ago by theonlyalterego

PL/SQL Oracle - Iterating Cursor

this code is for iterating through a cursor

Oracle

0 3622 posted 15 years ago by Hisoka

PL/SQL Update da table a table

Oracle

0 3739 posted 15 years ago by tuffo19

PL/SQL Hold concurrent requests by name

Oracle

0 3626 posted 16 years ago by kitzelh

PL/SQL Kill all sessions from host in Oracle

Oracle

0 3780 posted 16 years ago by kamilch

PL/SQL Create new Oracle user

Oracle

0 1843 posted 16 years ago by kamilch

PL/SQL Oracle TO_DATE function

Oracle

0 3662 posted 16 years ago by kamilch

PL/SQL Kill oracle session

Oracle

0 3642 posted 16 years ago by kamilch

PL/SQL Drop sequences in current schema

Oracle

0 3610 posted 16 years ago by kamilch

PL/SQL Drop all tables in Oracle

Oracle

1 4318 posted 16 years ago by kamilch

PL/SQL Kill locked session

Oracle

0 3622 posted 17 years ago by tenkyu

PL/SQL Efficiently compare columns from two tables

This compares selected columns between 2 tables that you think might have differences. It lists the rows and values that are different between the two sources You can add WHERE clauses as appropriate. You could also use this to compare the resul...

Oracle

0 4246 posted 17 years ago by stews