plsql

Discussion List

• 
  how get value from xml response ?

  Solution Accepted user7340885 26 views 4 comments 0 points Most recent by user7340885 January 27Forms
• 
  Oracle Text Index to avoid DRG-11225

  Responded But No Solution Birthe Gebhardt 9 views 1 comment 0 points Most recent by Paulzip January 27SQL & PL/SQL
• 
  Updating a column to NULL in a table having 62m records

  Responded But No Solution curious_mind 30 views 5 comments 0 points Most recent by Solomon Yakobson January 21SQL & PL/SQL
• 
  Deletion on more than 7m records

  curious_mind 40 views 2 comments 0 points Most recent by Dear DBA Frank January 19SQL & PL/SQL
• 
  Requirement to Automate the File Load in Database

  Responded But No Solution sandeepgupta18 54 views 7 comments 0 points Most recent by Mike Kutz January 17SQL & PL/SQL
• 
  I have requirement that entire column values are null want to adjust as per expected format

  Solution Accepted User_TIFB4 45 views 4 comments 0 points Most recent by User_TIFB4 January 14SQL & PL/SQL
• 
  Reg expression

  Responded But No Solution User_76ZL9 41 views 3 comments 0 points Most recent by User_76ZL9 January 14APEX Discussions
• 
  Reg expression

  Responded But No Solution Closed User_76ZL9 23 views 1 comment 0 points Most recent by Solomon Yakobson January 13SQL & PL/SQL
• 
  APEX_WEB_SERVICE.MAKE_REST_REQUEST: ORA-24247

  Solution Accepted Birthe Gebhardt 41 views 4 comments 0 points Most recent by Birthe Gebhardt January 13SQL & PL/SQL
• 
  List of Values PL/SQL function body returning sql query in APEX not reading item values

  Responded But No Solution User_G4ALZ 34 views 4 comments 0 points Most recent by AndyH January 10APEX Discussions
• 
  Need a PLSQL package for the below query.

  Responded But No Solution User_8RYDC 45 views 4 comments 0 points Most recent by Mike Kutz January 6SQL & PL/SQL
• 
  Need to tune performance issue of a sql query

  Responded But No Solution Yogendra Singh 68 views 6 comments 0 points Most recent by evgenyg January 5SQL Developer
• 
  Send Email to Individual

  Solution Accepted User_W58DO 66 views 5 comments 0 points Most recent by BluShadow January 5SQL & PL/SQL
• 
  Run PL/SQL analymous block in multi-threaded unix script

  Solution Accepted Haider Hussain 16 views 5 comments 0 points Most recent by Paulzip December 2020SQL & PL/SQL
• 
  Oracle Procedure for loop with html tags needs to be amended for sideways image aligning

  Question Vinipanda 20 views 0 comments 0 points Started by Vinipanda December 2020 SQL & PL/SQL
• 
  Obtener una imagen completa

  Responded But No Solution User_BOB0N 14 views 1 comment 0 points Most recent by L. Fernigrini December 2020Español Discusiones
• 
  Split string field and append new values to the splitted strings

  Solution Accepted User_1KK7K 25 views 3 comments 0 points Most recent by User_1KK7K December 2020SQL & PL/SQL
• 
  HTML code in PL/SQL proc

  Question Vinipanda 35 views 0 comments 0 points Started by Vinipanda December 2020 APEX Discussions
• 
  Check if data block record is in edit or add state

  Responded But No Solution User_VDYAS 27 views 1 comment 0 points Most recent by Hub Tijhuis December 2020Forms
• 
  SQL to check for Re-Occurring Event.

  Solution Accepted Mr.Jondee 54 views 12 comments 0 points Most recent by Mr.Jondee December 2020SQL & PL/SQL
• 
  Unescape of special characters < and > in Oracle sql

  Responded But No Solution User_1KK7K 36 views 3 comments 0 points Most recent by Paulzip December 2020SQL & PL/SQL
• 
  need help with the query

  Responded But No Solution curious_mind 41 views 2 comments 0 points Most recent by JonWat December 2020SQL & PL/SQL
• 
  Procedure creating dynamic view to be modified to include function returning sql

  Responded But No Solution Vinipanda 97 views 12 comments 0 points Most recent by Vinipanda December 2020SQL & PL/SQL
• 
  Oracle Apex Select List LOV conditional query

  Responded But No Solution tvbishan 15 views 1 comment 0 points Most recent by Awais Majeed December 2020APEX Discussions
• 
  Database relationship with tree database - SQL*Plus: Release 19.0.0.0.0

  Responded But No Solution SPathak 26 views 4 comments 0 points Most recent by EdStevens December 2020General Database Discussions
