Gary's user avatar
Gary's user avatar
Gary's user avatar
Gary
  • Member for 13 years, 1 month
  • Last seen more than a week ago
21 votes
Accepted

Oracle Creating ER Diagrams and Data Dictionaries

12 votes
Accepted

What does 'nls' in nls_date_format stand for?

11 votes
Accepted

Is there any point in undersizing VARCHAR columns?

9 votes

What features of Oracle make it an attractive choice for small projects?

9 votes

How does the Oracle DUAL table work?

7 votes
Accepted

How to extract Procedure, Function, etc. Source Code from an Oracle Export

7 votes

Oracle 10g dump file push into Oracle 11g database

6 votes

Searching for a Data Dictionary for SQL or Oracle

6 votes
Accepted

Case Behavior Changed Between 11.2.0.1 and 11.2.0.2

6 votes
Accepted

When creating views, why do users need direct object permissions if they already have the same permissions via a role?

5 votes
Accepted

When installing Oracle, what's the quickest way to check rpm packages and install what is missing?

5 votes
Accepted

FBI on function with concatenated string

5 votes

Why won't some DBMS's allow rollback for certain DDL statements?

5 votes

Oracle monitoring db status

5 votes
Accepted

How can I catch the output of DBMS_OUTPUT.PUT_LINE when executing a block using [Oracle.DataAccess.Client]?

5 votes
Accepted

Can sqlplus fetch more than one row at a time?

4 votes
Accepted

Oracle query against SQL Server database giving inconsistent results

4 votes

Best method to give two Oracle databases on the same server access to common data

4 votes

Best way to delete very large recordset in Oracle

3 votes
Accepted

Local package won't compile when remote package recompiles. (Oracle)

3 votes

Oracle - Any way to view uncommited changes to a particular table?

3 votes
Accepted

SQL*Plus default output format

3 votes
Accepted

How can I restore a 10.91G table in Oracle Express?

2 votes
Accepted

Procedure "undeclared" despite execute being granted

2 votes

Oracle 11g delete by unique key slow

2 votes

Options for dumping Oracle queries to text files with no database server filesystem access

2 votes

Detect Index Coalesce

2 votes

Does SQL Server guarantee accurate data storage? If so, how?

1 vote
Accepted

Oracle - How to issue desc command in a procedure within package?

1 vote

Oracle 12c and Jobs running one hour apart after changing time for hourly use