pl_sql

Discussion List

• 
  using outer apply with a table macro function fails when the macro has 'fetch first row only'

  Responded But No Solution User_2OQ7J 11 views 2 comments 0 points Most recent by User_2OQ7J Feb 18, 2021 11:03PMODP.NET
• 
  How to get a selected row column values in interactive gird?

  Responded But No Solution User_DXKQF 418 views 1 comment 0 points Most recent by BobR Feb 14, 2021 1:47PMAPEX Discussions
• 
  Transforming rows into columns

  Responded But No Solution SQL_Developer 31 views 2 comments 0 points Most recent by mathguy Feb 13, 2021 3:32AMSQL & PL/SQL
• 
  I'm having trouble filtering display

  Solution Accepted User_AC3QE 43 views 6 comments 0 points Most recent by mathguy Feb 11, 2021 8:20PMSQL & PL/SQL
• 
  help needed with the query

  Solution Accepted curious_mind 11 views 1 comment 0 points Most recent by RogerT Feb 10, 2021 2:58PMSQL & PL/SQL
• 
  Integrate Datatables api on APEX

  Responded But No Solution Gonçalo 86 views 8 comments 0 points Most recent by Gonçalo Feb 9, 2021 11:09PMAPEX Discussions
• 
  Build Html table from a collection with pl-sql

  Solution Accepted Gonçalo 286 views 5 comments 0 points Most recent by Gonçalo Feb 7, 2021 3:35PMAPEX Discussions
• 
  How to write a CLOB to an OS file in Oracle without using UTL_FILE package?

  Responded But No Solution User_T3DXH 130 views 2 comments 0 points Most recent by Paulzip Feb 6, 2021 5:28PMSQL & PL/SQL
• 
  count the row before a delete

  Solution Accepted francy77 22 views 2 comments 0 points Most recent by Frank Kulash Feb 2, 2021 3:39PMSQL & PL/SQL
• 
  running a store procedure PL/SQL: ORA-01031:

  Solution Accepted francy77 23 views 3 comments 0 points Most recent by francy77 Feb 2, 2021 10:03AMSQL & PL/SQL
• 
  Rest API call PL/SQL

  Solution Accepted User_A8XLF 358 views 5 comments 0 points Most recent by Bilal Feb 1, 2021 10:29AMSQL & PL/SQL
• 
  How to fix this error?

  Responded But No Solution jdev1 131 views 49 comments 0 points Most recent by jdev1 Jan 30, 2021 1:43PMSQL & PL/SQL
• 
  How does Oracle handle this MERGE use case.

  Responded But No Solution User_0JAQ3 34 views 6 comments 0 points Most recent by mathguy Jan 29, 2021 3:33PMSQL & PL/SQL
• 
  Using CTE in Stored Procedure

  Responded But No Solution User_J7CQL 137 views 2 comments 0 points Most recent by mathguy Jan 28, 2021 3:10PMSQL & PL/SQL
• 
  How can I covert a SQL statement with a cursor into JSON

  Responded But No Solution User_0JAQ3 21 views 2 comments 0 points Most recent by User_0JAQ3 Jan 28, 2021 12:54AMORDS, SODA & JSON in the Database
• 
  Updating a column to NULL in a table having 62m records

  Responded But No Solution curious_mind 31 views 5 comments 0 points Most recent by Solomon Yakobson Jan 21, 2021 4:24PMSQL & PL/SQL
• 
  Deletion on more than 7m records

  curious_mind 44 views 2 comments 0 points Most recent by Dear DBA Frank Jan 19, 2021 5:38PMSQL & PL/SQL
• 
  Follow-up to getting a summation from results

  Solution Accepted User_OMEF8 73 views 18 comments 0 points Most recent by Frank Kulash Jan 16, 2021 4:28PMSQL & PL/SQL
• 
  I have requirement that entire column values are null want to adjust as per expected format

  Solution Accepted User_TIFB4 41 views 4 comments 0 points Most recent by User_TIFB4 Jan 14, 2021 10:16PMSQL & PL/SQL
• 
  List of Values PL/SQL function body returning sql query in APEX not reading item values

  Responded But No Solution User_G4ALZ 389 views 4 comments 0 points Most recent by AndyH Jan 10, 2021 4:36PMAPEX Discussions
• 
  How to return multiple fields using date range with table function

  Responded But No Solution LotsViv 11 views 1 comment 0 points Most recent by Frank Kulash Jan 4, 2021 6:19PMSQL & PL/SQL
• 
  how can i enable a button to trigger a pl/sql insert action on click in an apex pl/sql dynamic conte

  Solution Accepted User_G4ALZ 32 views 6 comments 0 points Most recent by User_G4ALZ Jan 4, 2021 12:39PMAPEX Discussions
• 
  Error using PL/SQL code on Process with Editable Region

  Closed Ricardo Mouro 41 views 1 comment 0 points Most recent by Madhusudhan_Rao-Oracle Dec 15, 2020 12:53PMOracle APEX Development Workshops
• 
  EXECUTE IMMEDIATE sometimes doesn't retrieve any information

  Question User_HIE3G 32 views 3 comments 0 points Most recent by Paulzip Dec 11, 2020 11:53PMSQL & PL/SQL