plsql

Discussion List

• 
  Can we use %rowtype attribute inside the plsql record?

  Responded But No Solution SHAJ_SHAJIN 20 views 4 comments 0 points Most recent by Frank Kulash 8:20PMSQL & PL/SQL
• 
  How can I use non-secure APIs with APEX?

  Responded But No Solution Edisson Gabriel López 38 views 3 comments 0 points Most recent by Lior Asras -Oracle 4:14PMAPEX Discussions
• 
  show all locations that do not meet certain requirements

  Solution Accepted Bjornlaat 18 views 2 comments 0 points Most recent by Bjornlaat Jun 29, 2022 11:46AMSQL & PL/SQL
• 
  Oracle Apex alert message from PL/SQL

  Responded But No Solution User_7IBR1 21 views 1 comment 0 points Most recent by Billy Verreynne Jun 29, 2022 9:13AMAPEX Discussions
• 
  Trigger creation comparison then insert records

  Responded But No Solution User_IAP38 11 views 3 comments 0 points Most recent by Frank Kulash Jun 28, 2022 4:59PMSQL & PL/SQL
• 
  Get XML elements from XML with namespace, without pointing the namespace

  Solution Accepted Dominik Jasek 83 views 5 comments 0 points Most recent by Dominik Jasek Jun 27, 2022 5:54AMSQL & PL/SQL
• 
  Need help with analytic function

  Solution Accepted User_K6LH0 143 views 12 comments 0 points Most recent by User_K6LH0 Jun 25, 2022 2:06PMSQL & PL/SQL
• 
  Convert number to time

  Solution Accepted Bjornlaat 68 views 13 comments 0 points Most recent by BluShadow Jun 23, 2022 11:22AMSQL & PL/SQL
• 
  Constructing and Passing string value with extended characters(e.g. comma) in url

  Solution Accepted Gor_Mahia 71 views 8 comments 0 points Most recent by Gor_Mahia Jun 22, 2022 9:52PMSQL & PL/SQL
• 
  Need help with writing a query!

  Solution Accepted User_K6LH0 207 views 16 comments 0 points Most recent by User_K6LH0 Jun 22, 2022 3:56AMSQL & PL/SQL
• 
  Exeption handling loop?

  Responded But No Solution User_MF7GJ 33 views 3 comments 0 points Most recent by Frank Kulash Jun 21, 2022 5:47PMSQL & PL/SQL
• 
  How to make existing values to null from the existing plsql logic

  Solution Accepted Albert Chao 51 views 7 comments 0 points Most recent by Frank Kulash Jun 20, 2022 1:38PMSQL & PL/SQL
• 
  SQL query to get number from 0 to 99

  Solution Accepted Yash Parashar 80 views 10 comments 0 points Most recent by Solomon Yakobson Jun 15, 2022 12:48PMSQL & PL/SQL
• 
  PLSQL-Mail sent with attachment

  Responded But No Solution User_IAP38 21 views 2 comments 0 points Most recent by User_IAP38 Jun 13, 2022 1:59PMSQL & PL/SQL
• 
  I don't know how to verify if a parameter exists in the funcion or procedure

  Responded But No Solution User_2FQDI 51 views 4 comments 0 points Most recent by BluShadow Jun 10, 2022 7:55AMSQL & PL/SQL
• 
  REPLACE not working - ASCII character - XML element

  Solution Accepted Jeevan Anand 31 views 3 comments 0 points Most recent by odie_63 Jun 7, 2022 12:40PMSQL & PL/SQL
• 
  How to convert a SELECT in XML in a hierarchical way?

  Solution Accepted Edisson Gabriel López 42 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 21 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 22 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 56 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 11 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 100 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 13 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