• Latest Updates

    Post Top Ad

    05 July, 2013

    Home Oracle Database view all data for duplicate rows in oracle

    view all data for duplicate rows in oracle 

    SELECT   name 
       , type_id
FROM   table1
GROUP BY name 
         , type_id
HAVING COUNT(*) > 1
    Tags
    Share This
    Author Image

    About Piyush Prakash

    By at
    Tags:

    No comments:

    Post a Comment

    Subscribe to: Post Comments (Atom)

    Post Top Ad

    Your Ad Spot

    Pages

    About Me

    Effective Oracle Application Database Administrator (on premise and ExaCS) with proven experience in Oracle E-business Suite (11i, 12.1.3, 12.2), Oracle Database(11g, 12c, 19c), Database Security, Oracle Database Performance, VCP Demantra, Solix, Endeca, WebLogic, JDE and Peoplesoft. Currently, designated as Cloud Specialist for Cloud Transformation related to Oracle PaaS for SaaS Clients projects involving Oracle PaaS Services like ADW/ATP, OIC, VBCS, OIC SFTP, OAC, etc. along with SaaS connectivity and DR support. Cloud Deployment Models, IAM, S3, EC2, VPC, SNS, Security Groups, Subnets, VPC Peering, Tags, Amazon Glacier, S3 Bucket Replication, AWS GuardDuty, AWS CLI, Alarm, Auto Scaling, SQS, Snapshots, CRR, Inbound and Outbound Rules, SSH Key Managements, Load Balancer, Health Check of EC2, Versioning, Password Policy, File Systems.

    Send Quick Message

    Name

    Email *

    Message *