13,956 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 2 years, 10 months
seen 19 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


Nov
16
comment When using underscores, should they be reserved to junction tables?
CamelCase? Not when using a RDBMS. Everything should be uppercase, I agree with @a_horse_with_no_name on that. Case sensitivity shouldn't come into it.
Nov
12
comment Data are not saved to database - Auto creating new datafile in oracle
Oracle doesn't create data files automatically? Sure you didn't have a script doing this for you?
Nov
12
comment Paging via Number of Result Record vs COUNT(*)
@cgoddard Oracle didn't have LIMIT before 12c came out (you had to use a subquery and rownum), so that probably explains the lack of it :)
Nov
12
comment Get latest status of an item in the database
Which RDBMS are you using?
Nov
12
comment Get latest status of an item in the database
You've also assumed which RDBMS the OP is using. MySQL doesn't support row_number(), for example.
Nov
6
comment Best design to handle multiple query keys
This question appears to be off-topic because it is about performance tuning, given requirements that are restrictive for no good reason. As a result the question cannot be answered
Nov
6
comment Best design to handle multiple query keys
You can change the structure of a single table to anything, yet cannot use more than one table? What is your reasoning, other than that you prefer it? I'll add that many of us on here we're dealing with "big data" before the term was even invented. I suggest you close the question if you're not even willing to listen to reasoned arguments. Even considering using comma seperated values in a column and using LIKE is a terrible solution, for example, but you're willing to give it a go because it uses a single table. Makes zero sense.
Nov
6
comment Cannot remove char 0x00 from NVARCHAR column
This looks like it's going to be a fun question to follow :-)
Oct
30
comment ORACLE Query error contains lots of caret at symbols (i.e. ^@^@^@)
It's probably a CR/LF problem, or some crappy invisible characters in your source file. Take a look at the file in a hex editor. ^@ are normally messed up backspaces I think?
Oct
30
comment Update on table deletes the record
If what you say really is the case, check that it is truly a table and not an updateable view.
Oct
29
comment Simplest way to log in as Oracle user different from schema user and still see all tables,… of schema?
ALTER SESSION SET CURRENT_SCHEMA will work, but you still need to do all of the grants.
Oct
29
comment MySQL UDF - wrong ELF class: ELFCLASS32
That's the problem. Your .so needs to be compiled 64-bit
Oct
29
comment MySQL UDF - wrong ELF class: ELFCLASS32
Not on your shared object udf_median.so - run it against the actual mysql server daemon executable.
Oct
29
comment MySQL UDF - wrong ELF class: ELFCLASS32
Run the file command on the mysql binary to check whether its 32 or 64-bit.
Oct
29
comment Oracle 10gR2 - fix for SSL version following Poodle attack
Think you're going to be out of luck on 10.2 - it's too old.
Oct
29
comment Expdp with metadata_only gives way too large dump. Why?
Hmm, how many tables/indexes are there, and how big are their initial extents? Have the tables got lots of partitions?
Oct
28
comment Why is this SQL query illegal?
Did you even bother looking at the error message? Was it complaining about not being a group by expression? Edit your question with the error message. Help us to help you.
Oct
24
comment Why does this query take 32 sec to execute?
Edit your question with the create table DDL for each table in the query
Oct
23
comment Trying to connect to AWS RDS from an AWS EC2 instance
You need to add MySQL permissions for that user/box combination. There are a million other answers on this site & a google search away for this...
Oct
23
comment Transforming a relation to 3NF
Think logically. The major has to exist so that the student can take it.... So it has to be an entity.