Home/ Walaa Mohamed/Followers Answers
  1. Asked: June 11, 2016In:

    how to Order by string in SQL ?

    Hassan AbdElrahman
    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
  2. Asked: June 11, 2016In:

    How to remove blank line when you create list item in oracle forms 10g ?

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

    as per oracle forms online help: Forms maintains an additional NULL element in a list item List Items and Null Values ... Setting the Required property for a poplist or TList may affect the values the list will display: When selected, an instance of a poplist will display an extra null value if itsRead more

    as per oracle forms online help:
    Forms maintains an additional NULL element in a list item
    List Items and Null Values … Setting the Required property for a poplist or TList may affect the values the list will display: When selected, an instance of a poplist will display an extra null value if its current value is Null or if its effective Required property is false.
    CLEAR_LIST Built-in Clears all elements from a list item. After Oracle Forms clears the list, the list will contain only one element (the null element), regardless of the item’s Required property.

    See less