sql

Discussion List

• 
  Getting unique records daily currency rates

  Responded But No Solution User_SQSR4 14 views 2 comments 0 points Most recent by mathguy 7:33AMSQL & PL/SQL
• 
  I want to enclose the sql query out with open and close brackets [ 1,2,3 ]

  Responded But No Solution User_N2CZ9 32 views 3 comments 0 points Most recent by Gaz in Oz January 27SQL & PL/SQL
• 
  insert multiple rows on table based on other table's column value

  Solution Accepted user8629294 24 views 6 comments 0 points Most recent by Frank Kulash January 25SQL & PL/SQL
• 
  Views dropped

  Solution Accepted user545194 30 views 10 comments 0 points Most recent by user545194 January 25General Database Discussions
• 
  Apex AB: Extract value of Number-Field and use the value as condition for another query

  Responded But No Solution User_UN2PH 13 views 1 comment 0 points Most recent by AndyH January 23APEX Discussions
• 
  Is there a way to avoid corrupted indexes after running SQL Loader?

  Responded But No Solution simon87 18 views 1 comment 0 points Most recent by L. Fernigrini January 21SQL & PL/SQL
• 
  Delta load logic using oracle merge/delete sql statement

  Solution Accepted user12251389 94 views 23 comments 0 points Most recent by Solomon Yakobson January 20SQL & PL/SQL
• 
  Follow-up to getting a summation from results

  Solution Accepted User_OMEF8 73 views 18 comments 0 points Most recent by Frank Kulash January 16SQL & PL/SQL
• 
  How to handle repeated records in SQL?

  Solution Accepted RajeshKota 54 views 4 comments 0 points Most recent by Frank Kulash January 16SQL & PL/SQL
• 
  How A Query Executes in Oracle

  sandeepgupta18 25 views 1 comment 0 points Most recent by Frank Kulash January 15SQL & 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 Closed User_76ZL9 23 views 1 comment 0 points Most recent by Solomon Yakobson January 13SQL & PL/SQL
• 
  SQL to give Friday of running week

  Solution Accepted karthick.raje 41 views 5 comments 0 points Most recent by RogerT January 13SQL & PL/SQL
• 
  COUNT(*) KEEP (DENSE_RANK LAST ORDER BY COUNT(*)) OVER (PARTITION BY A,B)

  Solution Accepted Martin J. 39 views 1 comment 0 points Most recent by Martin J. January 11SQL & PL/SQL
• 
  Getting a summation of results

  Solution Accepted User_OMEF8 66 views 10 comments 0 points Most recent by User_OMEF8 January 9SQL & PL/SQL
• 
  Getting a summation of results -- Please delete this discussion/question.

  User_OMEF8 23 views 0 comments 0 points Started by User_OMEF8 January 8 Reports
• 
  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
• 
  group by value count and other count to show

  Responded But No Solution User_7PZDE 21 views 2 comments 0 points Most recent by Frank Kulash December 2020SQL & PL/SQL
• 
  Select not null columns from a table

  Responded But No Solution Soofi 55 views 7 comments 0 points Most recent by jflack December 2020SQL & PL/SQL
• 
  how does the where clause work here?

  Solution Accepted User_68DIP 29 views 4 comments 0 points Most recent by Frank Kulash December 2020SQL & PL/SQL
• 
  What's the problem with my password while installing Apex 20.1?

  Responded But No Solution User_UBZRD 52 views 4 comments 0 points Most recent by Aredd December 2020APEX Discussions
• 
  select result without same rows

  Responded But No Solution User_48J1W 30 views 1 comment 0 points Most recent by Frank Kulash December 2020SQL & PL/SQL
• 
  TRUNCATE TABLE giving error even with DROP ANY TABLE system privilege

  Responded But No Solution sabyakgp 45 views 5 comments 0 points Most recent by Brett Calhoun December 2020General Database Discussions
• 
  Received ORA-00980 when clicking REST under a Table via SQL Workshop

  Question sect55 14 views 0 comments 0 points Started by sect55 December 2020 APEX Discussions
• 
  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
• 
  Week is number of weeks in that month

  Solution Accepted ricard888 63 views 4 comments 0 points Most recent by mathguy December 2020SQL & PL/SQL
• 
  EXECUTE IMMEDIATE sometimes doesn't retrieve any information

  Question User_HIE3G 38 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
• 
  Transaction Details (AVG read and write operations)

  Question Jhil 23 views 0 comments 0 points Started by Jhil December 2020 General Database Discussions
• 
  Connect and run a script

  Responded But No Solution user13117585 42 views 2 comments 0 points Most recent by Gaz in Oz December 2020SQLcl
• 
  Add blank records to the top of an existing result and always maintain a total of 15 rows

  Solution Accepted Roxy rollers 20 views 2 comments 0 points Most recent by Frank Kulash December 2020SQL & PL/SQL
• 
  How can I group a column one or more results in the same column?

  Solution Accepted User_OMEF8 42 views 2 comments 0 points Most recent by User_OMEF8 December 2020Reports
• 
  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
• 
  ORA-06533: Subscript beyond count

  Solution Accepted Lokesh A 24 views 1 comment 0 points Most recent by mathguy December 2020SQL & PL/SQL
• 
  Help with Convert SQL Server SQL to Oracle SQL

  Responded But No Solution User_6TGRX 47 views 2 comments 0 points Most recent by User_6TGRX 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
• 
  Finding out the differences between coder and auditor coding

  Responded But No Solution User_6TGRX 36 views 2 comments 0 points Most recent by User_6TGRX November 2020SQL & PL/SQL
• 
  sql to generate month and year for current and past 3 months

  Solution Accepted karthick.raje 36 views 3 comments 0 points Most recent by DeepC 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
• 
  Charting Values from Checkbox Column

  Solution Accepted B_Brock 19 views 3 comments 0 points Most recent by B_Brock November 2020APEX Discussions
• 
  Transposing Rows into Columns (Except the number of columns could vary)

  Solution Accepted Roxy rollers 33 views 5 comments 0 points Most recent by Frank Kulash November 2020SQL & PL/SQL