sql

Discussion List

• 
  How to covert column names into rows in SQL?

  Responded But No Solution User_CK8A6 71 views 9 comments 0 points Most recent by Frank Kulash Nov 29, 2022 2:55PMSQL & PL/SQL
• 
  Issue with Ordering rows after UNPIVOT columns to rows

  Solution Accepted Roxy rollers 31 views 3 comments 0 points Most recent by Roxy rollers Nov 28, 2022 7:41PMSQL & PL/SQL
• 
  Using a database link in dynamic sql

  Solution Accepted user545194 32 views 2 comments 0 points Most recent by user545194 Nov 28, 2022 11:33AMSQL & PL/SQL
• 
  Select Into VS Cursor

  Solution Accepted Paulo A. Künzel 115 views 6 comments 0 points Most recent by User_3ABCE Nov 28, 2022 5:49AMSQL & PL/SQL
• 
  How can I populate missing values in a balance sheet?

  Solution Accepted User_ZR3PE 83 views 10 comments 0 points Most recent by Frank Kulash Nov 27, 2022 6:28PMSQL & PL/SQL
• 
  Alias a function

  Solution Accepted Pugzly 61 views 6 comments 0 points Most recent by Solomon Yakobson Nov 26, 2022 11:57AMSQL & PL/SQL
• 
  When we should use Scaler subquery and how it works

  Solution Accepted Bikram 72 views 6 comments 0 points Most recent by Solomon Yakobson Nov 26, 2022 11:43AMSQL & PL/SQL
• 
  Need suggestion on developing a real time projects in SQL and PL/SQL only

  Solution Accepted Albert Chao 135 views 7 comments 0 points Most recent by User_U0DGH Nov 26, 2022 7:45AMSQL & PL/SQL
• 
  Oracle SQL Practice Platform

  Solution Accepted Bikram 52 views 3 comments 0 points Most recent by BluShadow Nov 25, 2022 2:12PMSQL & PL/SQL
• 
  SELECT DBMS_METADATA.GET_DDL without storage and constraints

  Responded But No Solution user545194 115 views 4 comments 0 points Most recent by Sven W. Nov 24, 2022 9:13AMSQL & PL/SQL
• 
  Need help with Query

  Solution Accepted User910243567 71 views 4 comments 0 points Most recent by Frank Kulash Nov 23, 2022 10:26PMSQL & PL/SQL
• 
  ORA_ROWSCN - High Response time - Regarding

  Responded But No Solution Rengudi 61 views 4 comments 0 points Most recent by Rengudi Nov 23, 2022 6:35AMSQL & PL/SQL
• 
  SQL Update command send me "ORA-00903: invalid table name" error

  Responded But No Solution Jean-Baptiste Marotte 61 views 3 comments 0 points Most recent by Jean-Baptiste Marotte Nov 22, 2022 12:49PMSQL & PL/SQL
• 
  Miss Punch in Information Query

  Solution Accepted M.bro 82 views 5 comments 0 points Most recent by Frank Kulash Nov 21, 2022 11:50AMSQL & PL/SQL
• 
  How to identify correlated subquery and what is the replacement of it

  Solution Accepted Bikram 56 views 3 comments 0 points Most recent by Bikram Nov 21, 2022 4:12AMSQL & PL/SQL
• 
  Trying to convert multiple rows for a given id to a json table

  Responded But No Solution Brian___B 337 views 17 comments 0 points Most recent by Brian___B Nov 18, 2022 6:23PMGeneral Database Discussions
• 
  Extract scripts using VS Code

  Responded But No Solution Paulo A. Künzel 52 views 2 comments 0 points Most recent by thatJeffSmith-Oracle Nov 18, 2022 4:30PMSQL & PL/SQL
• 
  Need to have sequence number for rows based on a custom logic.

  Responded But No Solution User_XY6RS 81 views 9 comments 0 points Most recent by mathguy Nov 18, 2022 3:05PMSQL & PL/SQL
• 
  How can I make a conditional report in Oracle APEX?

  Responded But No Solution Edisson Gabriel López 187 views 2 comments 0 points Most recent by User_8LEFJ Nov 18, 2022 7:02AMAPEX Discussions
• 
  Generate Dynamic WHERE clause condition

  Solution Accepted Rengudi 72 views 4 comments 0 points Most recent by Frank Kulash Nov 17, 2022 9:48PMSQL & PL/SQL
• 
  Adding grants to a role

  Responded But No Solution user545194 151 views 17 comments 0 points Most recent by user545194 Nov 17, 2022 10:20AMSQL & PL/SQL
• 
  Sync check with primary

  Solution Accepted Rengudi 61 views 4 comments 0 points Most recent by Rengudi Nov 17, 2022 7:53AMSQL & PL/SQL
• 
  How to get a record count for each file in a table?

  Solution Accepted User_DIL60 192 views 17 comments 0 points Most recent by User_DIL60 Nov 16, 2022 9:52PMSQL & PL/SQL
• 
  How to prepare Hierarchical Tree (Table) to JSON for D3-Charts

  Responded But No Solution Jegor Wieler 44 views 4 comments 0 points Most recent by Jegor Wieler Nov 16, 2022 2:34PMSQL & PL/SQL