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: 32 min 43 sec 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...