SQL & PL/SQL

Discussion List

• 
  Strong(er) data typing in PL/SQL - How?

  Solution Accepted mathguy 45 views 11 comments 0 points Most recent by mathguy 4:06PM
• 
  SQL trimming data

  Responded But No Solution MSB2016 37 views 3 comments 0 points Most recent by Sven W. January 23
• 
  Piecewise conversion via UTL_I18N.RAW_TO_CHAR

  Responded But No Solution xxsawer 13 views 1 comment 0 points Most recent by Paulzip January 23
• 
  Generate extra rows based on conditions

  Solution Accepted user650888 41 views 5 comments 0 points Most recent by mathguy January 22
• 
  Query help to update latest record

  Solution Accepted Ricky007 30 views 8 comments 0 points Most recent by Paulzip January 22
• 
  Data masking or scrambling

  Responded But No Solution Sid_ Z. 30 views 3 comments 0 points Most recent by Sid_ Z. January 22
• 
  Get a value from an array depending on the number of occurrence

  Solution Accepted user13117585 66 views 13 comments 0 points Most recent by Frank Kulash January 22
• 
  How to get the sql text of sys ref cursor

  Responded But No Solution ronald_2017 50 views 12 comments 0 points Most recent by Billy Verreynne January 22
• 
  CTE Performance with OAC

  Responded But No Solution SIMMS7400 90 views 19 comments 0 points Most recent by SIMMS7400 January 22
• 
  Updating column in master table from child records

  Solution Accepted leck 47 views 8 comments 0 points Most recent by leck January 22
• 
  Procedure lines of code capture in temp table

  Responded But No Solution rock_1986 34 views 2 comments 0 points Most recent by Billy Verreynne January 22
• 
  Regular expression for Titles

  Responded But No Solution User_S549Q 55 views 12 comments 0 points Most recent by mathguy January 22
• 
  Why Oracle do not use sql planbaseline

  Responded But No Solution ronald_2017 21 views 1 comment 0 points Most recent by ronald_2017 January 21
• 
  Is there a way to avoid corrupted indexes after running SQL Loader?

  Responded But No Solution simon87 17 views 1 comment 0 points Most recent by L. Fernigrini January 21
• 
  Merge query performance slow for delta load

  Responded But No Solution user12251389 64 views 18 comments 0 points Most recent by user12251389 January 21
• 
  Computing a range (start/end) from a set

  Solution Accepted user13117585 55 views 7 comments 0 points Most recent by mathguy January 21
• 
  Updating a column to NULL in a table having 62m records

  Responded But No Solution curious_mind 29 views 5 comments 0 points Most recent by Solomon Yakobson January 21
• 
  call and execute some stored procedures inside another one

  Solution Accepted Fabrizio Delli Priscoli 32 views 2 comments 0 points Most recent by Fabrizio Delli Priscoli January 21
• 
  How to create Excel sheet using PLSQL

  Responded But No Solution User_KB7K0 43 views 6 comments 0 points Most recent by BluShadow January 21
• 
  HCM Spreadsheet error when trying to update Position

  Question User_XHWUB 11 views 0 comments 0 points Started by User_XHWUB January 21
• 
  double characters

  Responded But No Solution Tricampeon_1981 31 views 6 comments 0 points Most recent by mathguy January 21
• 
  Why "an INTO clause is expected in this SELECT statement"

  Solution Accepted User_QE503 35 views 11 comments 0 points Most recent by L. Fernigrini January 20
• 
  Delta load logic using oracle merge/delete sql statement

  Solution Accepted user12251389 90 views 23 comments 0 points Most recent by Solomon Yakobson January 20
• 
  Native Oracle XML DB Web Service

  Solution Accepted aebrigham 27 views 4 comments 0 points Most recent by aebrigham January 20
• 
  Question on Left join

  Solution Accepted Tina 33 views 3 comments 0 points Most recent by Tina January 19
