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 3977 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 3886 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 2380 posted 15 years ago by theonlyalterego

PL/SQL Oracle - Iterating Cursor

this code is for iterating through a cursor

Oracle

0 3586 posted 15 years ago by Hisoka

PL/SQL Update da table a table

Oracle

0 3716 posted 15 years ago by tuffo19

PL/SQL Hold concurrent requests by name

Oracle

0 3605 posted 16 years ago by kitzelh

PL/SQL Kill all sessions from host in Oracle

Oracle

0 3754 posted 16 years ago by kamilch

PL/SQL Create new Oracle user

Oracle

0 1819 posted 16 years ago by kamilch

PL/SQL Oracle TO_DATE function

Oracle

0 3634 posted 16 years ago by kamilch

PL/SQL Kill oracle session

Oracle

0 3613 posted 16 years ago by kamilch

PL/SQL Drop sequences in current schema

Oracle

0 3584 posted 16 years ago by kamilch

PL/SQL Drop all tables in Oracle

Oracle

1 4295 posted 16 years ago by kamilch

PL/SQL Kill locked session

Oracle

0 3597 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 4231 posted 17 years ago by stews