Discussion List

• Dynamically Creating views inside a Table Based Trigger

  Answered 11 views 2 comments 0 points Most recent by BrunoVroman Jan 1, 2025 3:19PMPL/SQL (MOSC)
• Oracle database pl sql syntax error

  Answered 21 views 5 comments 0 points Most recent by SolomonYakobson Dec 19, 2024 9:04PMPL/SQL (MOSC)
• Need SQL query to display Position start date and end date

  Answered ✓ 41 views 10 comments 0 points Most recent by Visu Jun 4, 2023 7:13AMSQL*Plus (MOSC)
• Creating single table having multiple schema data

  Answered 31 views 16 comments 0 points Most recent by Mark D Powell Mar 29, 2022 2:10PMPL/SQL (MOSC)
• Logon trigger doesn't fire - but only when compiling PL-SQL

  Answered 11 views 5 comments 0 points Most recent by B Conn Nov 15, 2021 11:38AMDatabase Administration (MOSC)
• Getting "invalid identifier" error while inserting dynamic date value in table

  Answered 1 view 11 comments 0 points Most recent by Anurag Gupta May 27, 2021 5:29AMSQL Language (MOSC)
• Not able to update tables using Anonymous block in PLSQL

  Answered 1 view 2 comments 0 points Most recent by AB115 Mar 19, 2021 1:31PMPL/SQL (MOSC)
• Performance degrade with every consecutive run

  Answered 11 views 2 comments 0 points Most recent by Mark D Powell Dec 24, 2020 12:57PMDatabase Administration (MOSC)
• Update Payment Terms in Oracle EBS

  Answered ✓ 18 views 2 comments 0 points Most recent by Samson Nguyen Sep 2, 2020 5:54AMPayables and Cash Management - EBS (MOSC)
• JSON format using DBLINK

  Answered ✓ 94 views 8 comments 1 point Most recent by User_9IHP2 Jul 29, 2020 5:09AMPL/SQL (MOSC)
• Getting Subscript beyond count while calling procedure which accepts input as record type

  Answered 104 views 1 comment 2 points Most recent by GregV May 26, 2020 2:27AMPL/SQL (MOSC)
• Too Many Records in SIEBEL.S_ACT_EMP ?

  Answered 74 views 6 comments 2 points Most recent by Sibel Kurt Apr 10, 2020 7:22AMSiebel Open UI, Tools, Scripting and EAI (MOSC)
• pivot row into column

  Answered ✓ 57 views 3 comments 0 points Most recent by Gaz in Oz Dec 31, 2019 1:52AMSQL Language (MOSC)
• Display Future projection for Oracle Assets

  Answered 56 views 4 comments 0 points Most recent by Kath Alcayde Nov 18, 2019 7:37AMFixed Assets - EBS (MOSC)
• DATE to TIMESTAMP with TIMEZONE

  Answered 338 views 3 comments 0 points Most recent by Gaz in Oz Sep 6, 2019 9:43AMPL/SQL (MOSC)
• Need to Update Account Number on some Orders

  Answered 58 views 6 comments 0 points Most recent by ChristineS-Oracle Jul 1, 2019 10:52AMOrder Management - EBS (MOSC)
• Claim WebADI Download(Mapping) -Based on the Claim Status Parameters entered (Multiple seperated by

  Answered ✓ 1.6K views 1 comment 0 points Most recent by John Manly May 22, 2019 1:36AMChannel Revenue Management - EBS (MOSC)
• NVL different output based on bound type

  Answered 26 views 2 comments 2 points Most recent by GregV May 14, 2019 8:23AMSQL Language (MOSC)
• Oracle Calandar

  Answered 85 views 8 comments 4 points Most recent by Catinredboots Oct 9, 2018 5:55PMSQL Language (MOSC)
• SOA PURGE JOB - PROC ISSUE

  Answered 112 views 2 comments 0 points Most recent by Mark D Powell Sep 5, 2018 11:44AMPL/SQL (MOSC)
• Input sql query and output result set in table types

  Answered 132 views 11 comments 0 points Most recent by Mark D Powell Jul 26, 2018 12:26PMPL/SQL (MOSC)
• How to spool sql result into a file

  Answered ✓ 66 views 3 comments 0 points Most recent by Mark D Powell Jun 12, 2018 2:55PMPL/SQL (MOSC)
• Oracle SQL Query Slow IO Slave Wait

  Answered 147 views 3 comments 0 points Most recent by Mahesh Pednekar Jun 7, 2017 6:16AMPL/SQL (MOSC)
• Underlying SQL query from EMCLI

  Answered ✓ 208 views 2 comments 0 points Most recent by Pandora's Actor Mar 22, 2017 4:46PMEnterprise Manager Generic (MOSC)