sql

Discussion List

• 
  Error LPX-00245: extra data after end of document

  Solution Accepted daphne_121 216 views 11 comments 0 points Most recent by daphne_121 Oct 13, 2022 7:04PMSQL & PL/SQL
• 
  Need to Get Location Start Date Changed

  Responded But No Solution #Hussain 73 views 6 comments 0 points Most recent by mathguy Oct 13, 2022 2:28PMSQL & PL/SQL
• 
  Unable to replace/translate special characters in sql or pl/sql developer

  Responded But No Solution Vinipanda 81 views 6 comments 0 points Most recent by mathguy Oct 12, 2022 3:58PMSQL & PL/SQL
• 
  LISTAGG and PIVOT in 1 CTE ?

  Solution Accepted User_7C1YX 57 views 3 comments 0 points Most recent by User_7C1YX Oct 12, 2022 6:22AMSQL Developer
• 
  Ammo for Sale | Bulk 9mm Ammo 2000 rounds | Federal 9mm Ammo 1000 Rounds

  User_QHS55 101 views 0 comments 0 points Started by User_QHS55 Oct 12, 2022 3:14AM Database Connectivity Discussions
• 
  APEX Oracle not sacing changes to SQL Query

  Question User_NB9JN 11 views 0 comments 0 points Started by User_NB9JN Oct 9, 2022 6:04PM APEX Discussions
• 
  Why Query gives at least one row as output,i ran this in oracle 19c?

  Responded But No Solution User_AS6XD 91 views 7 comments 0 points Most recent by User_AS6XD Oct 9, 2022 5:42PMSQL & PL/SQL
• 
  How to create view using hierarchical query?

  Responded But No Solution himansu_b 121 views 9 comments 0 points Most recent by Solomon Yakobson Oct 9, 2022 3:57PMSQL & PL/SQL
• 
  Insert Dummy Records when SELECT returns No Data

  Solution Accepted User_7C1YX 142 views 10 comments 0 points Most recent by User_XDU5O Oct 8, 2022 10:21PMSQL & PL/SQL
• 
  Find a branch in organisation tree

  Solution Accepted user13117585 32 views 3 comments 0 points Most recent by user13117585 Oct 8, 2022 9:46AMSQL & PL/SQL
• 
  How to use Case Statement in where clause with Bind parameter

  Solution Accepted Pritam Das 90 views 4 comments 0 points Most recent by BluShadow Oct 7, 2022 7:08AMSQL & PL/SQL
• 
  Retrieving the highest varchar value

  Responded But No Solution User_MR96E 84 views 7 comments 0 points Most recent by mathguy Oct 6, 2022 6:12PMSQL & PL/SQL
• 
  Grant privileges to role, ORA-02204

  Responded But No Solution user545194 31 views 2 comments 0 points Most recent by Paulzip Oct 5, 2022 12:52PMSQL & PL/SQL
• 
  Write a pl/sql procedure to transfer data from excel to oracle table

  Responded But No Solution Closed User_IAP38 795 views 8 comments 0 points Most recent by BluShadow Oct 4, 2022 7:56AMSQL & PL/SQL
• 
  Trouble using XML Table to Extract Single Piece of Data

  Solution Accepted User_LT7WC 42 views 2 comments 0 points Most recent by mathguy Oct 3, 2022 11:32PMSQL & PL/SQL
• 
  Extract value from a string

  Responded But No Solution user11334489 202 views 13 comments 0 points Most recent by BluShadow Oct 3, 2022 7:30AMSQL & PL/SQL
• 
  User choice input for filter data in WHERE clause

  Responded But No Solution Rengudi 31 views 1 comment 0 points Most recent by Frank Kulash Sep 30, 2022 5:23PMSQL & PL/SQL
• 
  Need sql query as they only sell two products

  Responded But No Solution User_X9S6M 41 views 4 comments 0 points Most recent by Frank Kulash Sep 30, 2022 9:49AMSQL & PL/SQL
• 
  Interactive Grid - ADD Row generate Sequence number

  Question M.bro 45 views 0 comments 0 points Started by M.bro Sep 30, 2022 8:42AM APEX Discussions
• 
  How can I have the live value (AVG) while filling a a interactive form?

  Responded But No Solution Jesun Ahmad Ushno 31 views 3 comments 0 points Most recent by Hamza Al-abbasi Sep 29, 2022 12:36PMAPEX Discussions
• 
  Update column using Order by

  Solution Accepted Rohith369-Oracle 41 views 2 comments 0 points Most recent by Rohith369-Oracle Sep 29, 2022 11:55AMSQL & PL/SQL
• 
  create Table AS select - Adding new additional columns

  Solution Accepted User_VSOG2 101 views 3 comments 0 points Most recent by User_VSOG2 Sep 28, 2022 5:00AMSQL & PL/SQL
• 
  Get overlapping data of the same column

  Solution Accepted User_9UK1R 91 views 7 comments 0 points Most recent by BluShadow Sep 27, 2022 7:28AMSQL & PL/SQL