• 
  Cursor FOR LOOP vs. FOR LOOP with SELECT hard coded.

  Solution Accepted jflack 80 views 7 comments 0 points Most recent by Solomon Yakobson January 19
• 
  Deletion on more than 7m records

  curious_mind 38 views 2 comments 0 points Most recent by Dear DBA Frank January 19
• 
  GET THE WORDS IN AND GET ALPHANUMERIC INFORMATION IN OF A CHARACTER STRING

  Solution Accepted Toby 54 views 13 comments 0 points Most recent by Paulzip January 19
• 
  Required Help regarding SMTP_OUT_SERVER

  Solution Accepted AFF-MMCL 23 views 2 comments 0 points Most recent by AFF-MMCL January 19
• 
  Unable to update a table from Anonymous block

  Responded But No Solution Amywilson 56 views 8 comments 0 points Most recent by Paulzip January 18
• 
  Reg: validated Praent key not found when enabling the constraints.

  Solution Accepted chandra_1986 50 views 12 comments 0 points Most recent by mathguy January 18
• 
  how to resrt sequnce in 18c

  Responded But No Solution Tony007 32 views 3 comments 0 points Most recent by BEDE January 18
• 
  Stored Procedures validation validation

  Responded But No Solution Amywilson 30 views 2 comments 0 points Most recent by BEDE January 18
• 
  Requirement to Automate the File Load in Database

  Responded But No Solution sandeepgupta18 52 views 7 comments 0 points Most recent by Mike Kutz January 17
• 
  Follow-up to getting a summation from results

  Solution Accepted User_OMEF8 71 views 18 comments 0 points Most recent by Frank Kulash January 16
• 
  dbms_metadata.get_ddl for table adds Supplemental Logging

  Responded But No Solution Girish Kale 17 views 1 comment 0 points Most recent by Paulzip January 16
• 
  How to handle repeated records in SQL?

  Solution Accepted RajeshKota 52 views 4 comments 0 points Most recent by Frank Kulash January 16
• 
  How to select items from a validation table range values

  Responded But No Solution Mameli75 15 views 6 comments 0 points Most recent by Paulzip January 15
• 
  cast not working with union

  Responded But No Solution Robeen 34 views 5 comments 0 points Most recent by mathguy January 15
• 
  Displaying individual dates and date ranges

  Responded But No Solution sgalaxy 52 views 5 comments 0 points Most recent by Solomon Yakobson January 15
• 
  Get data by joining two tables

  Responded But No Solution User_F3HNY 26 views 2 comments 0 points Most recent by Frank Kulash January 15
• 
  How A Query Executes in Oracle

  sandeepgupta18 24 views 1 comment 0 points Most recent by Frank Kulash January 15
• 
  comma separated to column and row

  Responded But No Solution User_F3HNY 23 views 1 comment 0 points Most recent by Frank Kulash January 15
• 
  I have requirement that entire column values are null want to adjust as per expected format

  Solution Accepted User_TIFB4 43 views 4 comments 0 points Most recent by User_TIFB4 January 14
• 
  GET NUMBERS IN BETWEEN = OR - AND A STRING

  Solution Accepted Toby 59 views 4 comments 0 points Most recent by Toby January 13
• 
  Reg expression

  Responded But No Solution Closed User_76ZL9 23 views 1 comment 0 points Most recent by Solomon Yakobson January 13
• 
  Update Sequence Number based on Group condition

  Solution Accepted SPathak 38 views 3 comments 0 points Most recent by Frank Kulash January 13
• 
  APEX_WEB_SERVICE.MAKE_REST_REQUEST: ORA-24247

  Solution Accepted Birthe Gebhardt 36 views 4 comments 0 points Most recent by Birthe Gebhardt January 13
• 
  How to merge back to table A&B with the data of query1

  Solution Accepted Jian-cdo 34 views 2 comments 0 points Most recent by JonWat January 13
• 
  SQL to give Friday of running week

  Solution Accepted karthick.raje 39 views 5 comments 0 points Most recent by RogerT January 13