| Description: These are the questions on Ask Tom that have the most comments |
| Put this feed on your website |
| Format: |
RSS 0.91 |
| Feed Url: |
|
 |
Subscribe feed with:

  

|
| Site Url: |
http://asktom.oracle.com |
| Latest headlines from : Ask Tom HOT ARTICLES |
|
Question on CONCAT
2008-11-11
Hi Tom,
Good Morning...
In my Procedure.
<code>CONCAT(<SQL_QUERY>,<CASE_STATEMENT>)</code> is not working
but
<code><SQL_QUER>||<CASE_STATEMENT></code> is working
Why??
Permalink: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1307923100346917177
Add This News on my : Facebook |
Del.ico.us
|
Digg!
| Google
| Yahoo
|
ORA-00001: unique constraint (GIGAGAME.PLAYERINFO_IDX2) violated
2008-10-29
Hi Tom
I have problem need to help
My Company RD TESTING FIND THE PROBLEM
ORA-00001: unique constraint (GIGAGAME.PLAYERINFO_IDX2) violated
HOW CAN I RESOLVE PROBLEM
Tks
schema ???
DROP TABLE PlayerInfo;
CREATE TABLE PlayerInfo
(
CID... Permalink: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1277450200346535934
Add This News on my : Facebook |
Del.ico.us
|
Digg!
| Google
| Yahoo
|
How to tune access of "fat" tables
2008-10-29
Hello Tom,
I'm working at a client's site who has a data warehouse with partitioned fact tables with about 400 columns. Performance is not too good and I am trying to optimize the system a bit.
The client told me that most of the columns are quer... Permalink: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1277688700346608142
Add This News on my : Facebook |
Del.ico.us
|
Digg!
| Google
| Yahoo
|
Restoring Stats and Execution Plans
2008-10-28
Hey Tom,
We recently had a query (using bind variables) whose plan flipped after our nightly stats gathering process due to bind variable peeking. We were hoping that by restoring stats to the previous day (on all the tables included in the query... Permalink: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1276893600346501741
Add This News on my : Facebook |
Del.ico.us
|
Digg!
| Google
| Yahoo
|
oracle is doing full table scans on a table with raw column and the column is primary key
2008-10-28
Hi Tom,
Thanks for your continuous support.
We have a table with blob data type as one column. We are using secure file option as we are using 11g. We kept the blob column in a seperate tablespace. In the main table we have a column called... Permalink: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1277166300346684168
Add This News on my : Facebook |
Del.ico.us
|
Digg!
| Google
| Yahoo
|
Spfile Question
2008-10-28
I m a beginner in field of oracle .
Consider a spfile , now if i make changes to the parameters in this during the running instance (using alter system set parameter....), will this change be applied in current running instance or will it be applie... Permalink: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1276933800346630967
Add This News on my : Facebook |
Del.ico.us
|
Digg!
| Google
| Yahoo
|
Trying to select rows which got certain attributes
2008-10-28
Hi
I have the following situation. My table got the following data
SR_WID activity_type activity_subtype
1 Maintenance Break fix
1 Install startup
2 Install startup
3 Install startup
3... Permalink: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1277035500346087466
Add This News on my : Facebook |
Del.ico.us
|
Digg!
| Google
| Yahoo
|
SQL*Plus IN/LIKE Capability
2008-10-27
<code>
Tom,
In sql*plus we can do an IN...
select * from x
where animals IN ('DOG', 'CAT', 'RAT')
/
Or we can do a LIKE...
select * from x
where animals LIKE ('%OG')
But if we want BOTH we have to do this...
select * from x
wh... Permalink: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1273740600346432580
Add This News on my : Facebook |
Del.ico.us
|
Digg!
| Google
| Yahoo
|
Database Backup Strategy
2008-10-26
Tom,
Because of a situation with one of our production databases we are in the midst of rethinking our entire database backup strategy.
It seems that regular, routine test recovery of a backup from tape for all production databases is the only ... Permalink: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1270903900346886878
Add This News on my : Facebook |
Del.ico.us
|
Digg!
| Google
| Yahoo
|
A tough status problem needs help
2008-10-26
Tom, I believe I did NOT make this thru last time(my computer crashed last time right after submit this question), and I still did NOT receive your response, so I give it another try, please ignore this if you already received this very same question... Permalink: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1271665000346482306
Add This News on my : Facebook |
Del.ico.us
|
Digg!
| Google
| Yahoo
|