xavsio4

Member since 02/26/2010

5 snippets

3078 profile views

0 Comment(s) Posted

View their favorites

their Tags

css CSS3 Business Oracle wordpress web design starter php sql jquery

Profile

Achievement

xavsio4's Recent SnippetsTagged Oracle

All /

« Prev 1 Next »

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 1069 posted 13 years ago by xavsio4

SQL Return a random sample of 5% of records of a table with Oracle

Oracle

0 1039 posted 13 years ago by xavsio4

SQL Compare dates in Business Objects Data Integrator with Oracle

Oracle

0 782 posted 13 years ago by xavsio4

SQL Get all tables and views having this field in their structure

Oracle

0 749 posted 13 years ago by xavsio4

SQL View active sessions in Oracle

Oracle

0 705 posted 14 years ago by xavsio4