sql

Discussion List

• 
  How to find the data type of data in variable

  Responded But No Solution Bommi 86 views 11 comments 0 points Most recent by EdStevens Mar 31, 2022 2:58PMSQL & PL/SQL
• 
  SQL Output Conditionally

  Responded But No Solution 689245 52 views 7 comments 0 points Most recent by 689245 Mar 29, 2022 11:34AMSQL & PL/SQL
• 
  Masking data mutes error on update

  Solution Accepted BeefStu 21 views 2 comments 0 points Most recent by BeefStu Mar 26, 2022 8:52PMSQL & PL/SQL
• 
  How to to insert two records for the new entry into the same column using triggers

  Responded But No Solution Albert Chao 42 views 6 comments 0 points Most recent by EdStevens Mar 26, 2022 12:40PMSQL & PL/SQL
• 
  Trigger creation when table is altered but there will same e_id where updation or deletion will happ

  Solution Accepted Albert Chao 31 views 6 comments 0 points Most recent by Albert Chao Mar 26, 2022 5:57AMSQL & PL/SQL
• 
  Getting repeated values when using LISTAGG even for single field

  Solution Accepted Albert Chao 51 views 8 comments 0 points Most recent by Frank Kulash Mar 24, 2022 1:14AMSQL & PL/SQL
• 
  Can I make 'Total' Row and 'Total' Column Bold?

  Responded But No Solution SannaN-Oracle 12 views 1 comment 0 points Most recent by TexasApexDeveloper Mar 23, 2022 7:25PMAPEX Discussions
• 
  trouble resolving an ORA-01790: expression must have same datatype as corresponding expression error

  Responded But No Solution User_KC6Y3 17 views 1 comment 0 points Most recent by Solomon Yakobson Mar 23, 2022 3:30PMSQL Developer
• 
  Finding words with 2 or more vowels

  Solution Accepted User_G3NSO 42 views 4 comments 0 points Most recent by BluShadow Mar 23, 2022 8:41AMSQL & PL/SQL
• 
  count based on certain condition

  Solution Accepted Devx 52 views 10 comments 0 points Most recent by Solomon Yakobson Mar 22, 2022 6:38PMSQL & PL/SQL
• 
  Getting not a group by expression while using listagg function

  Solution Accepted Albert Chao 65 views 3 comments 0 points Most recent by Frank Kulash Mar 21, 2022 5:00PMSQL & PL/SQL
• 
  ORA-00933: SQL command not properly ended Error on Apex

  Responded But No Solution SannaN-Oracle 21 views 6 comments 0 points Most recent by Alex Nuijten Mar 21, 2022 1:33PMSQL & PL/SQL
• 
  Can OAUTH2 be used to Authenticate ORDS REST Enabled SQL?

  Responded But No Solution User_T2LL6 25 views 3 comments 0 points Most recent by Paavo Mar 21, 2022 9:53AMORDS, SODA & JSON in the Database
• 
  How to create a 'total' row in SQL on Oracle Apex

  Responded But No Solution User_ALXXJ 24 views 2 comments 0 points Most recent by SteveQuinlivan Mar 18, 2022 6:29PMAPEX Discussions
• 
  help

  Solution Accepted hemant_k 31 views 4 comments 0 points Most recent by Hub Tijhuis Mar 18, 2022 3:43PMSQL & PL/SQL
• 
  ORA-00933: SQL command not properly ended Error on APEX

  Responded But No Solution SannaN-Oracle 22 views 3 comments 0 points Most recent by InoL Mar 17, 2022 6:14PMAPEX Discussions
• 
  condition check will filtering in query

  Solution Accepted User_7PZDE 61 views 6 comments 0 points Most recent by Solomon Yakobson Mar 16, 2022 4:29PMSQL & PL/SQL
• 
  How to MERGE data into the target table based on certain conditions . Need to group by sequence and

  Solution Accepted Albert Chao 43 views 4 comments 0 points Most recent by Frank Kulash Mar 14, 2022 3:22PMSQL & PL/SQL
• 
  Need to generate CREATE TABLE scripts and INSERT scripts in order

  Responded But No Solution Albert Chao 85 views 11 comments 0 points Most recent by EdStevens Mar 14, 2022 2:03PMSQL & PL/SQL
• 
  Reset sequence to last used value

  Solution Accepted user13117585 52 views 4 comments 0 points Most recent by Jonathan Lewis Mar 13, 2022 11:22AMSQL & PL/SQL
• 
  How to generate the xml (group of tags) with multiple times??

  Solution Accepted User_8849S 13 views 3 comments 0 points Most recent by cormaco Mar 12, 2022 1:00PMGeneral XML
• 
  How to parse the value from xmlns?

  Solution Accepted User_8849S 12 views 3 comments 0 points Most recent by User_8849S Mar 12, 2022 5:55AMPL/SQL XML Programming
• 
  Delete a large amount of data on Partition

  Responded But No Solution User_SWR12 21 views 3 comments 0 points Most recent by Solomon Yakobson Mar 11, 2022 11:24PMSQL Developer