Tools for inserting Unicode Urdu Data into Oracle Database

Following tools are used to insert Unicode Urdu Data into Oracle Database without any configuration or setting.

1) Oracle iSQL*Plus
2) Oracle SQL Developer

Oracle iSQL*Plus

iSQLPlus (iSQL*Plus) is a web-based utility similar to SQL*Plus. Using iSQL*Plus you can run SQL and PL/SQL commands and display their results. iSQLPlus commonly used by users, administrators, and programmers.

How to access Oracle iSQL*Plus

Use the following command to start the services of Oracle iSQL*Plus.
Isqlplusctl start

Open your web browser and navigate to the system ( . Oracle iSQL*Plus used the 5560 port.

Oracle SQL Developer
Oracle SQL Developer is an integrated development environment (IDE) for working with SQL in Oracle databases. Oracle Corporation provides this product free. You can use this IDE to insert Unicode Urdu data in Oracle Database without any NLS LANG setting.


  1. This is helpful, I have done and using Oracle SQL Developer its showing correct save text which is in urdu, but when I am sending SMS using procedure which getting the value NVARCHAR2 column the SMS received on Mobile is showing the values like : ¿¿ ¿¿¿¿ ¿¿¿¿, So how to fixed it and disply it as URDU human readable form?


Post a Comment

Popular posts from this blog

How to create Oracle stored Procedures using TOAD for Oracle

How to Create Packages in Oracle Database using TOAD for Oracle

Create Tables in Oracle Database using TOAD