11,403 reputation
11832
bio website ddbcinc.com
location Rochester Hills, MI
age 37
visits member for 3 years, 3 months
seen 14 hours ago
Oracle ACE

Feb
22
revised Implement a deduplication trigger in Oracle
added 32 characters in body
Feb
6
answered Oracle: How can I add ROWDEPENDENCIES to an existing table?
Feb
1
comment “Table or view does not exist” on synonym
@infoholic_anonymous - You don't need to fully qualify the table name assuming that you are running the script as the table owner.
Feb
1
comment “Table or view does not exist” on synonym
@infoholic_anonymous - I would guess that either you didn't run that line or that you (or someone else) subsequently dropped and re-created the table without granting the appropriate privileges.
Feb
1
comment Create Table with Int-attribute which can only use values between 6 and 36
@Kingalione - Then you've something different than what I suggested. I updated my example to show that the constraint is working.
Feb
1
revised Create Table with Int-attribute which can only use values between 6 and 36
added 589 characters in body
Feb
1
answered “Table or view does not exist” on synonym
Feb
1
answered Create Table with Int-attribute which can only use values between 6 and 36
Feb
1
comment Join Query effects natural ordering
@cecilli0n - I would guess that the tool has some sort of order_by column in a table and is ordering by that column or is storing the "correct" order somewhere else. It's also possible that the tool is relying on some behavior that is not guaranteed to be consistent.
Feb
1
comment Join Query effects natural ordering
@cecilli0n - What does "position in the database" mean to you? The physical order of rows in a heap-organized table is not something you should ever depend on. If you have some idea of a "natural" order, you would need to have a column in the table that captures that information that allows you to sort the data.
Feb
1
answered Join Query effects natural ordering
Jan
29
comment Database is slow once in a while
Statspack doesn't require a license. It does need to be installed in your database. Can you trace the session to see what the wait events are?
Jan
29
comment Database is slow once in a while
Are you licensed to use the performance & tuning packs? Do you have AWR/ Statspack/ ASH data/ reports available to analyze? If 10% of the calls are taking much longer than the average, can you trace the session and see what the wait events are? Is the web service running a simple SELECT statement? Or is it modifying data? If it is modifying data, might the problem be one of locking (i.e. multiple calls all trying to update the same row building up in a queue)?
Jan
29
comment how to change the default date format in oracle
@a_horse_with_no_name - You mean in a to_date call, right, not to_char? Getting the month name in the current NLS settings would seem to be a feature in the to_char call and a potential bug in the to_date call. Of course, you could modify the to_date call to specify the NLS parameters as well to take care of that issue but that gets even more verbose. That's why I would generally much prefer the ANSI literals.
Jan
29
comment how to change the default date format in oracle
That sounds like a separate question. You'd need to create a separate thread for your drop question.
Jan
29
answered how to change the default date format in oracle
Jan
29
comment Table design for departments with duplicate department numbers
So there is a system with an existing employee table that has a dept_id column but there is no existing department table where this value can be looked up? So, currently, you can't determine the name of the department an employee is in?
Jan
29
comment Table design for departments with duplicate department numbers
Are you replicating the employee and department tables from the same system (or two different systems) into a new system that you're building? Or are you re-designing an existing system? How, exactly, would you figure out which department an employee is in using the existing data model? Is that how the existing system really figures out which department an employee is in?
Jan
29
comment Table design for departments with duplicate department numbers
I'm not sure that I follow. If the employee table has just a dept_id and no director_id, how would you ever figure out whether an employee with a dept_id of 4 was in the department name4, name5, or name6?
Jan
29
comment Change all datatypes in a table
@JorgeVegaSánchez - I posted a snippet of PL/SQL, not a complete block. I've updated my answer to be a complete anonymous PL/SQL block (though you'd obviously need to replace the <<table name>> with the actual table name.