meta user
network profile
| bio | website | sqlfail.com |
|---|---|---|
| location | UK | |
| age | 32 | |
| visits | member for | 1 year, 10 months |
| seen | 19 hours ago | |
| stats | profile views | 40 |
I'm Chris Saxon, an Oracle database specialist with a track record of designing, implementing and optimising Oracle database applications.
|
2d |
comment |
Database table design question Are you just trying to audit what has happened or do you need to show which lines were assigned to a particular PO/container at a given point in time? |
|
2d |
comment |
Oracle PL SQL EXTREMEMLY slow FETCH performance Please post the results of an sql trace for the sessions including the wait information - this will help us see what's different. That said, I'm pretty sure you can get rid of most/all of the PL/SQL here which may solve the issue for you anyway. |
|
May 14 |
answered | Most efficient and practical way to store time values (HH:MM) in Oracle that makes it easily searchable |
|
May 14 |
awarded | Caucus |
|
Apr 28 |
comment |
Oracle 11g delete by unique key slow Are there any updates taking place on this table? If so, is it possible that the updates are blocking the delete? Also, how large is the table? |
|
Apr 25 |
awarded | Citizen Patrol |
|
Apr 16 |
answered | Referencing multiple tables from a single table and store additional data |
|
Apr 15 |
comment |
“Variant” values structure and their use for multiple columns @gab - while having one column storing multiple different types is a bad idea, having some other structure to enforce types will be difficult to implement and enforce. It's this additional structure that I believe is a terrible idea. As Colin asks, please show us the real use case you're implementing. |
|
Apr 14 |
comment |
Db design for historical option data (~200GB) I think this covers things well, though moving historical data to a separate table isn't necessarily denormalization unless this removes non-prime dependencies. Also I wouldn't reject an "is_current" flag out of hand - I've seen cases where this is very effective. |
|
Apr 11 |
comment |
“Variant” values structure and their use for multiple columns I'm confused by what you're trying to do too. Do you have a single column which is used to store numbers, dates, etc. and you're trying to enforce the datatype using referential integrity? If so, this is a terrible idea. |
|
Apr 11 |
comment |
Why is a “non-single-group group function” allowed in a subselect but not on it's own? Which PSU of 11.2.0.3 are you on? I see the incorrect behaviour on 11.2.0.3.4 |
|
Apr 11 |
comment |
Why is a “non-single-group group function” allowed in a subselect but not on it's own? I noticed this myself the other day running 11.2.0.3.4 |
|
Apr 9 |
comment |
How can we hide our procedures in Oracle? Hide what from who? Do you want to prevent people reading the source files, or just the code compiled into the database? |
|
Apr 4 |
revised |
How do I design a database for a resource scheduling and allocation application? Added example queries, expanded discussion of benefits of enter/day |
|
Apr 1 |
answered | How do I design a database for a resource scheduling and allocation application? |
|
Mar 17 |
answered | PRIMARY KEY CONSTRAINT fundamentals |
|
Mar 12 |
answered | Sum Up values in a query based on other information |
|
Mar 11 |
revised |
Simple scenario needs to go from Unnormalized Data to 3NF - Review Please spelling |
|
Mar 10 |
answered | Simple scenario needs to go from Unnormalized Data to 3NF - Review Please |
|
Mar 8 |
comment |
SQL Uniqueness Across Multiple Tables @AlexKuznetsov - yep, that would work. |
