AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 2 hours 23 sec ago

inserting a complex xml into database

Sat, 02/27/2016 - 00:00
hi i am able to insert a simple xml into table as INSERT INTO EmployeeXML(EMPID,EmpName) WITH t AS (SELECT xmltype(bfilename('MY_DIR7','employee.xml'), nls_charset_id('WE8ISO8859P1')) xmlcol FROM dual) SELECT extractValue(value(x),'/ROW/...

Updating a table using select

Thu, 02/25/2016 - 00:00
SELECT TEMP.unqid,TEMP.MD_DT FROM ( SELECT t2.unqid AS unqid,t2.MD_DT AS MD_DT, ROW_NUMBER() OVER (PARTITION BY t2.unqid ORDER BY t2.MD_DT DESC) AS ROW_ID FROM t2, t1 WHERE t2.x = 'x' AND t2.y = 'y' AND t2.MD_DT IS NOT NULL AND t1.unqid=t2.u...

a sql code to remove all the special characters from a particular column of a table

Thu, 02/25/2016 - 00:00
a sql code to remove all the special characters from a particular column of a table . for example : iNPUT-ABC -D.E.F OUTPUT ABC DEF AND IF THERE IS TWO NAMES LIKE ABC PRIVATE LTD ONE SPACE SHOULD BE MAINTAINED BETWEEN 2 WORDS.

query issue

Tue, 02/23/2016 - 00:00
Hello everyone! I have a puzzle that has stumped me. I have played with variations of nested selects, hierarchical queries, analytic functions, and have gotten close to what I need, but not all the way there. I am sure that I am missing something...

Partitioning Options

Mon, 02/22/2016 - 00:00
I have a database with a single table that holds historic BLOB data so this table is quite large currently (1.2TB). I range partitioned based on the ID my PK (no date column exists for this table) and am making all but the current partition read-onl...

Date functions for Zulu time format

Wed, 02/17/2016 - 00:00
Hi i have a question i have a date field for which i am inserting date as 'DDHH24MI"Z"MONRR', for example it may be 230000ZJUN13. Now i want to increment this date by .25 of the day such as " select to_char(dated,'DDHH24MI"Z"MONRR')+.25 from...

update using bulk collect in plsql with exit when statement ,plsql script to run code in batches of 500 with some update statement

Fri, 02/12/2016 - 00:00
here is a table having 2000 records i need to update the table with some given condition update tablename set counter=1 where counter=null and rownum<500 for first execution so that counter should be 4 at last of 2000 rows execution,EXIT WHEN counter...