sql

Discussion List

• 
  Include prior rows if the end date from prior rows is greater than current row start date.

  Solution Accepted mlov83 21 views 2 comments 0 points Most recent by mlov83 November 2020SQL & PL/SQL
• 
  How can I reset the value of a sequence ?

  Responded But No Solution simon87 41 views 8 comments 0 points Most recent by EdStevens-OC November 2020General Database Discussions
• 
  How to handles daylight saving time change

  Solution Accepted 0614 51 views 9 comments 0 points Most recent by mathguy November 2020SQL & PL/SQL
• 
  How to import a HTML version of an AWR into an Oracle Database?

  Solution Accepted User_M4H2K 22 views 4 comments 0 points Most recent by User_M4H2K November 2020General Database Discussions
• 
  SQL to oracle procedure conversion using outer apply

  Responded But No Solution User_BQO8T 21 views 1 comment 0 points Most recent by InoL November 2020APEX Discussions
• 
  How to dynamically transpose data into with changing column headers with or without pivot/pivot xml?

  Responded But No Solution Vinipanda 41 views 3 comments 0 points Most recent by Frank Kulash November 2020SQL & PL/SQL
• 
  Disabling default constraint in a table is possible?

  Responded But No Solution Lokesh A 32 views 2 comments 0 points Most recent by Paulzip November 2020SQL & PL/SQL
• 
  External table reading JSON with objects in array

  Solution Accepted User_33FMV 45 views 3 comments 0 points Most recent by User_33FMV November 2020SQL & PL/SQL
• 
  Select Distinct

  Responded But No Solution user9311128 61 views 14 comments 0 points Most recent by mathguy November 2020SQL & PL/SQL
• 
  Options for simulating conditional row_number()

  Solution Accepted User_33FMV 41 views 10 comments 0 points Most recent by Paulzip November 2020SQL & PL/SQL
• 
  table refresh process - discuss options

  Responded But No Solution tparvaiz 41 views 6 comments 0 points Most recent by Jason_(A_Non) November 2020SQL & PL/SQL
• 
  List of members who have access to a Database

  Responded But No Solution Bindu K 41 views 6 comments 0 points Most recent by BEDE November 2020SQL & PL/SQL
• 
  Number's combination from a provided list

  Filipe RB 61 views 12 comments 0 points Most recent by James Su November 2020SQL & PL/SQL
• 
  Set value on dialog closed, when X button is pressed

  Solution Accepted Pav1 11 views 2 comments 0 points Most recent by Pav1 November 2020APEX Discussions
• 
  Oracle how to classify time series ?

  Responded But No Solution PAN KEVIN 31 views 2 comments 0 points Most recent by PAN KEVIN November 2020SQL & PL/SQL
• 
  Check Constraint to validate the date

  Solution Accepted user9311128 53 views 9 comments 0 points Most recent by mathguy November 2020SQL & PL/SQL
• 
  Analytical formula to persist and aggregate data .

  Solution Accepted Mr.Jondee 31 views 8 comments 0 points Most recent by Frank Kulash November 2020SQL & PL/SQL
• 
  Oracle how to classify time series

  PAN KEVIN 1 view 0 comments 0 points Started by PAN KEVIN November 2020 SQL & PL/SQL
• 
  Handle ORA-01848: day of year must be between 1 and 365 (366 for leap year) in case condition

  Solution Accepted user12251389 152 views 13 comments 0 points Most recent by mathguy November 2020SQL & PL/SQL
• 
  deletion of records older then 90 days

  Responded But No Solution chandra_1986 82 views 13 comments 0 points Most recent by chandra_1986 November 2020SQL & PL/SQL
• 
  merge not working inside a proc

  Responded But No Solution User_LWA15 11 views 4 comments 0 points Most recent by Frank Kulash November 2020SQL & PL/SQL
• 
  Need help with an SQL Query

  Solution Accepted Vikronium 21 views 5 comments 0 points Most recent by Paulzip November 2020SQL & PL/SQL
• 
  Item id to item code conversion with - delimeter

  Solution Accepted Kaushik D 22 views 4 comments 0 points Most recent by mathguy November 2020SQL & PL/SQL