Oracle

Method 1

Remove the & symbols from your query

Method 2

Replace the & symbols with chr(38)


Method 1

Add /*csv*/ to the SQL query right after SELECT clause and run the query as a script using F5 or the second Execute button on the worksheet toolbar.


Example 2: In the following table called Customers, return only one Phone Number with priority to CellPhone first, then DayPhone, then NightPhone.


Example: In the following table called Customers, return only one Phone Number with priority to CellPhone first then DayPhone. Return Cellphone is CellPhone is not Null.


Method 1

Simple Case Statement with one expressions


Example: In the following table called Customers, return the Phone Number if the ContactbyPhone is
Y, otherwise if the ContactbyPhone is Null, return the Email.


Example 1: In the following table called Customers, return only one Phone Number with priority to CellPhone first then DayPhone. Return Cellphone is CellPhone is not NUll.


User login