pl_sql

Discussion List

• 
  Getting a Nested With Clause error while creating a Table

  Solution Accepted User_QDHXF 34 views 8 comments 0 points Most recent by User_QDHXF Sep 16, 2021 6:50PMSQL & PL/SQL
• 
  Can I group a set of values from one column with comma separate based on another columns?

  Solution Accepted User_QDHXF 11 views 1 comment 0 points Most recent by Solomon Yakobson Sep 14, 2021 10:05PMSQL & PL/SQL
• 
  Why is it that my images is a .png instead of a .jpg?

  Question User_ZH1UM 11 views 0 comments 0 points Started by User_ZH1UM Sep 13, 2021 6:46PM APEX Discussions
• 
  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 475 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 152 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 52 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. 11 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 13 views 0 comments 0 points Started by Marco Carlos Sep 6, 2021 12:02PM APEX Discussions
• 
  How to view source code

  Question User_I10G9 1 view 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 51 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 73 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 52 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 75 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 244 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 82 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 53 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 41 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 21 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 12 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 22 views 1 comment 0 points Most recent by SureshDooly-Oracle Jul 6, 2021 2:55AMJava and JavaScript in the Database