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

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…

History of Oracle introductions

History of Oracle introductions Year Feature 1977 Software Development Laboratories founded by Larry Ellison, Bob Miner, Ed Oates 1979 Oracle version 2: first commercially available relational database to use SQL 1983 Oracle version 3: single code base for Oracle across multiple platforms 1984 Oracle version 4: with portable toolset, read consistency 1986 Oracle version 5…