plsql

Discussion List

• 
  Is there any further option to optimize the loop session

  Solution Accepted SHANOJ 23 views 1 comment 0 points Most recent by jflack June 11SQL & PL/SQL
• 
  Sql Query to display MIN and MAX of Date column

  Solution Accepted User_X9S6M 30 views 3 comments 0 points Most recent by Frank Kulash June 11SQL & PL/SQL
• 
  Oracle APEX Download PL/SQL Sub Region

  Stephane Baribeau 11 views 3 comments 0 points Most recent by Stephane Baribeau June 11APEX Discussions
• 
  Issue with calling ORDS REST API with JSON input, from an external REST client

  Solution Accepted User_KJA7V 12 views 2 comments 0 points Most recent by User_KJA7V June 10ORDS, SODA & JSON in the Database
• 
  comparing Last create date with sysdate

  Responded But No Solution User_R4VJD 42 views 7 comments 0 points Most recent by Frank Kulash June 10SQL & PL/SQL
• 
  comparing date's

  Responded But No Solution User_R4VJD 39 views 5 comments 0 points Most recent by EdStevens June 10SQL & PL/SQL
• 
  calculate average/min and max on calculated values.

  Solution Accepted zn553 40 views 11 comments 0 points Most recent by Frank Kulash June 10SQL & PL/SQL
• 
  Query tuning

  Responded But No Solution User_R4VJD 24 views 1 comment 0 points Most recent by Frank Kulash June 9SQL & PL/SQL
• 
  Event-Based Jobs

  Responded But No Solution User_3UMC3 29 views 4 comments 0 points Most recent by User_3UMC3 June 8SQL & PL/SQL
• 
  Compare report generation date with sysdate

  Solution Accepted User_R4VJD 24 views 3 comments 0 points Most recent by User_R4VJD June 7SQL & PL/SQL
• 
  timestamp difference precision and dbms_output.put_line format.

  Solution Accepted zn553 30 views 3 comments 0 points Most recent by BluShadow June 7SQL & PL/SQL
• 
  Query to display distinct rows based on Key columns

  User_X9S6M 22 views 3 comments 0 points Most recent by User_X9S6M June 6SQL Developer
• 
  How to use JSON-like Objects in PLSQL - APEX 19.2

  Responded But No Solution Mike Mc 14 views 2 comments 0 points Most recent by Mike Mc June 4APEX Discussions
• 
  add a column to query with difference of time between two date columns.

  Solution Accepted zn553 16 views 2 comments 0 points Most recent by Frank Kulash June 2SQL & PL/SQL
• 
  SQL Logic for using LIKE condition based First keyword of a column value with another table

  Responded But No Solution Rama0830 22 views 4 comments 0 points Most recent by User_H3J7U June 2SQL & 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 June 1SQL & PL/SQL
• 
  How to find out difference between two time of the same day

  Solution Accepted User_8CW5L 48 views 6 comments 0 points Most recent by User_8CW5L May 30SQL & PL/SQL
• 
  Oracle Data Miner functionality/ Machine Learning/ Data Mining

  Responded But No Solution User_PUHRJ 53 views 4 comments 0 points Most recent by User_C84TD May 28SQL Developer
• 
  Can we rollback before job changes if anyhow job fails?

  Responded But No Solution User_6RR94 21 views 1 comment 0 points Most recent by Billy Verreynne May 28SQL & 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 26SQL & PL/SQL
• 
  PLSQL - How to store multiple values into a variable and return those stored values

  Responded But No Solution Jasper Tanglib 36 views 4 comments 0 points Most recent by Solomon Yakobson May 25SQL & PL/SQL
• 
  query tuning from secs to ms

  Responded But No Solution Kedar Barde 24 views 2 comments 0 points Most recent by Kedar Barde May 23SQL & PL/SQL
• 
  sqlloader error

  Responded But No Solution chandra_1986 28 views 6 comments 0 points Most recent by James Su May 21SQL & PL/SQL
• 
  Question relative to optimisation

  Responded But No Solution Stephane Baribeau 14 views 1 comment 0 points Most recent by Paulzip May 21SQL & PL/SQL