• 
  Is there a way to run the scheduler job by code after end_date happened

  Solution Accepted User_TK218 24 views 2 comments 0 points Most recent by GregV December 2020SQL & PL/SQL
• 
  Synonym for Schema Names

  Solution Accepted User_D9WKA 32 views 3 comments 0 points Most recent by User_D9WKA December 2020SQL & PL/SQL
• 
  ORACLE v12.1 - JSON_TABLE usage for array

  Responded But No Solution Jorgelina 62 views 16 comments 0 points Most recent by Jorgelina December 2020SQL & PL/SQL
• 
  Oracle PL/SQL Procedure/function to dynamically create view with dynamic columns

  Solution Accepted Vinipanda 136 views 24 comments 0 points Most recent by Vinipanda December 2020SQL & PL/SQL
• 
  Oracle Database 19c: Program with PL/SQL

  Responded But No Solution Akhtar_w 38 views 1 comment 0 points Most recent by BluShadow December 2020SQL & PL/SQL
• 
  Query taking time , result for more no. of records coming timout

  Responded But No Solution chandra_1986 31 views 5 comments 0 points Most recent by Solomon Yakobson November 2020SQL & PL/SQL
• 
  delete records procedure

  Responded But No Solution chandra_1986 138 views 31 comments 0 points Most recent by Hub Tijhuis November 2020SQL & PL/SQL
• 
  How to solve buffer busy waits due to Concurrent INSERTS?

  Responded But No Solution 0614 52 views 5 comments 0 points Most recent by Jonathan Lewis November 2020SQL & PL/SQL
• 
  access the variable value in .sql file

  Solution Accepted curious_mind 37 views 13 comments 0 points Most recent by Billy Verreynne November 2020General Database Discussions
• 
  dbms_metadata.get_ddl() gives table definition differently in 19c than 12c

  Responded But No Solution User_ZEA2B 37 views 3 comments 0 points Most recent by Solomon Yakobson November 2020SQL & PL/SQL
• 
  Bug in PL/SQL when a bind variable is in a comment

  Responded But No Solution User_CTJPX 58 views 4 comments 0 points Most recent by BEDE November 2020SQL & PL/SQL
• 
  Include prior rows if the end date from prior rows is greater than current row start date.

  Solution Accepted mlov83 30 views 2 comments 0 points Most recent by mlov83 November 2020SQL & PL/SQL
• 
  How to dynamically transpose data into with changing column headers with or without pivot/pivot xml?

  Responded But No Solution Vinipanda 48 views 3 comments 0 points Most recent by Frank Kulash November 2020SQL & PL/SQL
• 
  Disabling default constraint in a table is possible?

  Responded But No Solution Lokesh A 28 views 2 comments 0 points Most recent by Paulzip November 2020SQL & PL/SQL
• 
  download OS_COMMAND package?

  Question siegwin.port 40 views 2 comments 0 points Most recent by Billy Verreynne November 2020SQL & PL/SQL
• 
  Oracle PL/SQL Insert comma separated string split into rows with varying label values

  Solution Accepted Vinipanda 60 views 13 comments 0 points Most recent by Vinipanda November 2020SQL & PL/SQL
• 
  Select Distinct

  Responded But No Solution user9311128 68 views 14 comments 0 points Most recent by mathguy November 2020SQL & PL/SQL
• 
  Oracle Procedure unpivot data into destination using data splitting logic used in existing procedure

  Vinipanda 69 views 15 comments 0 points Most recent by Vinipanda November 2020SQL & PL/SQL
• 
  DBMS_SQL using PL/SQL table

  Solution Accepted siegwin.port 30 views 3 comments 0 points Most recent by siegwin.port November 2020SQL & PL/SQL
• 
  Oracle how to classify time series ?

  Responded But No Solution PAN KEVIN 37 views 2 comments 0 points Most recent by PAN KEVIN November 2020SQL & PL/SQL
• 
  Check Constraint to validate the date

  Solution Accepted user9311128 50 views 9 comments 0 points Most recent by mathguy November 2020SQL & PL/SQL
• 
  How to use bind variable in UTL_FILE.FOPEN

  Responded But No Solution User_OLK44 33 views 3 comments 0 points Most recent by Billy Verreynne November 2020SQL Developer
• 
  deletion of records older then 90 days

  Responded But No Solution chandra_1986 60 views 13 comments 0 points Most recent by chandra_1986 November 2020SQL & PL/SQL
• 
  Create CSV based on number of rows

  Responded But No Solution Marco Foxx 44 views 8 comments 0 points Most recent by Billy Verreynne November 2020SQL & PL/SQL