pl_sql

Discussion List

• 
  How to generate perfect numbers between 1 to 100 Note.: If sum of the divisors is equal to given num

  Responded But No Solution Albert Chao 866 views 24 comments 0 points Most recent by [email protected] Sep 13, 2021 3:51PMSQL & PL/SQL
• 
  I need to write a trigger before update or delete.

  Responded But No Solution SN-R 101 views 15 comments 0 points Most recent by BluShadow Sep 13, 2021 9:26AMSQL & PL/SQL
• 
  Questions about installing using the OS_COMMAND Package

  Solution Accepted rjsosi 436 views 11 comments 0 points Most recent by User_H3J7U Sep 9, 2021 7:46PMSQL & PL/SQL
• 
  Accurate Overlap Hours Calculations is not correct- Please help

  Responded But No Solution User_YL3T0 51 views 7 comments 0 points Most recent by Solomon Yakobson Sep 9, 2021 1:07PMSQL & PL/SQL
• 
  How I can get HTTP response error message?

  Question Edgar S. 12 views 0 comments 0 points Started by Edgar S. Sep 7, 2021 8:36AM APEX Discussions
• 
  Get and insert into table a text from file

  Question Marco Carlos 14 views 0 comments 0 points Started by Marco Carlos Sep 6, 2021 12:02PM APEX Discussions
• 
  How to view source code

  Question User_I10G9 20 views 0 comments 0 points Started by User_I10G9 Aug 24, 2021 11:52PM EBS on OCI Automation
• 
  Bind variable in Dynamic SQL string is not binding in Anonymous block

  Solution Accepted rjsosi 53 views 9 comments 0 points Most recent by Frank Kulash Aug 19, 2021 8:40PMSQL & PL/SQL
• 
  Update 340 Million of rows.

  Responded But No Solution ApparaoAkki-Oracle 71 views 10 comments 0 points Most recent by Jonathan Lewis Aug 13, 2021 7:19PMSQL & PL/SQL
• 
  materialized view not working properly

  Responded But No Solution chandra_1986 62 views 9 comments 0 points Most recent by EdStevens Aug 11, 2021 3:16PMSQL & PL/SQL
• 
  SQL/PL/SQL

  Solution Accepted User_BU3NG 41 views 3 comments 0 points Most recent by Frank Kulash Aug 10, 2021 6:17PMSQL & PL/SQL
• 
  in package authid current_user not current user table trigger running

  Solution Accepted user3970448 82 views 2 comments 0 points Most recent by user3970448 Aug 5, 2021 3:06AMSQL & PL/SQL
• 
  Creating a Scheduler job for another user

  Solution Accepted Laury 945 views 6 comments 0 points Most recent by GregV Jul 29, 2021 2:46PMGeneral Database Discussions
• 
  PLSQL problem creating procedure inconsistent data types

  Solution Accepted BeefStu 81 views 19 comments 0 points Most recent by EdStevens Jul 27, 2021 12:58PMSQL & PL/SQL
• 
  How to fill chart via different queries depending on choice in selection lists

  Solution Accepted Phil7G 21 views 2 comments 0 points Most recent by Phil7G Jul 26, 2021 11:17AMAPEX Discussions
• 
  ORA-02089: COMMIT is not allowed in a subordinate session

  Solution Accepted user5549222 21 views 2 comments 0 points Most recent by Billy Verreynne Jul 23, 2021 11:47AMSQL & PL/SQL
• 
  How to check explain plan of a nested table query?

  Solution Accepted Kinjan Bhavsar 174 views 12 comments 0 points Most recent by Kinjan Bhavsar Jul 21, 2021 8:44AMSQL & PL/SQL
• 
  PL/SQL query

  Solution Accepted SQeeL 21 views 2 comments 0 points Most recent by User_H3J7U Jul 16, 2021 5:14PMSQL & PL/SQL
• 
  What is the order of operation in Where clause?

  Solution Accepted SQeeL 45 views 6 comments 0 points Most recent by Frank Kulash Jul 15, 2021 7:26PMSQL & PL/SQL
• 
  Procedure Compile takes time - around 4 mins

  Responded But No Solution 0614 52 views 3 comments 0 points Most recent by Jonathan Lewis Jul 8, 2021 2:07PMGeneral Database Discussions
• 
  XMLoutput in Apex 5.1

  Question Jadey_apex 11 views 0 comments 0 points Started by Jadey_apex Jul 8, 2021 12:06PM Java Technology & XML
• 
  error when call java method from oracle database

  Responded But No Solution User_HIDYS 21 views 1 comment 0 points Most recent by SureshDooly-Oracle Jul 6, 2021 2:55AMJava and JavaScript in the Database
• 
  What is the best procedure to apply SQL query with a function created by PL/SQL in BIP

  Solution Accepted User_GEZN9 51 views 10 comments 0 points Most recent by User_GEZN9 Jun 25, 2021 9:10AMSQL & PL/SQL
• 
  SQL query help for use case

  Responded But No Solution User_CXOM2 16 views 2 comments 0 points Most recent by dvohra21 Jun 23, 2021 1:39AMMySQL Community Space
• 
  add_months

  Solution Accepted SQeeL 42 views 3 comments 0 points Most recent by SQeeL Jun 22, 2021 12:21PMSQL & PL/SQL