BIGtheme.net http://bigtheme.net/ecommerce/opencart OpenCart Templates
Home / Oracle / DBA

DBA

December, 2015

  • 6 December

    Installing Java, Oracle 11g R2 Express Edition and SQL Developer on Ubuntu/Mint 64-bit

     Installing Java We start with installing Java on the machine. My personal preference is to use Oracle Java JDK. Installing this JDK could be done easily by performing the following statements. [crayon-59c527ab032d3074336266/] Notice:: You can change version from “oracle-java7-installer” to “oracle-java6-installer” or “oracle-java8-installer” .. as you want 🙂 The screen in figure ...

November, 2015

  • 6 November

    code best of #oracle_sql

    Case 1 I use COALESCE( v(‘APP_USER’),USER );  instead of NVL( V(‘APP_USER’),USER ); Cause: More performance. Case 2 I use SYS_CONTEXT(‘APEX$SESSION’, ‘app_user’) instead of V(‘APP_USER’) Cause: i can’t use v(‘APP_USER’) by default value for column but i can use SYS_CONTEXT(‘APEX$SESSION’, ‘app_user’) for default value of column    source: http://apex-oracle-arab.blogspot.com.eg/

September, 2015

  • 5 September

    How to use the SQL Tuning Advisor feature in Oracle SQL Developer

    First execute some codes .. [crayon-59c527ab055b8897261734/] And show this toturial to help you link source: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r32/Tuning_Advisor_OBE/SQL%20Tuning%20Advisor.html http://www.dbzoo.com/blog/enabling_oracle_sql_advisor

March, 2015

  • 28 March

    How to change port listner in oracle ?

    SQLPLUS /NOLOG At the SQL Command Line prompt, enter the following command: [crayon-59c527ab059ed956327317/] –where password is the SYSTEM password that you set upon installation (Windows) or configuration (Linux) of Oracle Database XE. At the SQL Command Line prompt, enter the following command: [crayon-59c527ab059fa964507800/] –where nnnn represents the new port number ...

  • 28 March

    How to select constraint in oracle DB ?

    You can by use .. [crayon-59c527ab05e8e950342188/]  

  • 26 March

    Alter User in SQL

    You can alter user by.. [crayon-59c527ab06286322957506/]