Home/Database/Oracle SQL/Page 6
  1. Asked: June 15, 2016In:

    How to check whether partitioning enabled or not in my database ?

    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

    we need to execute this select statement to check select * from v$option where parameter = 'Partitioning'; PARAMETER VALUE Partitioning TRUE

    we need to execute this select statement to check

    select * from v$option where parameter = 'Partitioning';
    PARAMETER VALUE
    Partitioning TRUE
    See less
    • 0
  2. Asked: June 14, 2016In:

    how to concatenate two string or two values in oracle sql ?

    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

    It is ||, for example: select 'Mr ' || emp_name from employees; or concatenate two column values by : select first_name || '-' || last_namefrom employees;

    It is ||, for example:

    select 'Mr ' || emp_name from employees;

    or concatenate two column values by :

    select first_name || '-' || last_name
    from employees;
    See less
    • 0
  3. Asked: June 11, 2016In:

    how to Order by string in SQL ?

    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    This answer was edited.

    In standard SQL, you need a case statement Select * From people ORDER BY (case when names = 'john' then 1 when names = 'steve' then 2 when names = 'bob' then 3 when names = 'bill' then 4 else 5 ); You can find this article helpful for you in case you are using Oracle database: Oracle Case StatementRead more

    In standard SQL, you need a case statement

    Select *
From people
ORDER BY (case when names = 'john' then 1
               when names = 'steve' then 2
               when names = 'bob' then 3
               when names = 'bill' then 4
          else 5
         );

    You can find this article helpful for you in case you are using Oracle database:

    Oracle Case Statement : (Simple Case, Searched Case)

    Some SQL engines have shortcuts to this, but you don’t mention which database you are using.
    For instance, in MySQL you can do:

    order by field(names, 'john', 'steve', 'bob', 'bill');
    See less
    • 0