plsql

Discussion List

• 
  pipline function dynamic column display

  Solution Accepted User_NHLO2 31 views 9 comments 0 points Most recent by User_NHLO2 8:53PMSQL & PL/SQL
• 
  How to make CASE condition simpler for 1400 records

  Responded But No Solution User_228PP 24 views 1 comment 0 points Most recent by Scott Wesley April 12APEX Discussions
• 
  cancel

  Question User_AC3QE 46 views 2 comments 0 points Most recent by Frank Kulash April 12SQL & PL/SQL
• 
  Spooling Data with UTF8 Format

  Question Rajan Sw 15 views 0 comments 0 points Started by Rajan Sw April 12 General Database Discussions
• 
  apex_string.string_to_table giving ORA-00902: invalid datatype

  Solution Accepted Mr.Peabody 34 views 8 comments 0 points Most recent by Hub Tijhuis April 11SQL & PL/SQL
• 
  Query needs to be re-written

  Responded But No Solution curious_mind 46 views 9 comments 0 points Most recent by cormaco April 9SQL & PL/SQL
• 
  Ignore NULLS on 2 different columns

  Responded But No Solution Kannan Sekar 61 views 5 comments 0 points Most recent by Christian Osvaldo González April 9SQL & PL/SQL
• 
  How to handle exception of trigger created on base table

  Responded But No Solution User_E97G7 18 views 2 comments 0 points Most recent by User_E97G7 April 9General Database Discussions
• 
  Unique Index not allowing to insert rows into table..

  Responded But No Solution Kannan Sekar 26 views 2 comments 0 points Most recent by Frank Kulash April 7SQL & PL/SQL
• 
  How to reference and execute a plsql file uploaded in static files?

  Solution Accepted Jasper Tanglib 48 views 10 comments 0 points Most recent by Sylvain Martel April 7APEX Discussions
• 
  How to pass a variable with index(i) into a Procedure?

  Responded But No Solution Jasper Tanglib 39 views 9 comments 0 points Most recent by jflack April 7SQL & PL/SQL
• 
  SQL listagg with distinct

  Solution Accepted user9311128 21 views 4 comments 0 points Most recent by user9311128 April 7SQL & PL/SQL
• 
  PL/SQL - How to execute queries generated within a query?

  Responded But No Solution Jasper Tanglib 23 views 7 comments 0 points Most recent by Frank Kulash April 5SQL & PL/SQL
• 
  PL/SQL - How to save a query's output into a variable and execute it?

  Solution Accepted Jasper Tanglib 30 views 5 comments 0 points Most recent by Jasper Tanglib April 5SQL & PL/SQL
• 
  Format model

  User_DIL60 35 views 6 comments 0 points Most recent by Solomon Yakobson April 4SQL & PL/SQL
• 
  Oracle Apex - How to execute query generated from a query?

  Solution Accepted Jasper Tanglib 24 views 5 comments 0 points Most recent by Jasper Tanglib April 4APEX Discussions
• 
  Reg: date with hour in parititon

  Responded But No Solution chandra_1986 21 views 6 comments 0 points Most recent by chandra_1986 April 2SQL & PL/SQL
• 
  cursor vs bulk collect

  Responded But No Solution francy77 82 views 20 comments 0 points Most recent by francy77 April 1SQL & PL/SQL
• 
  How read emails in Oracle database using pl/sql

  Responded But No Solution User_DT12P 3.9K views 14 comments 6 points Most recent by Marcelo Osorio Kosky March 31SQL & PL/SQL
• 
  Forall delete with rowid- top wait event - db file sequential read further optimization

  Responded But No Solution user591200 21 views 3 comments 0 points Most recent by Jonathan Lewis March 30General Database Discussions
• 
  Waterfall Bridge Chart

  Responded But No Solution hiddenonearth 42 views 9 comments 0 points Most recent by Frank Kulash March 24SQL & PL/SQL
• 
  JSON format file

  Responded But No Solution User_3UMC3 12 views 2 comments 0 points Most recent by Solomon Yakobson March 23SQL & PL/SQL
• 
  Weird behaviour of LENGTH(NVL())

  Solution Accepted John like many others 22 views 2 comments 0 points Most recent by John like many others March 19General Database Discussions
• 
  How to find only Null value record fields in a table

  Responded But No Solution User_UMJZ5 22 views 1 comment 0 points Most recent by Frank Kulash March 18SQL & PL/SQL
• 
  How can a procedure act differently for APEX than in the database??!!

  Solution Accepted grog 21 views 4 comments 0 points Most recent by jariola March 17APEX Discussions