sql

Discussion List

• 
  Convert data into columns

  Responded But No Solution SHAJ_SHAJIN 81 views 9 comments 0 points Most recent by SHAJ_SHAJIN Dec 26, 2022 4:54PMSQL & PL/SQL
• 
  Not all privileges added to role

  Responded But No Solution user545194 91 views 11 comments 0 points Most recent by Solomon Yakobson Dec 25, 2022 3:49PMSQL & PL/SQL
• 
  Copy column data from backup table

  Responded But No Solution User_K8JYR 41 views 3 comments 0 points Most recent by User_3ABCE Dec 23, 2022 11:55AMSQL & PL/SQL
• 
  Compare two listagg and results difference only

  Solution Accepted Rengudi 61 views 5 comments 0 points Most recent by User_3ABCE Dec 23, 2022 4:54AMSQL & PL/SQL
• 
  STRING COMPARISON POSITIONAL Differences

  Solution Accepted Rengudi 191 views 16 comments 0 points Most recent by mathguy Dec 22, 2022 5:16PMSQL & PL/SQL
• 
  Do not count duplicate values in SQL

  Responded But No Solution Closed Bjornlaat 61 views 4 comments 0 points Most recent by Frank Kulash Dec 22, 2022 2:02PMSQL & PL/SQL
• 
  To concatenate columns

  Solution Accepted User910243567 41 views 1 comment 0 points Most recent by Stax Dec 22, 2022 10:17AMSQL & PL/SQL
• 
  Date column is showing up empty on the report even though it is able to show results when I run it o

  Responded But No Solution Sunny-Oracle 11 views 2 comments 0 points Most recent by Stax Dec 22, 2022 8:12AMAPEX Discussions
• 
  Adding a String to middle of string.

  Solution Accepted AnishRV 61 views 4 comments 0 points Most recent by mathguy Dec 21, 2022 5:40PMSQL & PL/SQL
• 
  Recieving error: ORA-00937: not a single-group group function

  Responded But No Solution User_M4XGB 21 views 2 comments 0 points Most recent by Sylvain Martel Dec 20, 2022 10:27PMAPEX Discussions
• 
  How to change report via radio group in Oracle APEX using if statement

  Responded But No Solution User_M4XGB 21 views 3 comments 0 points Most recent by Sylvain Martel Dec 20, 2022 7:59PMAPEX Discussions
• 
  Need help on Round() function to skip last 2 values

  Solution Accepted User_X9S6M 121 views 12 comments 0 points Most recent by BluShadow Dec 20, 2022 12:03PMSQL & PL/SQL
• 
  Bind parameter value not returning result

  Question user545194 11 views 0 comments 0 points Started by user545194 Dec 19, 2022 10:14AM Node.js
• 
  How to convert comma seperated values from multiple colums.

  Solution Accepted SHAJ_SHAJIN 71 views 7 comments 0 points Most recent by Solomon Yakobson Dec 18, 2022 5:21PMSQL & PL/SQL
• 
  Use of REF in table

  Solution Accepted User_V7K1D 101 views 14 comments 0 points Most recent by Solomon Yakobson Dec 18, 2022 12:39PMGeneral Database Discussions
• 
  numeric or value error on update statement

  Solution Accepted SHAJ_SHAJIN 31 views 2 comments 0 points Most recent by SHAJ_SHAJIN Dec 17, 2022 9:31AMSQL & PL/SQL
• 
  SYS_CONNECT_BY_PATH results to individual rows.

  Solution Accepted Rengudi 71 views 7 comments 0 points Most recent by mathguy Dec 16, 2022 12:34AMSQL & PL/SQL
• 
  Help with aggregated discounts

  Solution Accepted User_UBC84 91 views 12 comments 0 points Most recent by mathguy Dec 15, 2022 3:23PMSQL & PL/SQL
• 
  SQL query to return name and balance of all users having balance greater than 10000

  Solution Accepted User_X9S6M 61 views 4 comments 0 points Most recent by Solomon Yakobson Dec 15, 2022 12:08PMSQL & PL/SQL
• 
  Prevent percent Calculation from going over 100 %

  Solution Accepted mlov83 101 views 10 comments 0 points Most recent by BluShadow Dec 15, 2022 8:35AMSQL & PL/SQL
• 
  Need help on substr fucntion

  Solution Accepted User_X9S6M 31 views 2 comments 0 points Most recent by User_X9S6M Dec 15, 2022 3:38AMSQL & PL/SQL
• 
  Trying to re-write a ready made not so easy query

  Responded But No Solution User_HAI8X 21 views 1 comment 0 points Most recent by Solomon Yakobson Dec 14, 2022 8:49PMGeneral Database Discussions
• 
  Regex slow

  Solution Accepted af_2017 171 views 11 comments 0 points Most recent by Sven W. Dec 14, 2022 8:47AMSQL & PL/SQL