Do not use quotation marks with character and date items.
• The LIKE operator is implied with % or _.
• Use hash (#) in front of SQL operators.
• Use Query/Where for complex query conditions.
• Use default date format (DD-MON-YY) in Query/Where.
• Use quotes around literals in Query/Where.
Oracle Technical Experience and Test Cases Shared from different resource and through self leanings.
Subscribe to:
Post Comments (Atom)
COALESCE-SQL
Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...
-
Example 1: Passing parameters to report 1) Go into the Data Model and then change the query: select a.*, b.dname from emp a, dept b ...
-
This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...
-
Creating LOVs 1. Start a new module by clicking on File - New - Form. 2. Change Module’s name to TEST_LOV. 3. Set up DEPT and EMP...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.