plsql

Discussion List

• 
  sample tnsnames entry for XE

  Responded But No Solution User_ZUZ6N 12 views 1 comment 0 points Most recent by L. Fernigrini Mar 9, 2022 7:46PMOracle Database Express Edition (XE)
• 
  What is the alternative for 'for loop' ?

  Responded But No Solution kalyan vedagiri 266 views 9 comments 0 points Most recent by User_CCS94 Mar 8, 2022 10:57PMSQL & PL/SQL
• 
  how to combine two JSON array list into single array list

  Responded But No Solution Kannan Sekar 193 views 11 comments 0 points Most recent by Solomon Yakobson Mar 6, 2022 12:09PMSQL & PL/SQL
• 
  Execute Immediate on apex_string.format()

  Responded But No Solution Jasper Tanglib 34 views 3 comments 0 points Most recent by fac586 Feb 28, 2022 8:18PMAPEX Discussions
• 
  compilation issue when declaring procedure

  Responded But No Solution User_OMA69 31 views 2 comments 0 points Most recent by L. Fernigrini Feb 25, 2022 5:51PMSQL & PL/SQL
• 
  Securing a service's secret

  Responded But No Solution dominiquefortin 31 views 3 comments 0 points Most recent by dominiquefortin Feb 25, 2022 5:40PMSQL & PL/SQL
• 
  Unpivot Data

  Responded But No Solution Tina 31 views 2 comments 0 points Most recent by Solomon Yakobson Feb 24, 2022 6:28PMGeneral Database Discussions
• 
  How can provide the user options inside procedure ?

  Solution Accepted User_OMA69 31 views 2 comments 0 points Most recent by Billy Verreynne Feb 24, 2022 12:56PMSQL & PL/SQL
• 
  how to take input from user in pl sql procedure ?

  Responded But No Solution User_OMA69 1.1K views 8 comments 0 points Most recent by Billy Verreynne Feb 23, 2022 8:20AMSQL & PL/SQL
• 
  Apex web service REST call returning null

  Responded But No Solution User_8849S 17 views 2 comments 0 points Most recent by User_8849S Feb 22, 2022 4:16AMAPEX Discussions
• 
  How to replace special characters with default value in table column

  Solution Accepted User_58ED4 71 views 5 comments 0 points Most recent by Frank Kulash Feb 21, 2022 11:08AMSQL & PL/SQL
• 
  PLSQL avoid dropping greatest PARTITION

  Responded But No Solution BeefStu 34 views 5 comments 0 points Most recent by BeefStu Feb 18, 2022 10:46AMSQL & PL/SQL
• 
  Load multiple csv into ORACLE database using SQLLDR with NAMES of the loaded files

  Question User_4UIMN 11 views 0 comments 0 points Started by User_4UIMN Feb 17, 2022 8:44PM PL/SQL XML Programming
• 
  How to make user compulsorily enter detail datablock value before saving in a master detail block

  Responded But No Solution User_ZM48K 41 views 6 comments 0 points Most recent by User_ZM48K Feb 17, 2022 3:12PMForms
• 
  Sql Query to fetch previous Salary, Transportation and Housing Allowance of an employee

  Responded But No Solution Johnchandrasekar Kalaimani 28 views 2 comments 0 points Most recent by JonWat Feb 16, 2022 7:43PMSQL & PL/SQL
• 
  Upload a file in Visual Builder. How to pass BLOB as parameter PL/SQL procedure

  Question User_U9CKM 13 views 0 comments 0 points Started by User_U9CKM Feb 15, 2022 7:29AM SQL & PL/SQL
• 
  How to get last quarter of the current quarter

  Solution Accepted Gor_Mahia 343 views 9 comments 0 points Most recent by mathguy Feb 14, 2022 9:40PMSQL & PL/SQL
• 
  PL/SQL Code works fine on 19c RAC, 12.2.0.1 standalone but not 12.2.0.1 RAC : ORA-01422: exact fetch

  Gurunathan Kanniappan 21 views 1 comment 0 points Most recent by BEDE Feb 14, 2022 8:33AMSQL & PL/SQL
• 
  Hi Team I want to run the below query across different versions of database (10g,11g,12c,19c) say 5

  Solution Accepted Gurunathan Kanniappan 62 views 6 comments 0 points Most recent by Gurunathan Kanniappan Feb 14, 2022 7:13AMSQL & PL/SQL
• 
  How to generate alphanumeric no (length will be 6) from 6 digit input value by using pl/sql function

  Responded But No Solution Closed User_V6AO3 31 views 3 comments 0 points Most recent by BluShadow Feb 11, 2022 3:02PMSQL & PL/SQL
• 
  Reg: Passing Parameters to View

  Responded But No Solution User_JZKI6 41 views 2 comments 0 points Most recent by Paulzip Feb 10, 2022 8:31AMSQL & PL/SQL
• 
  How to use the plugin - Apex-D3-Organization-Chart

  Solution Accepted User_Y6MKJ 87 views 1 comment 0 points Most recent by Frank Kulash Feb 9, 2022 4:24PMSQL & PL/SQL
• 
  How to add two conditions in merge statement using rowid and rownum

  Solution Accepted Albert Chao 131 views 5 comments 0 points Most recent by Frank Kulash Feb 8, 2022 4:49PMSQL & PL/SQL