plsql

Discussion List

• 
  How to convert a SELECT in XML in a hierarchical way?

  Solution Accepted Edisson Gabriel López 45 views 6 comments 0 points Most recent by odie_63 Jun 6, 2022 7:28AMSQL & PL/SQL
• 
  query taking too long

  Solution Accepted hemant_k 23 views 2 comments 0 points Most recent by hemant_k Jun 2, 2022 2:22PMGeneral Database Discussions
• 
  SP2-0027: Input is too long (> 4999 characters) - line ignored

  Question User_2MD1X 97 views 1 comment 0 points Most recent by User_2MD1X Jun 2, 2022 6:07AMGeneral Database Discussions
• 
  display data when a row contain certain strings only

  Solution Accepted Devx 41 views 9 comments 0 points Most recent by Solomon Yakobson Jun 1, 2022 10:49AMSQL & PL/SQL
• 
  How to pass JSON type data as an input parameter in a Stored procedure

  Solution Accepted Albert Chao 2.2K views 2 comments 0 points Most recent by odie_63 May 31, 2022 9:53AMSQL & PL/SQL
• 
  UI Loader is Forever Spinning

  Responded But No Solution Jasper Tanglib 24 views 7 comments 0 points Most recent by Jasper Tanglib May 30, 2022 6:10AMAPEX Discussions
• 
  How can I convert a blob to base64?

  Responded But No Solution Edisson Gabriel López 1.7K views 3 comments 0 points Most recent by odie_63 May 27, 2022 8:25PMSQL & PL/SQL
• 
  query getting long run and not giving result

  Responded But No Solution User_ROTJD 11 views 1 comment 0 points Most recent by Jason_(A_Non) May 26, 2022 4:15PMPL/SQL XML Programming
• 
  im using oracle 12c. select query executing faster but insert is getting longer

  Responded But No Solution User_ROTJD 62 views 6 comments 0 points Most recent by User_ROTJD May 26, 2022 12:52PMSQL & PL/SQL
• 
  Need to fetch the table details using stored procedure when we give table name as input

  Solution Accepted Albert Chao 972 views 4 comments 0 points Most recent by User_H3J7U May 25, 2022 9:19AMSQL & PL/SQL
• 
  Custom apex_item popup_from_lov options question

  Responded But No Solution Andreas Wildmann 26 views 6 comments 0 points Most recent by Andreas Wildmann May 25, 2022 9:06AMAPEX Discussions
• 
  using HTTPS url that loaded file into another location

  Question User_IAP38 22 views 0 comments 0 points Started by User_IAP38 May 25, 2022 8:38AM SQL & PL/SQL
• 
  How to URL csv file loaded into unix Location(/equ/str/loaded)

  Responded But No Solution User_IAP38 23 views 1 comment 0 points Most recent by BluShadow May 24, 2022 1:00PMSQL & PL/SQL
• 
  How to do an insert to a table with a JSON?

  Solution Accepted Edisson Gabriel López 21 views 1 comment 0 points Most recent by Paulzip May 23, 2022 11:30PMSQL & PL/SQL
• 
  SQL Loader loaded with decimal data

  Solution Accepted User_IAP38 38 views 2 comments 0 points Most recent by Solomon Yakobson May 23, 2022 11:34AMSQL & PL/SQL
• 
  Using Execute Immediate with FORALL for Update Statement

  Responded But No Solution User_NY02I 154 views 5 comments 0 points Most recent by odie_63 May 23, 2022 10:10AMSQL & PL/SQL
• 
  Using UTL_FILE create dat file

  Solution Accepted User_IAP38 76 views 4 comments 0 points Most recent by User_IAP38 May 23, 2022 9:31AMSQL & PL/SQL
• 
  Calling a Rest API from Oracle Block

  Responded But No Solution Rajan Sw 31 views 3 comments 0 points Most recent by Mike Kutz May 22, 2022 11:15AMSQL & PL/SQL
• 
  Generate Barcode inside Oracle APEX using PLSQL as BLOB and print in PDF.

  Responded But No Solution Kartik Jadeja 198 views 2 comments 0 points Most recent by Kartik Jadeja May 20, 2022 5:51AMAPEX Discussions
• 
  How to redirect to another page with APEX notifications?

  Solution Accepted Edisson Gabriel López 165 views 3 comments 0 points Most recent by jariola May 13, 2022 6:56PMAPEX Discussions
• 
  ORA-06531: Reference to uninitialized collection

  Solution Accepted Lokesh A 1.2K views 4 comments 0 points Most recent by Frank Kulash May 11, 2022 10:59AMSQL & PL/SQL
• 
  Could both these queries be written using UNION ALL in a better way?

  Responded But No Solution AshK-Oracle 41 views 3 comments 0 points Most recent by alvinder May 11, 2022 7:22AMSQL & PL/SQL
• 
  how to fetch data into the cursor.

  Responded But No Solution User_5U3UI 21 views 4 comments 0 points Most recent by Mike Kutz May 10, 2022 2:29PMSQL & PL/SQL
• 
  How to return ID after inserting into table?

  Responded But No Solution Rob8111 7.1K views 8 comments 0 points Most recent by mathguy May 9, 2022 3:49PMSQL & PL/SQL