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

after update count of executed updates

Thu, 02/16/2017 - 00:00
I have a script executed in SQL*PLUS command line that should give out the summ of all real updated rows from the WHERE clause after all update executes simiilar as on execute update command directely in SQL*Plus with "1 row updated". But the fol...

char (10) data type hosting numeric data for natural keys

Thu, 02/16/2017 - 00:00
Hi, Can you please provide some guidance on the possible performance issue one might have in creating a char(10) data type that hosts natural keys? Also, I'm baffled by the following results.. THIS WORKS FINE even char(10) blank pads the ...

Optimizer Dynamic Sampling at OPTIMIZER_DYAMIC_SAMPLING level 2

Wed, 02/15/2017 - 00:00
At my Oracle Oracle Standard Edition database, at OPTIMIZER_DYNAMIC_SAMPLING = 2 which is the default, I see Dynamic Sampling is happening for some of the SQLs for which all tables already have already gathered table statistics. Due to this,...

How to extract substrings enclosed within double quotes from a string

Sun, 02/12/2017 - 00:00
I have a requirement to extract column names (there could be multiple instances) from a SQL string. The column names will always be enclosed within double quotes. e.g. "le code" = 802 AND "principal amount" > 1200 OR "branch id" = 'ABC' <b>Req...

What is your salary ?

Fri, 02/10/2017 - 00:00
Tom, WHat is your salary? Thanks

please help me

Thu, 02/09/2017 - 00:00
simply retrieving a table using table name dynamically DECLARE TABL_NAME VARCHAR2(255):='MY_DETAILS'; STRNG VARCHAR2(255); begin STRNG :='SELECT * FROM' || TABL_NAME; DBMS_SQL.PARSE (STRNG); END; im new to sql please help why this simple ...

Shuffle values randomly in columns

Tue, 02/07/2017 - 00:00
Note - this is more of an academic question as I have a resolution, I am just keen to see whether my alternative approach is possible. I have a HR table with a list of names. For demo purposes I needed to shuffle these around to make them a bit mo...