sql pl sql

Discussion List

• 
  How to display employee status date wise in a month

  Solution Accepted Vemula Muni 352 views 22 comments 1 point Most recent by jaramill Jul 26, 2019 11:19AMSQL & PL/SQL
• 
  How to display employee status between dates

  Responded But No Solution Closed Vemula Muni 42 views 2 comments 0 points Most recent by Frank Kulash Jul 24, 2019 8:42AMSQL & PL/SQL
• 
  Execute immediate connect statement in SqlPlus' Stored Procedure

  Responded But No Solution IrfanAslam 718 views 21 comments 2 points Most recent by BluShadow Jul 17, 2019 10:05AMSQL & PL/SQL
• 
  Help with a query to show database growth

  Responded But No Solution Brian.B 2.2K views 2 comments 0 points Most recent by Mark D Powell Jun 26, 2019 10:26AMGeneral Database Discussions
• 
  JSON_TABLE - how to extract columns when the first key value dynamically changes

  Responded But No Solution OracleDaveS 2.4K views 3 comments 1 point Most recent by dmcmahon-Oracle Jun 20, 2019 4:31PMORDS, SODA & JSON in the Database
• 
  How to replace comma separated different values with a particular value

  Solution Accepted OraDev16 1.7K views 2 comments 1 point Most recent by OraDev16 Jun 12, 2019 8:01PMSQL & PL/SQL
• 
  Does adding new columns to Dimension tables require reloading of related Fact tables?

  Solution Accepted sabyakgp 371 views 5 comments 3 points Most recent by BluShadow Jun 7, 2019 10:19AMSQL & PL/SQL
• 
  how to split time range into 30 min. for each row

  Responded But No Solution MGhobashi 623 views 6 comments 3 points Most recent by Ranagal May 31, 2019 7:06AMSQL & PL/SQL
• 
  How to get all child records from a table with multiple self referential integrity constraints?

  Responded But No Solution User_RPCWI 2.2K views 18 comments 1 point Most recent by User_RPCWI May 28, 2019 8:41AMSQL & PL/SQL
• 
  Query to separate values

  Solution Accepted 3990004 125 views 6 comments 1 point Most recent by cormaco May 22, 2019 1:37AMSQL & PL/SQL
• 
  Sorting column A based on a column B which contains previous values from column A

  Responded But No Solution 4001936 113 views 5 comments 1 point Most recent by Choc Cac May 17, 2019 11:45AMSQL & PL/SQL
• 
  Query to show the Works which are in Active state more than once

  Solution Accepted Anindya G 91 views 11 comments 0 points Most recent by Frank Kulash May 10, 2019 11:29AMSQL & PL/SQL
• 
  update,insert and delete in single merge query

  Responded But No Solution 3521116 2.1K views 1 comment 1 point Most recent by L. Fernigrini Apr 25, 2019 7:15PMOracle Database Express Edition (XE)
• 
  Oracle data to send as Excel table format by email

  Responded But No Solution User_AWHMX 225 views 2 comments 0 points Most recent by Marwim Apr 25, 2019 6:24AMSQL & PL/SQL
• 
  ORA-01704: string literal too long when using JSON_Table

  Solution Accepted 3980960 2.2K views 3 comments 1 point Most recent by 3980960 Apr 23, 2019 2:16AMSQL & PL/SQL
• 
  How to set double condition for set of fields? APEX

  Responded But No Solution Nicholas_R 99 views 3 comments 0 points Most recent by Jorgelina1 Apr 15, 2019 9:45AMAPEX Discussions
• 
  how to get result from last date and max date in sql

  Responded But No Solution User_RS0D7 7.1K views 5 comments 2 points Most recent by cormaco Apr 14, 2019 12:41PMSQL & PL/SQL
• 
  How to change the value in the field? APEX

  Solution Accepted Nicholas_R 88 views 4 comments 2 points Most recent by Nicholas_R Apr 11, 2019 8:58AMAPEX Discussions
• 
  Null handling oracle

  Solution Accepted Abhisek Samanta 149 views 4 comments 1 point Most recent by Donatello Settembrino Apr 9, 2019 8:42AMGeneral Database Discussions
• 
  Sequence number generation clarification

  Solution Accepted User_LCHKL 78 views 5 comments 2 points Most recent by Cookiemonster76 Apr 5, 2019 5:16AMSQL & PL/SQL
• 
  Recursive trigger solution

  Responded But No Solution naveenmani912 669 views 9 comments 6 points Most recent by Zlatko Sirotic Apr 1, 2019 8:57AMSQL & PL/SQL
• 
  SQL Query on setting up the previous value of the adjacent column to the other column

  Responded But No Solution Gayathri Venugopal 627 views 7 comments 2 points Most recent by Gaz in Oz Mar 31, 2019 2:12AMMySQL Community Space
• 
  dbms_xmlgen.getxmltype || ORA-00904: : invalid identifier : error :

  Responded But No Solution naveenmani912 548 views 6 comments 1 point Most recent by Paulzip Mar 27, 2019 3:37PMSQL & PL/SQL
• 
  PLSQL aggegations with addition and Subtraction

  Responded But No Solution Closed User_DT6AQ 101 views 3 comments 0 points Most recent by Frank Kulash Mar 27, 2019 1:25PMSQL & PL/SQL
• 
  anytype error

  Responded But No Solution naveenmani912 124 views 7 comments 0 points Most recent by BluShadow Mar 26, 2019 4:27AMSQL & PL/SQL