sql

Discussion List

• 
  How can I compare two tables in a CASE ?

  Solution Accepted Edisson Gabriel López 31 views 9 comments 0 points Most recent by Edisson Gabriel López Jul 19, 2021 10:01PMSQL & PL/SQL
• 
  Oracle Getting latest N rows from a group

  Solution Accepted BeefStu 31 views 5 comments 0 points Most recent by EdStevens Jul 18, 2021 1:07PMSQL & PL/SQL
• 
  Oracle SQL rolling up multiple values

  Solution Accepted BeefStu 41 views 5 comments 0 points Most recent by Frank Kulash Jul 18, 2021 10:57AMSQL & PL/SQL
• 
  How can I conditionally display entries in a column as links only if a query does not come up empty?

  Responded But No Solution Pearl 33 views 7 comments 0 points Most recent by pkpanda Jul 17, 2021 8:48AMAPEX Discussions
• 
  How to recover dropped index?

  Responded But No Solution kalyan vedagiri 11 views 3 comments 0 points Most recent by Jonathan Lewis Jul 16, 2021 8:40AMSQL & PL/SQL
• 
  From Clause

  Solution Accepted Brad Chriss 21 views 5 comments 0 points Most recent by Jonathan Lewis Jul 16, 2021 7:21AMSQL & PL/SQL
• 
  VSCODE: Edit files with .pls or .plb extension and compile them into the DB

  Responded But No Solution user482888 51 views 3 comments 0 points Most recent by Christian.Shay -Oracle Jul 15, 2021 8:02PMOracle Developer Tools for VS Code
• 
  How to make index usable?

  Responded But No Solution kalyan vedagiri 12 views 2 comments 0 points Most recent by EdStevens Jul 15, 2021 3:08PMSQL & PL/SQL
• 
  First rec of the last group!!!

  Solution Accepted Thirumoorthy Selvaraj 53 views 4 comments 0 points Most recent by mathguy Jul 14, 2021 2:10AMSQL & PL/SQL
• 
  Query finding First Rec out of Latest Group

  Responded But No Solution Closed user6417373 32 views 1 comment 0 points Most recent by Frank Kulash Jul 13, 2021 7:38PMSQL & PL/SQL
• 
  Use column references in SQL

  Solution Accepted ProDBA 65 views 7 comments 0 points Most recent by EdStevens Jul 13, 2021 4:37PMSQL & PL/SQL
• 
  Passing parameters to function in SQL

  Responded But No Solution user8196955 32 views 4 comments 0 points Most recent by BluShadow Jul 13, 2021 2:52PMSQL & PL/SQL
• 
  Combining multiple rows to get a single one

  Responded But No Solution User_UJ80K 63 views 4 comments 0 points Most recent by Frank Kulash Jul 12, 2021 12:20PMSQL & PL/SQL
• 
  Need help in query correction

  Responded But No Solution RameshSagar 52 views 11 comments 0 points Most recent by Frank Kulash Jul 11, 2021 4:38PMSQL & PL/SQL
• 
  What is the alternative for 'for loop' ?

  Responded But No Solution kalyan vedagiri 101 views 8 comments 0 points Most recent by BluShadow Jul 9, 2021 3:08PMSQL & PL/SQL
• 
  How to Maintain History table using Oracle SQL Developer

  Solution Accepted User_0WCIA 123 views 25 comments 0 points Most recent by Solomon Yakobson Jul 9, 2021 11:49AMSQL & PL/SQL
• 
  Procedure Compile takes time - around 4 mins

  Responded But No Solution 0614 21 views 3 comments 0 points Most recent by Jonathan Lewis Jul 8, 2021 2:07PMGeneral Database Discussions
• 
  SQL Query Explain plan analysis

  Responded But No Solution MohammedImran 51 views 7 comments 0 points Most recent by Jonathan Lewis Jul 8, 2021 10:34AMSQL & PL/SQL
• 
  Show Index in CDB

  Responded But No Solution User_9DDB0 22 views 1 comment 0 points Most recent by Jason_(A_Non) Jul 7, 2021 7:14PMSQL & PL/SQL
• 
  closing and opening balance SQL

  Solution Accepted AQH 88 views 8 comments 0 points Most recent by AQH Jul 6, 2021 5:27PMSQL & PL/SQL
• 
  Transpose Column Oracle Sql

  Solution Accepted User_3ZTH7 47 views 9 comments 0 points Most recent by User_3ZTH7 Jul 5, 2021 2:08PMSQL & PL/SQL
• 
  how to get data from first table(not exists) when tables reside in different DB.

  Responded But No Solution User_DIL60 22 views 1 comment 0 points Most recent by Hub Tijhuis Jul 4, 2021 7:05AMSQL & PL/SQL
• 
  Getting PLS-00306: wrong number or types of arguments in call in my Pkg

  Question user1699124 405 views 4 comments 0 points Most recent by BEDE Jul 1, 2021 7:50AMSQL & PL/SQL
• 
  SQL Query to get Maximum date with in each month

  Responded But No Solution User_GNBO3 874 views 8 comments 0 points Most recent by mathguy Jun 26, 2021 2:02AMSQL & PL/SQL
• 
  Alter session statement in View

  Responded But No Solution User_JZKI6 64 views 4 comments 0 points Most recent by jflack Jun 25, 2021 5:09PMSQL & PL/SQL