plsql

Discussion List

• 
  Need to generate report from main table and master table

  Responded But No Solution Albert Chao 15 views 2 comments 0 points Most recent by Albert Chao 6:46AMSQL & PL/SQL
• 
  Need to insert multiple values but not able to do

  Solution Accepted Albert Chao 10 views 2 comments 0 points Most recent by Albert Chao 4:55AMSQL & PL/SQL
• 
  Getting error while calling procedure

  Solution Accepted Albert Chao 28 views 8 comments 0 points Most recent by Frank Kulash Sep 23, 2021 4:12PMSQL & PL/SQL
• 
  Based on plsql code

  Responded But No Solution User_0IIX4 58 views 7 comments 0 points Most recent by BluShadow Sep 23, 2021 1:26PMSQL & PL/SQL
• 
  reverse engineering in Sum according to range and rate

  Responded But No Solution muttleychess 20 views 1 comment 0 points Most recent by mathguy Sep 22, 2021 8:28PMSQL & PL/SQL
• 
  Error in calling PTF function with describe Method

  Responded But No Solution User_UCQG4 14 views 3 comments 0 points Most recent by Michael Ferrante-Oracle Sep 22, 2021 4:53PMForms
• 
  Loading data from staging table to main table

  Solution Accepted Albert Chao 54 views 7 comments 0 points Most recent by JonWat Sep 21, 2021 7:19PMSQL & PL/SQL
• 
  Issue with apex fonts in select list with Firefox browser

  Question Mr.Peabody 4 views 0 comments 0 points Started by Mr.Peabody Sep 21, 2021 6:49AM APEX Discussions
• 
  I am getting missing keyword error while selecting the statement

  Solution Accepted Albert Chao 15 views 1 comment 0 points Most recent by Jan Gorkow Sep 21, 2021 6:12AMSQL & PL/SQL
• 
  I want to insert variable values into a table

  Solution Accepted Albert Chao 27 views 4 comments 0 points Most recent by mathguy Sep 20, 2021 2:41PMSQL & PL/SQL
• 
  DBMS_DataPump.OPEN fails in Oracle 18c error:

  Responded But No Solution User_TK218 41 views 13 comments 0 points Most recent by User_TK218 Sep 20, 2021 12:04PMSQL & PL/SQL
• 
  I wanted to know how we can move table data to another table using stored procedure

  Responded But No Solution Albert Chao 31 views 9 comments 0 points Most recent by User_H3J7U Sep 20, 2021 7:35AMSQL & PL/SQL
• 
  dbms_scheduler.create_calendar_string() returns different value in oracle 18c and 11g.

  Responded But No Solution User_TK218 31 views 5 comments 0 points Most recent by User_TK218 Sep 16, 2021 4:17AMSQL & PL/SQL
• 
  I want to drop tables based on their references i.e FK and PK order. How to select all tables?

  Solution Accepted Albert Chao 132 views 19 comments 0 points Most recent by EdStevens Sep 15, 2021 2:52PMSQL & PL/SQL
• 
  ORA-29273: HTTP request failed

  Question Damola Azeez 45 views 0 comments 0 points Started by Damola Azeez Sep 11, 2021 11:49PM SQL & PL/SQL
• 
  How to fetch multiple records from the table using stored procedure

  Solution Accepted Albert Chao 51 views 7 comments 0 points Most recent by BluShadow Sep 6, 2021 7:20AMSQL & PL/SQL
• 
  Need help with the below assignment. You can take any table for reference

  Solution Accepted Albert Chao 121 views 25 comments 0 points Most recent by BluShadow Sep 3, 2021 12:51PMSQL & PL/SQL
• 
  Getting error 'wrong number or types of arguments in call to 'DISP_EMP_DETAILS' while calling a SP

  Responded But No Solution Albert Chao 31 views 5 comments 0 points Most recent by BluShadow Sep 3, 2021 12:26PMSQL & PL/SQL
• 
  In a loop, use a cursor to retrieve the deptNumber and the deptName from the “Department” table, pas

  Solution Accepted Albert Chao 51 views 8 comments 0 points Most recent by BluShadow Sep 3, 2021 12:24PMSQL & PL/SQL
• 
  Dynamically building DBMS_CLOUD.CREATE_EXTERNAL_TABLE, Execute Immediate doesn't work

  Solution Accepted user3975371 22 views 2 comments 0 points Most recent by user3975371 Aug 31, 2021 9:47AMSQL Developer
• 
  How to get different column names into one column and corresponding values into one column

  Solution Accepted User_QDHXF 32 views 2 comments 0 points Most recent by User_QDHXF Aug 30, 2021 5:08PMSQL & PL/SQL
• 
  Oracle Apex Modfiy Grid query to fetch previous quarter data if current not available

  Responded But No Solution Vinipanda 1 view 3 comments 0 points Most recent by Abdulkareem Al-Badani Aug 26, 2021 8:59AMSQL & PL/SQL
• 
  How to insert additional records based of another

  Responded But No Solution User_JP93M 32 views 5 comments 0 points Most recent by BluShadow Aug 26, 2021 8:29AMSQL & PL/SQL