plsql

Discussion List

• 
  How to convert RECORD type parameter to XML or json in oracle?

  Responded But No Solution user8326781 103 views 7 comments 0 points Most recent by user8326781 Jun 18, 2021 3:54PMSQL & PL/SQL
• 
  How to write code efficiently

  Responded But No Solution User_R4VJD 61 views 6 comments 0 points Most recent by BluShadow Jun 16, 2021 2:22PMSQL & PL/SQL
• 
  Current & History data maintaining in oracle

  Responded But No Solution rock_1986 21 views 1 comment 0 points Most recent by User_H3J7U Jun 16, 2021 5:45AMSQL & PL/SQL
• 
  Inserting data after validation

  Question User_4LC0G 51 views 8 comments 0 points Most recent by BluShadow Jun 15, 2021 9:26AMSQL & PL/SQL
• 
  Is there any further option to optimize the loop session

  Solution Accepted SHANOJ 31 views 1 comment 0 points Most recent by jflack Jun 11, 2021 7:55PMSQL & PL/SQL
• 
  Sql Query to display MIN and MAX of Date column

  Solution Accepted User_X9S6M 51 views 3 comments 0 points Most recent by Frank Kulash Jun 11, 2021 4:38PMSQL & PL/SQL
• 
  Oracle APEX Download PL/SQL Sub Region

  Stephane Baribeau 16 views 3 comments 0 points Most recent by Stephane Baribeau Jun 11, 2021 12:13AMAPEX Discussions
• 
  comparing Last create date with sysdate

  Responded But No Solution User_R4VJD 41 views 7 comments 0 points Most recent by Frank Kulash Jun 10, 2021 2:50PMSQL & PL/SQL
• 
  comparing date's

  Responded But No Solution User_R4VJD 31 views 5 comments 0 points Most recent by EdStevens Jun 10, 2021 12:54PMSQL & PL/SQL
• 
  calculate average/min and max on calculated values.

  Solution Accepted zn553 41 views 11 comments 0 points Most recent by Frank Kulash Jun 10, 2021 12:29PMSQL & PL/SQL
• 
  Query tuning

  Responded But No Solution User_R4VJD 21 views 1 comment 0 points Most recent by Frank Kulash Jun 9, 2021 10:30PMSQL & PL/SQL
• 
  Event-Based Jobs

  Responded But No Solution User_3UMC3 31 views 4 comments 0 points Most recent by User_3UMC3 Jun 8, 2021 6:19AMSQL & PL/SQL
• 
  Compare report generation date with sysdate

  Solution Accepted User_R4VJD 22 views 3 comments 0 points Most recent by User_R4VJD Jun 7, 2021 7:16PMSQL & PL/SQL
• 
  timestamp difference precision and dbms_output.put_line format.

  Solution Accepted zn553 31 views 3 comments 0 points Most recent by BluShadow Jun 7, 2021 11:05AMSQL & PL/SQL
• 
  Query to display distinct rows based on Key columns

  User_X9S6M 35 views 3 comments 0 points Most recent by User_X9S6M Jun 6, 2021 8:10AMSQL Developer
• 
  How to use JSON-like Objects in PLSQL - APEX 19.2

  Solution Accepted Mike Mc 21 views 2 comments 0 points Most recent by Mike Mc Jun 4, 2021 1:09PMAPEX Discussions
• 
  add a column to query with difference of time between two date columns.

  Solution Accepted zn553 13 views 2 comments 0 points Most recent by Frank Kulash Jun 2, 2021 2:18PMSQL & PL/SQL
• 
  SQL Logic for using LIKE condition based First keyword of a column value with another table

  Responded But No Solution Rama0830 21 views 4 comments 0 points Most recent by User_H3J7U Jun 2, 2021 7:39AMSQL & PL/SQL
• 
  SQL Logic for using LIKE condition based on column values of another table

  Solution Accepted Rama0830 82 views 13 comments 0 points Most recent by Rama0830 Jun 1, 2021 11:27PMSQL & PL/SQL
• 
  How to find out difference between two time of the same day

  Solution Accepted User_8CW5L 52 views 6 comments 0 points Most recent by User_8CW5L May 30, 2021 5:31AMSQL & PL/SQL
• 
  Can we rollback before job changes if anyhow job fails?

  Responded But No Solution User_6RR94 22 views 1 comment 0 points Most recent by Billy Verreynne May 28, 2021 5:37AMSQL & PL/SQL
• 
  Oracle SQL Subtract columns with case condition in Apex IG

  Responded But No Solution Vinipanda 11 views 1 comment 0 points Most recent by Frank Kulash May 26, 2021 3:55PMSQL & PL/SQL
• 
  PLSQL - How to store multiple values into a variable and return those stored values

  Solution Accepted Jasper Tanglib 466 views 4 comments 0 points Most recent by Solomon Yakobson May 25, 2021 11:51AMSQL & PL/SQL
• 
  query tuning from secs to ms

  Responded But No Solution Kedar Barde 21 views 2 comments 0 points Most recent by Kedar Barde May 23, 2021 11:58AMSQL & PL/SQL