11,997 reputation
11833
bio website ddbcinc.com
location Rochester Hills, MI
age 38
visits member for 3 years, 7 months
seen 3 hours ago
Oracle ACE

Feb
25
answered How to compare a result of a query to a number?
Feb
25
comment Using CURSOR in Oracle 11g database to locate all matches for specifed string in DB
@Mikhail - The answer I gave on StackOverflow should work. It'll be slow as dirt. But it will work.
Feb
24
answered Using CURSOR in Oracle 11g database to locate all matches for specifed string in DB
Feb
24
comment Using CURSOR in Oracle 11g database to locate all matches for specifed string in DB
Are you looking for cases where a string exists in a column name? In a table name? Or in some row somewhere in the table?
Feb
23
comment Oracle data obfuscation on specific columns with set field sizes
What is the business problem you are trying to solve? Are you trying to obfuscate data in the test environment? Or prevent certain users from seing unobfuscated data in prod? Or preventing system admins or folks that get their hands on backup tapes from being able to see sensitive data? What version of Oracle?
Feb
22
comment Implement a deduplication trigger in Oracle
@user60216 - If the third party vendor can call stored procedures rather than issuing INSERT statements, yes, you could use stored procedures.
Feb
22
answered Implement a deduplication trigger in Oracle
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)?