Discussion List

• NOCOMPRESS appearing in oracle 19c for range partition

  Answered 11 views 5 comments 0 points Most recent by SureshMuddaveerappa Jun 22, 2021 2:42PM
• V$SESSMETRIC data unavailable inside PDB

  51 views 9 comments 0 points Most recent by SureshMuddaveerappa Jun 7, 2021 5:12PM
• Need SQL query to find all backup tables or old tables in database.

  Answered 211 views 5 comments 0 points Most recent by Mark D Powell Jun 2, 2021 6:05PM
• Grouping Of Dates

  Answered ✓ 11 views 20 comments 0 points Most recent by User_NNH9P Jun 1, 2021 7:27AM
• Getting "invalid identifier" error while inserting dynamic date value in table

  Answered 2 views 11 comments 0 points Most recent by Anurag Gupta May 27, 2021 5:29AM
• I need to SUM unique values from a table (get the distributed part payment to the invoice per PO)

  Question 1 view 0 comments 0 points Most recent by User_5111K May 14, 2021 6:43PM
• Trying to find an expression to bring in MAX assignment in a report.

  Answered 11 views 3 comments 0 points Most recent by J Reinhart May 14, 2021 11:46AM
• How to extract multiple hostname from a long string by using regexp_substr

  Answered 11 views 5 comments 0 points Most recent by user12001048 Apr 27, 2021 1:39AM
• How to find users accessing a table and from which servers

  Answered 1 view 6 comments 0 points Most recent by Mark D Powell Apr 20, 2021 5:02PM
• Unable to insert data

  21 views 2 comments 0 points Most recent by Mark D Powell Apr 12, 2021 5:04PM
• Greater than Zero values not retruned in PLSQL function

  11 views 4 comments 0 points Most recent by MLA Prakash Apr 1, 2021 10:11AM
• REGEXP_LIKE Negative Lookahead

  Answered 41 views 5 comments 0 points Most recent by EB-Developer Mar 26, 2021 12:08PM
• REGEXP_SUBSTR Conversion

  Answered 11 views 1 comment 0 points Most recent by Gaz in Oz Mar 22, 2021 2:12AM
• issue when MEDIAN and SUM used in combination

  11 views 1 comment 0 points Most recent by Kazuhiro Mar 21, 2021 1:58AM
• Passing back a simple value from sqlplus to shell script returns blank?

  Answered ✓ 11 views 10 comments 0 points Most recent by Mark D Powell Mar 16, 2021 6:30PM
• Oracle EBS users responsibility end date update

  Answered 645 views 2 comments 0 points Most recent by Mark D Powell Mar 16, 2021 5:57PM
• can't run procedure again after finished.

  Answered 11 views 7 comments 0 points Most recent by BPeaslandDBA Mar 11, 2021 3:46PM
• schedule run procedure (run twice in every day)

  Answered 11 views 4 comments 0 points Most recent by Gaz in Oz Mar 8, 2021 12:30AM
• Substract two timestamps and get result in days, hours, minutes

  Answered ✓ 11 views 2 comments 0 points Most recent by Ed Nienkemper Mar 1, 2021 2:13PM
• which table contains refund payment method column of a receipt?

  1 view 1 comment 0 points Most recent by Dona_1995 Mar 1, 2021 11:09AM
• which table contains refund payment method column of a receipt?

  1 view 0 comments 0 points Most recent by Dona_1995 Mar 1, 2021 9:32AM
• Compilation warning on create type

  11 views 8 comments 0 points Most recent by User_2VU7B Feb 22, 2021 1:50PM
• SQL query is not giving expected results when using NOT LIKE/LIKE operators

  21 views 5 comments 0 points Most recent by Kazuhiro Feb 16, 2021 8:57PM
• Different result from query TO_TIMESTAMP AT TIME ZONE ’UTC’ between Oracle 11g and Oracle 19c

  Answered 41 views 3 comments 0 points Most recent by Kazuhiro Feb 11, 2021 6:43AM
• I get sometimes ORA-08177 if I create DB-users parallel and select in SERIALIZABLE transaction

  Answered ✓ 301 views 8 comments 0 points Most recent by Mark D Powell Feb 10, 2021 3:56PM
• need to parse dates from a string

  Answered ✓ 11 views 6 comments 0 points Most recent by User_IF3GH Feb 9, 2021 8:38PM
• read data from excel file and schedule it.

  Answered 1 view 2 comments 0 points Most recent by GregV Feb 2, 2021 9:10PM
• Transpose Options in SQL

  Answered 1 view 1 comment 0 points Most recent by Mark D Powell Jan 29, 2021 7:56PM
• Unable to remove next line character in .lst file (data retrieved using sql query)

  Answered ✓ 11 views 5 comments 0 points Most recent by Ajay-fdle Jan 25, 2021 9:28PM
• Which table stores the requests parameters and users who ran a process in ORACLE Cloud

  Answered 751 views 3 comments 1 point Most recent by Celine MORLET Jan 11, 2021 3:58PM