sql

Discussion List

• 
  plsql code compilation issues

  Responded But No Solution 0614 11 views 2 comments 0 points Most recent by Mustafa_KALAYCI Oct 12, 2021 1:29PMGeneral Database Discussions
• 
  using REGEXP_LIKE

  Solution Accepted Gor_Mahia 23 views 3 comments 0 points Most recent by Paulzip Oct 11, 2021 7:45PMSQL & PL/SQL
• 
  SQLPLUS COLUMN POSITION

  Responded But No Solution Ibrahim Alzaidi 37 views 1 comment 0 points Most recent by thatJeffSmith-Oracle Oct 11, 2021 12:07PMSQL Developer
• 
  How to get column value of a tabular form in oracle apex ?

  Responded But No Solution User_7DS20 32 views 1 comment 0 points Most recent by andreml Oct 10, 2021 9:04AMAPEX Discussions
• 
  How to add ordinality (st, nd, rd, th) to numbers?

  Solution Accepted User_QDHXF 42 views 8 comments 0 points Most recent by mathguy Oct 8, 2021 5:05PMSQL & PL/SQL
• 
  How can I sum the previous row with LAG() function?

  Solution Accepted Edisson Gabriel López 36 views 5 comments 0 points Most recent by cormaco Oct 7, 2021 7:40PMSQL & PL/SQL
• 
  How can I get data from yesterday?

  Responded But No Solution Edisson Gabriel López 78 views 9 comments 0 points Most recent by Frank Kulash Oct 7, 2021 5:36PMSQL & PL/SQL
• 
  How can we load data into CLOB datatype column using SQL Loader?

  Solution Accepted Nirvan 879 views 4 comments 0 points Most recent by User_H3J7U Oct 7, 2021 5:29AMSQL & PL/SQL
• 
  Oracle PL/SQL to T-SQL Conversion Question

  Responded But No Solution User_8CP69 27 views 1 comment 0 points Most recent by Frank Kulash Oct 6, 2021 10:02PMSQL & PL/SQL
• 
  select query with parameter date and null

  Solution Accepted ora_1978 51 views 3 comments 0 points Most recent by mathguy Oct 5, 2021 5:53AMSQL & PL/SQL
• 
  terribly slow string split expression

  Solution Accepted Gor_Mahia 51 views 5 comments 0 points Most recent by BluShadow Oct 4, 2021 4:41PMSQL & PL/SQL
• 
  How to handle JSON with big size > 100k

  Responded But No Solution mail8mz 41 views 3 comments 0 points Most recent by User_H3J7U Oct 4, 2021 4:29PMSQL & PL/SQL
• 
  Generate total and grand totals

  Solution Accepted Gor_Mahia 31 views 1 comment 0 points Most recent by Frank Kulash Oct 2, 2021 3:05AMSQL & PL/SQL
• 
  Please help me. I am getting error while running the following Oracle 11.2g SQL code:

  Solution Accepted User_6TYJG 31 views 5 comments 0 points Most recent by User_6TYJG Sep 30, 2021 10:06AMSQL & PL/SQL
• 
  Hints Regarding Improve Performance

  Responded But No Solution User_UCQG4 22 views 2 comments 0 points Most recent by User_UCQG4 Sep 30, 2021 9:52AMSQL & PL/SQL
• 
  How do i avoid multiple UNIONs?

  Solution Accepted user2660061 65 views 3 comments 0 points Most recent by Frank Kulash Sep 29, 2021 8:43PMSQL & PL/SQL
• 
  Query re-write

  Question cubeguy 41 views 1 comment 0 points Most recent by Frank Kulash Sep 29, 2021 12:25PMSQL & PL/SQL
• 
  Having an indicator for few conditions

  Solution Accepted User_QDHXF 32 views 7 comments 0 points Most recent by mathguy Sep 28, 2021 5:52PMSQL & PL/SQL
• 
  Grouping data

  Responded But No Solution User_Z4F6B 21 views 2 comments 0 points Most recent by User_Z4F6B Sep 28, 2021 3:58AMSQL & PL/SQL
• 
  Using type objects owned by another user through role is not working

  Solution Accepted Ants Hindpere 18 views 1 comment 0 points Most recent by mathguy Sep 24, 2021 2:25PMSQL & PL/SQL
• 
  How to Load a 37 digit number from file into table using sqlcl load

  Solution Accepted User_SEI52 24 views 3 comments 0 points Most recent by thatJeffSmith-Oracle Sep 23, 2021 2:28PMSQL Developer
• 
  Error in calling PTF function with describe Method

  Responded But No Solution User_UCQG4 11 views 3 comments 0 points Most recent by Michael Ferrante-Oracle Sep 22, 2021 4:53PMForms