HUNGRYDBA.BLOGSPOT.COM

The Hungry DBA

Friday, March 28, 2008. SQL to delete duplicate records in Oracle. Lets say you have a table named test which has a field called user name containing duplicate entries. You want to remove duplicate entries while retaining a single record. For example if you had three "MARY" records you would want to remove 2 of these and keep a single "MARY". A simple SQL statement to do this would be:. DELETE FROM test t1. SELECT min(rowid) FROM test t2. WHERE t1.user name = t2.user name);. CURSOR c duplicates IS. Creat...

http://hungrydba.blogspot.com/

OVERVIEW OF hungrydba.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

9

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR HUNGRYDBA.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

November

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.0 out of 5 with 15 reviews

5 star

6

4 star

5

3 star

3

2 star

0

1 star

1

Hey there! Start your review of hungrydba.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

1.5 seconds

CONTACTS AT HUNGRYDBA.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

9

SSL

EXTERNAL LINKS

0

SITE IP

172.217.12.129

LOAD TIME

1.549 sec

SCORE

6.2

PAGE TITLE

The Hungry DBA | hungrydba.blogspot.com Reviews

<META> DESCRIPTION

Friday, March 28, 2008. SQL to delete duplicate records in Oracle. Lets say you have a table named test which has a field called user name containing duplicate entries. You want to remove duplicate entries while retaining a single record. For example if you had three MARY records you would want to remove 2 of these and keep a single MARY. A simple SQL statement to do this would be:. DELETE FROM test t1. SELECT min(rowid) FROM test t2. WHERE t1.user name = t2.user name);. CURSOR c duplicates IS. Creat...

<META> KEYWORDS

1 the hungry dba

2 where rowid

3 declare

4 from

5 begin

6 loop

7 from test

8 delete from test

9 end loop;

10 commit;

CONTENT

Page content here

KEYWORDS ON PAGE

the hungry dba,where rowid,declare,from,begin,loop,from test,delete from test,end loop;,commit;,end;,posted by,39 comments,max audit id c4,select,count *,select grp,block id,blocks,from dba extents,from dba objects,select count *,into l cnt,cool,rollback;

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

The Hungry DBA | hungrydba.blogspot.com Reviews

https://hungrydba.blogspot.com

Friday, March 28, 2008. SQL to delete duplicate records in Oracle. Lets say you have a table named test which has a field called user name containing duplicate entries. You want to remove duplicate entries while retaining a single record. For example if you had three "MARY" records you would want to remove 2 of these and keep a single "MARY". A simple SQL statement to do this would be:. DELETE FROM test t1. SELECT min(rowid) FROM test t2. WHERE t1.user name = t2.user name);. CURSOR c duplicates IS. Creat...

INTERNAL PAGES

hungrydba.blogspot.com

1

The Hungry DBA: SQL to delete duplicate records in Oracle

http://hungrydba.blogspot.com/2008/03/removing-duplicate-records-using-plsql.html

Friday, March 28, 2008. SQL to delete duplicate records in Oracle. Lets say you have a table named test which has a field called user name containing duplicate entries. You want to remove duplicate entries while retaining a single record. For example if you had three "MARY" records you would want to remove 2 of these and keep a single "MARY". A simple SQL statement to do this would be:. DELETE FROM test t1. SELECT min(rowid) FROM test t2. WHERE t1.user name = t2.user name);. CURSOR c duplicates IS. Man p...

2

The Hungry DBA: PLS-00436 when doing a FORALL Update based on a collection

http://hungrydba.blogspot.com/2007/11/pls-00436-when-doing-forall-update.html

Tuesday, November 27, 2007. PLS-00436 when doing a FORALL Update based on a collection. The following example code attempts to perform a FORALL UPDATE based on a Bulk Collection into a PL/SQL Table. Unfortunately this is not supported as the below error shows:. CURSOR c mycursor IS. SELECT rowid, c act cr code FROM C ACT ACTUAL CASH TXN. WHERE c act cr code = 'USD';. TYPE t mytype IS TABLE OF c mycursor%ROWTYPE INDEX BY BINARY INTEGER;. V mycursor t mytype;. OPEN c mycursor;. CLOSE c mycursor;. The worka...

3

The Hungry DBA: Watch out for simple mistakes

http://hungrydba.blogspot.com/2007/11/watch-out-for-simple-mistakes.html

