sql

Discussion List

• 
  How to roll up rows and assign a value based upon rules

  Responded But No Solution User_SSU26 41 views 6 comments 0 points Most recent by Frank Kulash Mar 11, 2022 3:28PMSQL & PL/SQL
• 
  Calculating difference in timestamps for working hours

  Solution Accepted User_G3NSO 32 views 4 comments 0 points Most recent by Frank Kulash Mar 11, 2022 4:11AMSQL & PL/SQL
• 
  sample tnsnames entry for XE

  Responded But No Solution User_ZUZ6N 12 views 1 comment 0 points Most recent by L. Fernigrini Mar 9, 2022 7:46PMOracle Database Express Edition (XE)
• 
  Need to write query

  Solution Accepted PV5253 81 views 6 comments 0 points Most recent by Frank Kulash Mar 9, 2022 7:35PMSQL & PL/SQL
• 
  Is it possible to use a column to access a json?

  Solution Accepted Edisson Gabriel López 23 views 3 comments 0 points Most recent by User_H3J7U Mar 9, 2022 4:53PMORDS, SODA & JSON in the Database
• 
  What is the alternative for 'for loop' ?

  Responded But No Solution kalyan vedagiri 268 views 9 comments 0 points Most recent by User_CCS94 Mar 8, 2022 10:57PMSQL & PL/SQL
• 
  Issue with TIMESTAMP(0)

  Solution Accepted manojthakurii 293 views 10 comments 0 points Most recent by manojthakurii Mar 8, 2022 9:18AMSQL & PL/SQL
• 
  how to combine two JSON array list into single array list

  Responded But No Solution Kannan Sekar 198 views 11 comments 0 points Most recent by Solomon Yakobson Mar 6, 2022 12:09PMSQL & PL/SQL
• 
  Multi relationship and depth chart.

  Newbie_apex07 72 views 4 comments 0 points Most recent by Newbie_apex07 Mar 3, 2022 4:54PMAPEX Discussions
• 
  No data in XLS or PDF format of Report generated in BIP. There is data only in CSV format.

  Responded But No Solution User_TYVZT 11 views 8 comments 0 points Most recent by Christian Pitet Mar 2, 2022 8:47AMAPEX Discussions
• 
  Materialized view with Union - refresh on commit

  Solution Accepted Newbie_apex07 41 views 6 comments 0 points Most recent by Jonathan Lewis Mar 1, 2022 4:45PMSQL & PL/SQL
• 
  SQL Marco Function - Passing a list for "WHERE IN" Clause - Bug or DESIGN

  Responded But No Solution user552932 42 views 6 comments 0 points Most recent by BluShadow Mar 1, 2022 3:57PMSQL & PL/SQL
• 
  How to get particular sub-string from a string

  Solution Accepted Bikram 31 views 3 comments 0 points Most recent by BluShadow Mar 1, 2022 12:26PMSQL & PL/SQL
• 
  New release: 21.4.0 - featuring PL/SQL debugger and enhanced intellisense

  Announcement Closed Christian.Shay -Oracle 182 views 0 comments 0 points Started by Christian.Shay -Oracle Mar 1, 2022 5:57AM Oracle Developer Tools for VS Code
• 
  Execute Immediate on apex_string.format()

  Responded But No Solution Jasper Tanglib 34 views 3 comments 0 points Most recent by fac586 Feb 28, 2022 8:18PMAPEX Discussions
• 
  Need to write update statement

  Solution Accepted PV5253 31 views 9 comments 0 points Most recent by PV5253 Feb 27, 2022 5:14PMSQL & PL/SQL
• 
  Need to write sql query

  Solution Accepted PV5253 51 views 5 comments 0 points Most recent by PV5253 Feb 27, 2022 2:04PMSQL & PL/SQL
• 
  Why does a SQL id show up in only some of the performance views

  Responded But No Solution rjsosi 32 views 5 comments 0 points Most recent by rjsosi Feb 24, 2022 10:54PMSQL & PL/SQL
• 
  How can provide the user options inside procedure ?

  Solution Accepted User_OMA69 31 views 2 comments 0 points Most recent by Billy Verreynne Feb 24, 2022 12:56PMSQL & PL/SQL
• 
  how to take input from user in pl sql procedure ?

  Responded But No Solution User_OMA69 1.1K views 8 comments 0 points Most recent by Billy Verreynne Feb 23, 2022 8:20AMSQL & PL/SQL
• 
  How to check if a procedure is currently running with a specific parameter

  Solution Accepted rjsosi 201 views 14 comments 0 points Most recent by rjsosi Feb 22, 2022 10:57PMSQL & PL/SQL
• 
  parsing multi-select values with apex_string.split

  Responded But No Solution Mr.Peabody 78 views 2 comments 0 points Most recent by Mr.Peabody Feb 22, 2022 4:22AMAPEX Discussions
• 
  How to replace special characters with default value in table column

  Solution Accepted User_58ED4 71 views 5 comments 0 points Most recent by Frank Kulash Feb 21, 2022 11:08AMSQL & PL/SQL
• 
  Last 5 day , 10 day Bucket

  Responded But No Solution User_7C1YX 41 views 5 comments 0 points Most recent by CarlosDLG Feb 18, 2022 4:25PMSQL & PL/SQL