ROW_NUMBER () OVER (PARTITION BY) functionality in oracle 12c

Usage of ROW_NUMBER () OVER (PARTITION BY) functionality in oracle 12c. This is use for main two purpose 1) It assign new index for row as per repeat Field in Table 2) While you want to convert row to Column (Each row can be convert in Column for another table) EX:  I have Data table…

ORA-12541: TNS:no listener

This error is occurs when oracle service is stopped in database server. You just need to restart this service by following step. 1 ) Open Database Server 2) Open Command prompt and move to till C:/ 3 ) Type following command C:\>lsnrctl start 5) Open your application it will work properly..

How to Change SQL Developer Default Language ?

To change SQL Developer Language in English Language need to do following think. Find the path of oracle installation of SQL developer EX:  C:\app\Client\product\12.1.0\client_1\sqldeveloper\ide\bin\ide.conf Add/Change following Statement AddVMOption -Duser.language=en

Binded textbox not allow to loss focus in

To solve bounded Textbox validating problem in with WCF Dataset, Follow the following steps.. Drag and Drop field from DataSource window’s Dataset(ServiceReference Dataset) and put on form. Remove Binding source from Property window as show in following sanapshort. 3. Assign binding source to control that now allowing to remove focus while it is empty…

Create new schema/user in oracle 11g

Follow the following step to create new user/schema in oracle 10g. 1 ) Login with existing user 2) Fire following command .. CREATE USER <new User Name> IDENTIFIED BY <new User Psw>; new user will created 3) Give session permission to user by issuing following command GRANT CREATE SESSION TO <new User Name>WITH ADMIN OPTION 4) Now…

WCF Publishing Error : Could not load file or assembly ‘Oracle.DataAccess’ or one of its dependencies. An attempt was made to load a program with an incorrect format.

Description: An unhanded exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.BadImageFormatException: Could not load file or assembly ‘Oracle.DataAccess’ or one of its dependencies. An attempt was made to load a program with…

Oracle Connection String Attribute

private string BuildConnectionString(string TNSName, string UserID, string Password) { OracleConnectionStringBuilder _conn = new OracleConnectionStringBuilder(); { _conn.DataSource = TNSName; _conn.DecrPoolSize = 5; _conn.IncrPoolSize = 10; _conn.Pooling = true; _conn.MaxPoolSize = 100; _conn.MinPoolSize = 5; _conn.ConnectionLifeTime = 120 _conn.ConnectionTimeout = 60 _conn.UserID = UserID; _conn.Password = Password; } return _conn.ConnectionString; }