plsql

Discussion List

• 
  LastUpdateDate will be updated in the base table IF any of the rows gets updated in other Tables

  Responded But No Solution User_1646H 61 views 8 comments 0 points Most recent by User_1646H Sep 21, 2022 10:02AMSQL & PL/SQL
• 
  Handling UTF8 characters in APEX

  Question Niki Dilip 21 views 0 comments 0 points Started by Niki Dilip Sep 20, 2022 7:06AM APEX Discussions
• 
  query works in sql developer but does not work on sql plus

  Responded But No Solution User_0UWMN 23 views 1 comment 0 points Most recent by L. Fernigrini Sep 19, 2022 12:21PMGeneral Database Discussions
• 
  How to load data from staging table using unpivoting the data into the main table

  Solution Accepted Albert Chao 84 views 8 comments 0 points Most recent by Albert Chao Sep 17, 2022 2:22PMSQL & PL/SQL
• 
  Need Help Using APEX_WEB_SERVICE to Invoke REST WS

  Question User_LT7WC 21 views 0 comments 0 points Started by User_LT7WC Sep 16, 2022 11:31PM SQL & PL/SQL
• 
  Oracle PL/SQL: Trigger Syntax

  Responded But No Solution User_TUDYU 211 views 29 comments 0 points Most recent by L. Fernigrini Sep 16, 2022 3:06PMSQL & PL/SQL
• 
  How to load cvs file into table using sql loader ?

  Solution Accepted AS08 41 views 3 comments 0 points Most recent by Frank Kulash Sep 15, 2022 9:02PMSQL & PL/SQL
• 
  convert sql rows into xml tags

  Responded But No Solution User_WWD0C 27 views 1 comment 0 points Most recent by Jason_(A_Non) Sep 15, 2022 4:05PMPL/SQL XML Programming
• 
  Ubl 2.1 registerSchema

  Responded But No Solution User_WWD0C 15 views 1 comment 0 points Most recent by Jason_(A_Non) Sep 15, 2022 4:01PMPL/SQL XML Programming
• 
  query -- fetch data with specific date in 24 hrs

  Solution Accepted User_IAP38 63 views 9 comments 0 points Most recent by User_IAP38 Sep 15, 2022 1:52PMSQL & PL/SQL
• 
  SQL to update missing data in a record with data from latest complete record

  Responded But No Solution user3400366 68 views 8 comments 0 points Most recent by Frank Kulash Sep 15, 2022 11:43AMSQL & PL/SQL
• 
  Parameterized Cursor on JSON_TABLE

  Responded But No Solution User_4ZOU6 94 views 1 comment 0 points Most recent by Gangu Nagendra Prasad Sep 15, 2022 3:50AMORDS, SODA & JSON in the Database
• 
  Match data in Oracle

  Responded But No Solution Amywilson 111 views 6 comments 0 points Most recent by BluShadow Sep 12, 2022 9:20AMSQL & PL/SQL
• 
  New version: 21.5.0 with Default Connections, Login scripts, SQL and PL/SQL Formatter

  Announcement Closed Christian.Shay -Oracle 184 views 0 comments 1 point Started by Christian.Shay -Oracle Sep 10, 2022 3:48AM Oracle Developer Tools for VS Code
• 
  Splitting a string into five columns (some can be null)

  Solution Accepted Gor_Mahia 61 views 5 comments 0 points Most recent by Sven W. Sep 9, 2022 3:51PMSQL & PL/SQL
• 
  GOTO Statements

  SHAJ_SHAJIN 51 views 4 comments 0 points Most recent by BluShadow Sep 8, 2022 2:18PMSQL & PL/SQL
• 
  Need Help With Object Types

  Solution Accepted User_K6LH0 61 views 7 comments 0 points Most recent by User_K6LH0 Sep 5, 2022 10:23PMSQL & PL/SQL
• 
  PLSQL-the Quantity against another Quantity to determine how much to allot

  Solution Accepted User_IAP38 112 views 10 comments 0 points Most recent by User_IAP38 Sep 5, 2022 4:42AMSQL & PL/SQL
• 
  using a cursor to calculate order logic

  Responded But No Solution User_IAP38 122 views 9 comments 0 points Most recent by Stax Sep 2, 2022 8:21AMSQL & PL/SQL
• 
  Transfer Timeout using UTL_HTTP to certain Endpoints

  Responded But No Solution CInglezSTC 837 views 24 comments 0 points Most recent by CInglezSTC Aug 29, 2022 7:15PMSQL & PL/SQL
• 
  plsql-logic demand requirement code needed

  Solution Accepted User_IAP38 245 views 24 comments 0 points Most recent by User_IAP38 Aug 26, 2022 4:21PMSQL & PL/SQL
• 
  I am trying to insert the row into table based on condition.Getting syntax error.

  Responded But No Solution AshK-Oracle 44 views 4 comments 0 points Most recent by Jonathan Lewis Aug 25, 2022 11:06AMSQL & PL/SQL
• 
  pivot multiple rows (at most 3) into columns

  Solution Accepted Gor_Mahia 71 views 8 comments 0 points Most recent by BluShadow Aug 23, 2022 7:30AMSQL & PL/SQL
• 
  Loop thru 2 Cursors at the same time?

  Responded But No Solution User_2KMIP 74 views 14 comments 0 points Most recent by User_2KMIP Aug 23, 2022 3:27AMSQL & PL/SQL