sql

Discussion List

• 
  calculating business hours

  Responded But No Solution User_JZKI6 52 views 4 comments 0 points Most recent by User_5F1TM 7:46AMSQL & PL/SQL
• 
  Active records by max insert date

  Responded But No Solution User_DIL60 22 views 10 comments 0 points Most recent by Arif Khadas 7:01AMSQL & PL/SQL
• 
  Grouping, Sorting, And Counting

  Responded But No Solution User_MMW9K 6 views 1 comment 0 points Most recent by KayK 5:17AMSQL Developer
• 
  Convert IN to EXISTS.

  Solution Accepted User_DIL60 45 views 3 comments 0 points Most recent by User_DIL60 Oct 26, 2021 9:21PMSQL & PL/SQL
• 
  Finding all possible combinations of numbers to reach a given sum

  Responded But No Solution User_KI8KP 49 views 5 comments 0 points Most recent by mathguy Oct 26, 2021 7:46PMSQL & PL/SQL
• 
  Request for Query for Employee Attendance

  Solution Accepted User_8KQYD 17 views 2 comments 0 points Most recent by User_H3J7U Oct 25, 2021 7:18PMSQL & PL/SQL
• 
  Greatest/ Least function

  Responded But No Solution Dimpy 41 views 2 comments 0 points Most recent by Dimpy Oct 25, 2021 9:28AMSQL & PL/SQL
• 
  read&write server files from plsql code

  Responded But No Solution Gor_Mahia 78 views 11 comments 0 points Most recent by Mike Kutz Oct 25, 2021 12:04AMSQL & PL/SQL
• 
  SQLcl Production Build: 21.3.0.278.1045 throwing "WARNING: terminal cannot be created paused"

  Responded But No Solution User_206XM 29 views 1 comment 0 points Most recent by User_W45BH Oct 22, 2021 7:17AMSQLcl
• 
  SQL LOADER with less fields in data file.

  Responded But No Solution User_CS62G 27 views 3 comments 0 points Most recent by Warren Tolentino Oct 21, 2021 6:54PMSQL & PL/SQL
• 
  Help with aggregated discounts

  Responded But No Solution User_UBC84 49 views 9 comments 0 points Most recent by Solomon Yakobson Oct 20, 2021 1:13PMSQL & PL/SQL
• 
  How to use page items in report queries

  Responded But No Solution User_6L3S5 40 views 3 comments 0 points Most recent by Mike Kutz Oct 20, 2021 10:11AMAPEX Discussions
• 
  ORA-01489: result of string concatenation is too long for my insert statement.

  Responded But No Solution User_UOWPF 39 views 4 comments 0 points Most recent by EdStevens Oct 19, 2021 2:27PMSQL & PL/SQL
• 
  Oracle SQl Calendar

  Closed Dimpy 34 views 1 comment 0 points Most recent by Frank Kulash Oct 19, 2021 11:41AMSQL & PL/SQL
• 
  SQL Calendar query

  Solution Accepted Dimpy 62 views 3 comments 0 points Most recent by Frank Kulash Oct 19, 2021 10:56AMSQL & PL/SQL
• 
  create QUARTERLY LIST

  Solution Accepted Gor_Mahia 62 views 6 comments 0 points Most recent by User_H3J7U Oct 18, 2021 4:39AMSQL & PL/SQL
• 
  calculate billamount based on the conditions mentioned in the sheet

  Solution Accepted Siva ManU 113 views 16 comments 0 points Most recent by Solomon Yakobson Oct 17, 2021 10:17AMSQL & PL/SQL
• 
  Dropping an index on a partitioned table and then rebuilding it after a load.

  Responded But No Solution rjsosi 45 views 4 comments 0 points Most recent by rjsosi Oct 15, 2021 8:31PMSQL & PL/SQL
• 
  How to use json_transform to remove an array element at an unknown index?

  Solution Accepted bsamuel 28 views 2 comments 0 points Most recent by bsamuel Oct 15, 2021 3:08PMSQL & PL/SQL
• 
  Setting up oracle virtual machine with SQL source files

  Question User_85083 14 views 0 comments 0 points Started by User_85083 Oct 15, 2021 2:28PM Java Virtual Machine (JVM)
• 
  How can I remove the text and leave only the numbers?

  Solution Accepted Edisson Gabriel López 54 views 9 comments 0 points Most recent by Frank Kulash Oct 14, 2021 7:41PMSQL & PL/SQL
• 
  Table performance Issue(Huge table)

  Responded But No Solution User_AS6XD 29 views 4 comments 0 points Most recent by EdStevens Oct 14, 2021 2:27PMGeneral Database Discussions
• 
  getting 2nd recent batch

  Solution Accepted Sandy0594 63 views 9 comments 0 points Most recent by mathguy Oct 13, 2021 7:21PMSQL & PL/SQL
• 
  Open Region after Button submit

  Solution Accepted User_6L3S5 21 views 1 comment 0 points Most recent by Klostrie-Oracle Oct 13, 2021 7:38AMAPEX Discussions
• 
  Huge performance drop after upgrading from 12c o 19c

  Question user8740803 15 views 0 comments 0 points Started by user8740803 Oct 12, 2021 8:24PM Database Upgrade