sql

Discussion List

• 
  Inserting With Clause

  Solution Accepted User_0SFG1 72 views 2 comments 0 points Most recent by BEDE August 2020SQL & PL/SQL
• 
  Create view with calculation of using aggregrate function in Oracle

  Solution Accepted user12251389 91 views 4 comments 2 points Most recent by user12251389 August 2020SQL & PL/SQL
• 
  Query to get desire Output

  Responded But No Solution user11691341 287 views 11 comments 1 point Most recent by jaramill July 2020SQL & PL/SQL
• 
  Semicolon gives error

  Responded But No Solution jflack 43 views 2 comments 0 points Most recent by L. Fernigrini July 2020SQL & PL/SQL
• 
  Regexp_substr-Double quotes in param

  Responded But No Solution 959406 38 views 4 comments 0 points Most recent by Tubby July 2020SQL & PL/SQL
• 
  Split specific value in a column which is delimited by a special symbol

  Responded But No Solution shuvro 168 views 15 comments 2 points Most recent by mathguy July 2020SQL & PL/SQL
• 
  N before string literals in query causing performance issue

  Solution Accepted Vikram Shelke 218 views 6 comments 1 point Most recent by Vikram Shelke July 2020SQL & PL/SQL
• 
  Export database

  Responded But No Solution mihaelhorus 158 views 4 comments 0 points Most recent by Mike Kutz July 2020SQL Developer
• 
  unpivot multiple columns dynamically

  Responded But No Solution user9229402 628 views 5 comments 0 points Most recent by BluShadow July 2020SQL & PL/SQL
• 
  number data inserting problem using python django

  Responded But No Solution 3404453 67 views 8 comments 1 point Most recent by Stefan Jager July 2020General Database Discussions
• 
  Count days excluding weekends.

  Responded But No Solution User_5F8TP 123 views 9 comments 2 points Most recent by User_5F8TP July 2020SQL & PL/SQL
• 
  Is there an efficient way to update and insert records without loop?

  Responded But No Solution Kinjan Bhavsar 143 views 5 comments 0 points Most recent by Kinjan Bhavsar July 2020SQL & PL/SQL
• 
  List BLOB and CLOB columns and their counts

  Responded But No Solution Julaayi 161 views 12 comments 2 points Most recent by Paulzip June 2020SQL & PL/SQL
• 
  select and if

  Responded But No Solution ömer faruk akyüzlü 154 views 12 comments 1 point Most recent by jaramill June 2020SQL & PL/SQL
• 
  Copying rows with an updated value

  Solution Accepted BeefStu 84 views 4 comments 1 point Most recent by BeefStu June 2020SQL & PL/SQL
• 
  Group the values and get the avg value top dec

  Solution Accepted User_7PZDE 52 views 4 comments 1 point Most recent by User_7PZDE June 2020SQL & PL/SQL
• 
  Count the values using hierarchy

  Responded But No Solution User_7PZDE 86 views 7 comments 2 points Most recent by User_7PZDE June 2020SQL & PL/SQL
• 
  Help modifying a CTE query

  Solution Accepted BeefStu 198 views 19 comments 4 points Most recent by BeefStu June 2020SQL & PL/SQL
• 
  How to combine two json_object from different tables in one json?

  Responded But No Solution Kinjan Bhavsar 207 views 18 comments 0 points Most recent by Kinjan Bhavsar June 2020SQL & PL/SQL
• 
  Parallel hint for queries

  Responded But No Solution Robert_D. 57 views 2 comments 0 points Most recent by Tubby June 2020SQL & PL/SQL
• 
  Insert into table when row not exist else update table using Oracle SQL

  Responded But No Solution user12251389 115 views 6 comments 0 points Most recent by user12251389 June 2020SQL & PL/SQL
• 
  How to exclude values from the previous records?

  Responded But No Solution User_5F8TP 213 views 22 comments 3 points Most recent by User_5F8TP June 2020SQL & PL/SQL
• 
  How to combine/concat two or more rows in a single json object in SQL?

  Solution Accepted Kinjan Bhavsar 216 views 4 comments 1 point Most recent by Kinjan Bhavsar June 2020SQL & PL/SQL
• 
  Execute Immediate that is causing the "too many rows" error

  Solution Accepted Roxy rollers 43 views 2 comments 1 point Most recent by Paulzip June 2020SQL & PL/SQL
• 
  How to get current user_id in Oracle Apex

  Solution Accepted Pav1 173 views 4 comments 0 points Most recent by Mike Kutz June 2020APEX Discussions