plsql

Discussion List

• 
  Update remote table - performance issue

  Responded But No Solution Kannan Sekar 36 views 3 comments 0 points Most recent by EdStevens Dec 4, 2021 2:58PMSQL & PL/SQL
• 
  Form Fields from HTP.P are not submitting with the rest of the APEX Items on the page...

  Responded But No Solution bostonmacosx 13 views 1 comment 0 points Most recent by Joe Upshaw Dec 3, 2021 9:59PMAPEX Discussions
• 
  Prefix data (not append) into a CLOB

  Solution Accepted User_G3NSO 37 views 6 comments 0 points Most recent by BluShadow Dec 3, 2021 8:16AMSQL & PL/SQL
• 
  Create Global Index on Interval partitioned tables

  Responded But No Solution User_NY02I 35 views 4 comments 0 points Most recent by User_NY02I Dec 3, 2021 6:10AMGeneral Database Discussions
• 
  Count the register of tables based on a table that contain them all

  Responded But No Solution User_D3NE3 126 views 14 comments 0 points Most recent by User_G3NSO Dec 2, 2021 9:35PMSQL & PL/SQL
• 
  How will I be able to validate the column value from the table and merge into the another table

  Solution Accepted Albert Chao 31 views 1 comment 0 points Most recent by Frank Kulash Dec 1, 2021 10:46AMSQL & PL/SQL
• 
  Getting integrity constraint error while loading the data

  Solution Accepted Albert Chao 26 views 2 comments 0 points Most recent by Frank Kulash Nov 30, 2021 12:48PMSQL & PL/SQL
• 
  Oracle 19 c multimedia resize image to smaller size with PLSQL

  Responded But No Solution User_EYWS1 68 views 4 comments 0 points Most recent by User_H3J7U Nov 28, 2021 12:47AMSQL & PL/SQL
• 
  ORA-25000: invalid use of bind variable in trigger WHEN clause

  Solution Accepted amjadham77Q 33 views 3 comments 0 points Most recent by amjadham77Q Nov 26, 2021 9:35PMSQL & PL/SQL
• 
  How can I insert into a table after an insert event?

  Solution Accepted Edisson Gabriel López 43 views 3 comments 0 points Most recent by Frank Kulash Nov 25, 2021 10:39PMSQL & PL/SQL
• 
  Need to extract the value which are enclosed in brackets

  Solution Accepted Albert Chao 41 views 7 comments 0 points Most recent by Mike Kutz Nov 25, 2021 1:21PMSQL & PL/SQL
• 
  Need to convert the data type while inserting into the other table

  Solution Accepted Albert Chao 57 views 6 comments 0 points Most recent by Frank Kulash Nov 24, 2021 2:26PMSQL & PL/SQL
• 
  PLS-00201: identifier 'CURSOR' must be declaredCompilation failed

  Solution Accepted amjadham77Q 42 views 7 comments 0 points Most recent by Solomon Yakobson Nov 24, 2021 2:17PMSQL & PL/SQL
• 
  How to increase performance when inserting more than 40k+ rows

  Solution Accepted Albert Chao 31 views 4 comments 0 points Most recent by BluShadow Nov 24, 2021 8:53AMSQL & PL/SQL
• 
  Need not to insert duplicate records into the main table instead want to update the existing record

  Solution Accepted Albert Chao 24 views 1 comment 0 points Most recent by BEDE Nov 24, 2021 8:32AMSQL & PL/SQL
• 
  When I am inserting records into the table it is inserting 0 records. Though there are no errors

  Solution Accepted Albert Chao 45 views 6 comments 0 points Most recent by Frank Kulash Nov 24, 2021 3:15AMSQL & PL/SQL
• 
  Can we write case statements inside the insert clause? I need to insert 5 records from the lookup

  Solution Accepted Albert Chao 21 views 1 comment 0 points Most recent by Frank Kulash Nov 23, 2021 3:50PMSQL & PL/SQL
• 
  I need to insert records based on the number of owners. If there are 2 owners then two records shoul

  Solution Accepted Albert Chao 33 views 7 comments 0 points Most recent by Albert Chao Nov 22, 2021 4:46PMSQL & PL/SQL
• 
  Can we use POST method to retrieve the data ?

  User_6GK8Y 43 views 7 comments 0 points Most recent by AndyH Nov 20, 2021 5:30PMAPEX Discussions
• 
  Appending column value of one table to another table

  Solution Accepted Albert Chao 81 views 9 comments 0 points Most recent by Frank Kulash Nov 17, 2021 10:48AMSQL & PL/SQL
• 
  Need to load the excel data to database table on weekly basis automatically

  Solution Accepted Albert Chao 71 views 6 comments 0 points Most recent by BluShadow Nov 15, 2021 11:59AMSQL & PL/SQL
• 
  Request for sql query to exclude weekends, leave for attendances

  Solution Accepted User_8KQYD 41 views 8 comments 0 points Most recent by User_8KQYD Nov 14, 2021 3:58PMSQL & PL/SQL
• 
  getting ORA-01422: exact fetch returns more than requested number of rows while calling a procedure

  Solution Accepted Albert Chao 32 views 3 comments 0 points Most recent by BluShadow Nov 11, 2021 2:33PMSQL & PL/SQL
• 
  Not able to process the comma separated input parameter of the stored procedure.

  Solution Accepted Albert Chao 95 views 12 comments 0 points Most recent by Albert Chao Nov 11, 2021 6:15AMSQL & PL/SQL