Stack Exchange

Gary Myers

Sydney, Australia

blog.sydoracle.com

Age: 43

Oracle developer in Sydney, Australia

top accounts reputation activity favorites subscriptions
Top Questions
Top Answers
36
Oracle Differences between NVL and Coalesce
stackoverflow.com

15
Oracle Creating ER Diagrams and Data Dictionaries
dba.stackexchange.com

12
Limiting returned record from SQL query in Oracle
stackoverflow.com

12
Why do sites implement locking after 3 failed password attempts?
security.stackexchange.com

11
Differences between SQL Plus and “regular” SQL?
stackoverflow.com

10
Why oracle does not have autoincrement feature for primary keys?
stackoverflow.com

10
Why does SQL*Plus commit on exit?
stackoverflow.com

10
XML Return from an Oracle Stored Procedure
stackoverflow.com

10
Difference between implicit and explicit cursors in Oracle
stackoverflow.com

10
Simple constraint to limit an Oracle table to a single row
stackoverflow.com

10
Oracle performance problem
serverfault.com

9
Oracle PL/SQL: Any benefits in changing PLSQL_CODE_TYPE from interpreted to native?
stackoverflow.com

9
Oracle: Use of notational parameters which calling functions in insert statements not allowed?
stackoverflow.com

9
AUTONOMOUS_TRANSACTION: pros and cons
stackoverflow.com

9
How can I conditionally construct a table name for an SQL CREATE TABLE statement?
stackoverflow.com

9
How to run Oracle query with begin/end in SQL*Plus?
stackoverflow.com

9
Is there any point in undersizing VARCHAR columns?
dba.stackexchange.com

8
Table-Valued Functions in ORACLE 11g ? ( parameterized views )
stackoverflow.com

8
Default Schema in Oracle Connection URL
stackoverflow.com

8
Oracle DDL in autonomous transaction
stackoverflow.com

8
PL/SQL: Find the server name for an Oracle database
stackoverflow.com

8
Can't drop table that was just created
stackoverflow.com

8
Oracle debugging techniques
stackoverflow.com

8
Sorting in UNION
stackoverflow.com

8
SELECT query with OFFSET in ORACLE
stackoverflow.com

8
What does 'nls' in nls_date_format stand for?
dba.stackexchange.com

8
What features of Oracle make it an attractive choice for small projects?
dba.stackexchange.com

7
What tablespace are Oracle sequences stored in?
stackoverflow.com

7
How can I tell if I have uncommitted work in an Oracle transaction?
stackoverflow.com

7
How to index Y/N column in Oracle
stackoverflow.com

1 2 3 4