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 7 min ago

Mimicking Sql Server OUTPUT Clause

Wed, 03/07/2018 - 00:00
I am trying converting SQL Server T-SQL queries to Oracle based queries. In SQL Server there is an ability to use the OUTPUT Clause within a query. See example below. BEGIN TRANSACTION DELETE TableA OUTPUT "DELETED".* INTO "TESTARCHIVE"....

Need some suggestion on Special characters.

Tue, 03/06/2018 - 00:00
Hi Tom, I'm using Oracle Database 12c Enterprise Edition Release - 64bit Production. Need some suggestion regarding how to handle special characters. <b>My doubt with converting any special characters to normal character except belo...

ORA-01652: Unable to extend temp segment by 2048 in table space TEMP

Tue, 03/06/2018 - 00:00
Hi Team, We have facing the issue with 1 query is consuming 331GB of TEMP tablespace. WE have configured 340GB of TEMP TS and have some limitation to add more temp files on DB server. due to it the other session get starved with TEMP tablespace an...

Pivoting via SQL

Sat, 03/03/2018 - 00:00
Hai, Tom sir...I have table with columns like this...I have 6 columns in my table with data in below.I need to write an SQL code to get the in below output.Out i mentioned at the ending.Please look at and give me the sol. Create table t3 ( ...