Chris Saxon

less info
meta site favicon meta user | stack exchange network profile network profile
1,387 reputation
310
bio website sqlfail.com
location UK
age 32
visits member for 1 year, 11 months
seen 9 hours ago
stats profile views 41

I'm Chris Saxon, an Oracle database specialist with a track record of designing, implementing and optimising Oracle database applications.


42 Answers

newest activity votes
8
Is there any way to break out of the string and inject SQL without using a single quote in oracle?
8
Can I rely on functions being executed first in SQL
6
are there significant differences with 500+ million row tables in Oracle?
6
Learning to Optimize SQL Queries and Understand Execution Plans - Resources?
5
Parsing and binding variables for SELECT .. WHERE column IN ( .. ) queries
5
DBF file exist while user has been dropped?
4
Designing a Products database: One Products table or many separated by vendor?
4
MySQL Database Schema for Train Timetables
4
Can this business logic be enforced by a conditional database constraint?
3
Conceptual Design of a data warehouse (declaring the grain)
3
How and when to use sys_refcursor in oracle
3
Outer Join vs Dummy Rows
3
Is there a bug with PL/Scope in combination with associative arrays?
3
FORALL on Nested Collections
3
This refactoring from cursor on a dblink'ed Oracle table OK?
3
Modifying table structure within a transaction?
3
Rankings based on “versus” style matchups?
2
Most efficient and practical way to store time values (HH:MM) in Oracle that makes it easily searchable
2
How many database licenses do we need for setting 2 servers (nodes) into a cluster?
2
Cardinality rule for bitmap indexes
2
Materialized view for the last 24 hour period
2
Does 'Cities' deserve a separate table?
2
Oracle - capture row commit order in a table
1
Referencing multiple tables from a single table and store additional data
1
Sum Up values in a query based on other information
1
Simple scenario needs to go from Unnormalized Data to 3NF - Review Please
1
What queries is Oracle executing, how frequently, and time-taken?
1
conversion of high_value to date datatype
1
Clustered index in SQL Server vs index organized tables in Oracle
1
In-memory and hard-drive hybrid
1 2