Feed aggregator

using max function

AskTom - Hot Questions - Sun, 03/18/2018 - 00:00
Hi, Look at here..... Find highest salary in each department without using MAX function. Note:- Use a single SELECT statement only. For an added complexity (optional): try not using ANY functions a...

Mimicking Sql Server OUTPUT Clause

AskTom - Hot Questions - 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.

AskTom - Hot Questions - 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

AskTom - Hot Questions - 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

AskTom - Hot Questions - 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 ( ...