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.
-
In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ... -
Extract Query: SELECT 'RULE', PET.Element_Name, TO_CHAR(PPR.legislation_code) ATTRIBUTE1, TO_CHAR(PPR.assignment_status_typ...
-
Create the concurrent program.to move you need to extract the ldt and upload the same through the script for nay other instance.Below have ...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.