Tag Archives: Oracle Tips and Tricks

How to Delete Duplicate Rows from a Table

Delete Duplicate Rows from a Table

How to remove duplicate records from a Table? If you want to remove duplicate rows from a Table and want to leave only unique records in a Table then choose any one of the following method to delete duplicate rows. Method-1: SQL> DELETE FROM SAMPLE A WHERE ROWID > (SELECT MIN(ROWID) FROM SAMPLE B WHERE

What is the Difference between Truncate and Delete in Oracle

Difference Between Truncate and Delete

First create a Table using following command on SQL> prompt. CREATE TABLE SAMPLE (ID NUMBER, NAME VARCHAR2(20),CITY VARCHAR2(15), ADDRESS VARCHAR2(50)); Now insert three records into SAMPLE table using following command. INSERT INTO SAMPLE VALUES (1,’AMIT KUMAR’,’DELHI’,’MAIN MARKET, DELHI’); INSERT INTO SAMPLE VALUES (2,’SUDHIR MALHOTRA’,’AGRA’,’ALIBAGH’); INSERT INTO SAMPLE VALUES (3,’DEVANG MEHRA’,’ALIGARH’,’NEAR RLY. ST.’); Don’t forget to

Oracle DBA Tips

Oracle DBA Tips

You will find here Oracle DBA tips and techniques which will help you to resolve your issues. If you want to learn about these tips then follow the links.

PL/SQL Tutorial

Oracle PLSQL Tips

PL/SQL (Procedural Language/Structured Query Language) stands for Procedural Language extension of SQL. This Oracle PL/SQL tutorial will teach you the basics of programming in PL/SQL like Cursors, Stored Procedures, PL/SQL functions, Packages, Triggers and many more. <—– PL/SQL Tutorial —–> How to send an E-Mail from 10g Oracle Database How to use LPAD and RPAD

SQL Tutorial

Oracle SQL Tips

SQL (pronounced as “ess-que-el”) stands for Structured Query Language. SQL is used to modify and access data from a database and is used by most common relational database management systems like Oracle, Sybase, Microsoft SQL Server, Access, etc. <—– SQL Tutorial —–> SQL Interview Questions and Answers – 1 Difference Between DDL, DML and DCL

Fixed ORA-12518: TNS:listener could not hand off client connection

You try to connect with Oracle database and get Ora-12518 listener could not hand off client connection error. Now what action is to be taken to get rid of above error? Follow below steps to resolve the issue. Connect with oracle database: C:\>sqlplus / as sysdba SQL>conn testuser/test@mydb And you got the ERROR: ORA-12518: TNS:

Resolved ORA-12528: TNS:listener: all appropriate instances are blocking new connections error

I was getting ORA-12528:TNS:listener error while connecting with my Oracle XE 11g database. SQL> conn sys/sys@xe as sysdba It gives an error message ORA-12528: TNS listener- all appropriate instances are blocking new connections. Just follow the steps to resolve ORA-12528:TNS:listener issue. XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA

Resolved ORA-12541: TNS no listener error

N no. of articles you will find on the internet about “ORA-12541 TNS no listener error” but still finding an effective solution. Don’t worry this solution helped me a lot and I hope it will help you too. I got the same issue while working on Oracle 10g database then I decided to share my

Siteground SALE
60% OFF SiteGround WordPress Hosting – $3.95/month (Exclusive Offer !!!)