Tuesday, November 13, 2007. Watch out for simple mistakes. While investigating a trace of a Oracle session I came across the following SQL:. C in instrument cin. Cinc in current mkr = 'N'. Cinc in id IN. NVL(cih.c ih previous id,' ). C ih instrument hold cih. Call count cpu elapsed disk query current rows. Parse 1 0.00 0.00 0 0 0 0. Execute 1 3.04 9.94 1894 18920 13983 6758. Fetch 0 0.00 0.00 0 0 0 0. Total 2 3.04 9.94 1894 18920 13983 6758. Misses in library cache during parse: 0. This was tuned by addi...

4

The Hungry DBA: Tom Kyte's Do-It-Yourself Parallelism

http://hungrydba.blogspot.com/2007/12/tom-kytes-do-it-yourself-parallelism.html

Sunday, December 2, 2007. Tom Kyte's Do-It-Yourself Parallelism. The following is based on solutions provided by Thomas Kyte (author of http:/ asktom.oracle.com/. As detailed in his book "Effective Oracle by Design". A typical batch process may look something like:. Create procedure batch process. For x in (select * from audit data). Do some stuff here . Well since the audit data table has a primary key audit id which is a number field we can split the process easy enough as follows:. Do some stuff here .

5

The Hungry DBA: Tuning UPDATE with MERGE INTO

http://hungrydba.blogspot.com/2007/11/tuning-update-with-merge-into.html

Tuesday, November 13, 2007. Tuning UPDATE with MERGE INTO. The below UPDATE statement performed 535,656 logical I/Os, of which 13807 were physical I/Os from disk, and took 93.15 seconds to update 0 rows. UPDATE c inrd ins redemption inrd. SET (inrd.c inrd input date,. Inrdc inrd rdm early value,. Inrdc inrd exsh j1. SELECT ixj.i xj file date,. DECODE(inrd.c inrd rdm early value,0,ixj.i xj j4 early value,. DECODE(ixj.i xj j4 early value,0,inrd.c inrd rdm early value,. Ixji xj j4 early value) ,. 0 TABLE AC...

UPGRADE TO PREMIUM TO VIEW 4 MORE

TOTAL PAGES IN THIS WEBSITE

9

OTHER SITES

hungrydata.com

The domain name is registered

THE DOMAIN NAME IS REGISTERED. A DOMAIN NÉV REGISZTRÁLT. In case of donations .

hungrydata.com.au

Home

Specifically Designed and Written for the Food Industry. Hungry Data was written specifically for the Food and Hospitality. Industry .This is why Pizza shops / Burger chains and all fast. Food driven stores and restaurants love all the features Hungry Data delivers. All features are customised to suit the food industry. All the functionality needed to run a Master Food Franchise. At the lowest prices around. Everything from Online Ordering to Cost of Good Analysis. Try Hungry Data for Free*. Hungry Data ...

hungrydawg.com

Welcome to hungrydawg.com

Site Last Updated on Tuesday, December 20, 2011. From the Photo Album. Dec 13, 2009. If you would like to access the hungrydawg.com site, email Julie. For a User ID and password. Login to hungrydawg.com over the holidays with the UserID of "guest". And Password of "holiday". Visit Lily's Blog at: godgaveusyou.blogspot.com. Hungrydawg.com - FamilyWebShare.

hungrydawgz.com

Organic Handmade Dog Treats | Los Angeles | Hungry Dawgz of Dogtown

hungrydawgzofdogtown.com

Hungry Dawgz of Dogtown

hungrydba.blogspot.com

The Hungry DBA

Friday, March 28, 2008. SQL to delete duplicate records in Oracle. Lets say you have a table named test which has a field called user name containing duplicate entries. You want to remove duplicate entries while retaining a single record. For example if you had three "MARY" records you would want to remove 2 of these and keep a single "MARY". A simple SQL statement to do this would be:. DELETE FROM test t1. SELECT min(rowid) FROM test t2. WHERE t1.user name = t2.user name);. CURSOR c duplicates IS. Creat...

hungrydba.com

Home - HungryDBA.com

Hungry DBA .com for DBAs who like food. Forget the intricacy of a ORA-600 error or the anxiety of trying to restore that one billion dollar database; One of the toughest decisions a DBA has to make on a day to day basis is to decide what's for lunch. This website is dedicated to food ideas for Database Administrators. DBAs and their food. Database Support Services Limited - We are the expertise behind your peace of mind.

hungrydead.com

Welcome hungrydead.com - BlueHost.com

Web Hosting - courtesy of www.bluehost.com.

hungrydeals.sg

HungryDeals - Restaurant Dining Deals, Promotions and Discounts

Book, Dine and Save. No vouchers or prepayment needed. Book, Dine and Save. No vouchers or prepayment needed. HGW Exclusive - 4th diner dines FREE*. Kuishin Bo @ Suntec City. 4th diner dines FREE*. View and Book Now. HGW Exclusive - Omakase Set at $50 (Usual Price: $100). Fukuichi Japanese Restaurant (Hotel Chancellor). Omakase Set at $50 (Usual Price: $100):. View and Book Now. HGW Exclusive - FREE Margarita and Calamari. View and Book Now. HGW Exclusive - Dinner with Michelin Starred Chef. Enjoy a comp...

hungrydelights.blogspot.com

Hungry Delights

Monday, 3 June 2013. Monday Delights ♥ Episode Twenty. Always. / source. This article is full of some really great tips. Now to overcome my shyness photographing in a restaurant. / source. I AM OBSESSED. WITH. BENTOS. / source. Just so much LOL here - I wish I had the courage to do this to my cat hahaha / source. These fonts are just simply gorgeous. / source. I am soo going to make this - what a smart idea to come up with! Links to this post. Saturday, 1 June 2013. On the blog to try and then I kinda di...

hungrydenmark.dk

Hungry Denmark

Define your site secondary menu. Ris & Pasta. Januar 20, 2015. Banankage m. blåbær og chokolade overtræk. Januar 6, 2015. En højt belagt m. Sriracha kylling. Januar 6, 2015. Big Timmy. #BurgerBashThursday. December 1, 2014. November 21, 2014. November 20, 2014. Den fede italianer. #BurgerBashThursday. November 19, 2014. November 18, 2014. November 18, 2014. Dobbelt cheese Sriracha sauce burger! November 10, 2014. November 10, 2014. November 9, 2014. Omelet á la Penny. November 8, 2014. November 7, 2014.