plsql

Discussion List

• 
  ORA-25000: invalid use of bind variable in trigger WHEN clause

  Solution Accepted amjadham77Q 76 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 47 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 94 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 35 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 22 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 41 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 31 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 82 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 249 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 82 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 66 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 35 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 101 views 12 comments 0 points Most recent by Albert Chao Nov 11, 2021 6:15AMSQL & PL/SQL
• 
  Selecting isolation level for concurrent processing

  Responded But No Solution User_0U9LV 91 views 14 comments 0 points Most recent by user13328581 Nov 10, 2021 2:24PMSQL & PL/SQL
• 
  How to display records with white space/blank space

  Responded But No Solution kalyan vedagiri 56 views 8 comments 0 points Most recent by mathguy Nov 9, 2021 1:44PMSQL & PL/SQL
• 
  Issue with calling ORDS REST API with JSON input

  User_6GK8Y 53 views 8 comments 0 points Most recent by SmithJohn45 Nov 9, 2021 8:25AMAPEX Discussions
• 
  Filter rows by csv global variables

  Solution Accepted DarrinT 21 views 4 comments 0 points Most recent by DarrinT Nov 8, 2021 11:35PMSQL & PL/SQL
• 
  Getting IO Error: The Network Adapter could not establish error error while connecting to the DB

  Solution Accepted Albert Chao 21 views 2 comments 0 points Most recent by Solomon Yakobson Nov 6, 2021 10:36AMSQL & PL/SQL
• 
  Need to get the row count based on the table data value

  Solution Accepted Albert Chao 62 views 2 comments 0 points Most recent by Frank Kulash Nov 5, 2021 2:21PMSQL & PL/SQL
• 
  Comma separated ID's

  Responded But No Solution Andy2157 73 views 5 comments 0 points Most recent by Paulzip Nov 4, 2021 1:26PMSQL & PL/SQL
• 
  Function for private temp table

  Responded But No Solution foxhound 278 views 9 comments 0 points Most recent by Mike Kutz Nov 3, 2021 8:14PMSQL & PL/SQL
• 
  Find Last two business days of the month

  Solution Accepted User_LX7U6 71 views 6 comments 0 points Most recent by Frank Kulash Nov 3, 2021 2:56AMSQL & PL/SQL