-
Ahmed Hassan
- January 15, 2024
- Oracle SQL
- (0)
How to use the ROUND, TRUNC and MOD function in Oracle sql. with examples.
ROUND function is used when you need to round decimal number to the closest one. https://youtu.be/TTCyvIQzFZE Round numbers: ROUND Examples: SELECT ROUND(45.923,2), ROUND(45.923,0), ROUND(45.923,-1) FROM DUAL; TRUNC function: TRUNC function…
-
- August 3, 2023
- Oracle DBA
- (0)
How to uninstall Oracle 21c from Windows – Easy steps
https://youtu.be/YP1qj7QRsXs Follow these steps to uninstall Oracle 21c from Windows: Navigate to the Oracle database file used during installation and execute the setup again. The setup will recognize the presence…
-
- July 28, 2023
- Oracle Ebusiness suite R12
- (0)
Query to get user responsibilities in oracle apps EBS R12. Run it now
Query to show all changes on responsibilities and roles on oracle apps EBS R12, It show all added or removed responsibilities for all users within range of date. This query…
-
- July 28, 2023
- Oracle Ebusiness suite R12
- (0)
How to get all supplier sites and contacts on oracle EBS R12. easy and fast.
Use this EBS R12 query for the following requirements: - Find all supplier sites and contact details for for vendors. - Extract all site details for fusion data migration purpose.…
-
- July 23, 2023
- Oracle DBA
- (0)
How unlock user in oracle? Fix error ORA-28000 The account is locked, simple and easy.
By typing the password incorrect many times user may locked due to security reasons, You may get the error ORA-28000 The account is locked while trying to login to database.…
-
- July 22, 2023
- Oracle DBA
- (0)
Oracle sample schema, step by step how to install it, Everything you need to know!
If you are willing to learn SQL and run some test scripts, you will need to install oracle sample schemas. On this post we are going to install oracle database…
-
- July 10, 2023
- Oracle DBA
- (0)
How to install Oracle Database 19c on windows 11? All you need to know.
https://www.youtube.com/watch?v=2bcsdu-BVEA&t=3s #Step 1: Search for downloadable file. Open your browser and search for Oracle Database download, most likely it will be the first result. #Step 2: select Oracle…
-
- April 8, 2023
- Oracle Ebusiness suite R12
- (0)
How to find All customers on Oracle EBS R12. Save your time by easy, guaranteed query.
How to use this query? 1 - For Oracle EBS R12 to Oracle Fusion Cloud Data migration, for that run the query, extract the results, then put in on…
-
- April 7, 2023
- Oracle Ebusiness suite R12
- (0)
How to get All AR open transactions on EBS R12.
Check out our query to get All AR transaction in Oracle EBS R12. Use this query EBS R12 for the following requirements: 1 - Extract All open Transactions on oracle…
-
- April 6, 2023
- Oracle Ebusiness suite R12
- (0)
How to get AP invoices in Oracle EBS r12 for Oracle Fusion Data migration FBDI, Simple Query
The following is query to find all AP open invoices in Oracle ebs R12, run it, export the result on excel sheet, and move it to Oracle template FBDI for…
