plsql

Discussion List

• 
  Execute Immediate 'Alter Session' from Inside DBMS_SCHEDULER Job Procedure

  Solution Accepted User_I4Y3C 517 views 17 comments 4 points Most recent by Saubhik August 2020SQL & PL/SQL
• 
  real time requirement scenario for create materialized view

  Responded But No Solution 4252564 38 views 1 comment 2 points Most recent by Saubhik August 2020SQL & PL/SQL
• 
  Select Data from a Query and Send output in Windows Zip Format as Attachment

  Responded But No Solution Arun Kumar Gupta 132 views 4 comments 0 points Most recent by Arun Kumar Gupta August 2020SQL & PL/SQL
• 
  Regexp_substr-Double quotes in param

  Responded But No Solution 959406 39 views 4 comments 0 points Most recent by Tubby July 2020SQL & PL/SQL
• 
  dynamic :new and :old values in oracle trigger

  Responded But No Solution user9974866 203 views 17 comments 0 points Most recent by Billy Verreynne July 2020SQL & PL/SQL
• 
  How to debug PL/SQL proc with WebModule, invoked 'in-session' from application?

  Solution Accepted Amba 158 views 7 comments 1 point Most recent by Amba July 2020APEX Discussions
• 
  Split specific value in a column which is delimited by a special symbol

  Responded But No Solution shuvro 168 views 15 comments 2 points Most recent by mathguy July 2020SQL & PL/SQL
• 
  Issue in inserting >32k size pdf in table

  Responded But No Solution skud 108 views 5 comments 0 points Most recent by Mark D Powell July 2020SQL & PL/SQL
• 
  PL/SQL Procedure does not allow declarations for t.parameters ~ workaround?

  Solution Accepted Amba 58 views 3 comments 0 points Most recent by jariola July 2020APEX Discussions
• 
  Count days excluding weekends.

  Responded But No Solution User_5F8TP 123 views 9 comments 2 points Most recent by User_5F8TP July 2020SQL & PL/SQL
• 
  Is there an efficient way to update and insert records without loop?

  Responded But No Solution Kinjan Bhavsar 143 views 5 comments 0 points Most recent by Kinjan Bhavsar July 2020SQL & PL/SQL
• 
  oracle apex collection

  Solution Accepted Nodjus 67 views 3 comments 1 point Most recent by 0b61fa58-a151-4f64-a1d9-2cb8b42711a2 July 2020APEX Discussions
• 
  select and if

  Responded But No Solution ömer faruk akyüzlü 155 views 12 comments 1 point Most recent by jaramill June 2020SQL & PL/SQL
• 
  json table with nested paths

  Responded But No Solution Frank Lehmann 66 views 3 comments 0 points Most recent by Paulzip June 2020SQL & PL/SQL
• 
  Reporting a BUG in handling plsql in sql

  Responded But No Solution Erik van Roon 93 views 3 comments 2 points Most recent by thatJeffSmith-Oracle June 2020SQLcl
• 
  Varios UPDATE en un procedimiento

  Responded But No Solution AlfonsoAlmonte 211 views 4 comments 1 point Most recent by AlfonsoAlmonte June 2020Español Discusiones
• 
  How to combine two json_object from different tables in one json?

  Responded But No Solution Kinjan Bhavsar 292 views 18 comments 0 points Most recent by Kinjan Bhavsar June 2020SQL & PL/SQL
• 
  How to exclude values from the previous records?

  Responded But No Solution User_5F8TP 213 views 22 comments 3 points Most recent by User_5F8TP June 2020SQL & PL/SQL
• 
  How to combine/concat two or more rows in a single json object in SQL?

  Solution Accepted Kinjan Bhavsar 701 views 4 comments 1 point Most recent by Kinjan Bhavsar June 2020SQL & PL/SQL
• 
  How to get current user_id in Oracle Apex

  Solution Accepted Pav1 552 views 4 comments 0 points Most recent by Mike Kutz June 2020APEX Discussions
• 
  Create Summary Values at Multiple Levels of Hierarchy

  Responded But No Solution 3427617 98 views 5 comments 1 point Most recent by Stew Ashton June 2020SQL & PL/SQL
• 
  Operation on a Table type variable storing multiple values one time rather than looping

  Responded But No Solution 4245323 259 views 19 comments 1 point Most recent by John Thorton May 2020SQL & PL/SQL
• 
  How to use case statement in select into clause while creating stored procedure.

  Responded But No Solution 4251257 37 views 2 comments 0 points Most recent by mathguy May 2020SQL & PL/SQL
• 
  Oracle-Apex process for insert into two tables

  Responded But No Solution Pav1 81 views 1 comment 0 points Most recent by InoL May 2020APEX Discussions