User Gary

21 votes

Accepted

Oracle Creating ER Diagrams and Data Dictionaries

answered Jan 28, 2011 at 20:41

13 votes

Accepted

What does 'nls' in nls_date_format stand for?

answered Mar 2, 2011 at 0:19

11 votes

Accepted

Is there any point in undersizing VARCHAR columns?

answered Aug 9, 2011 at 7:07

9 votes

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

answered May 5, 2011 at 10:39

9 votes

How does the Oracle DUAL table work?

answered Jan 11, 2011 at 4:58

7 votes

Accepted

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

answered May 18, 2011 at 23:29

7 votes

Oracle 10g dump file push into Oracle 11g database

answered Jun 29, 2011 at 0:02

6 votes

Searching for a Data Dictionary for SQL or Oracle

answered Mar 8, 2011 at 4:18

6 votes

Accepted

Case Behavior Changed Between 11.2.0.1 and 11.2.0.2

answered Jan 17, 2011 at 22:46

6 votes

Accepted

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

answered Jul 27, 2011 at 5:00

5 votes

Accepted

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

answered Aug 6, 2011 at 10:00

5 votes

Accepted

FBI on function with concatenated string

answered Aug 25, 2011 at 23:14

5 votes

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

answered Jan 25, 2011 at 21:03

5 votes

Oracle monitoring db status

answered Mar 8, 2011 at 4:28

5 votes

Accepted

Can sqlplus fetch more than one row at a time?

answered Sep 17, 2019 at 2:03

5 votes

Accepted

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

answered Feb 19, 2011 at 20:25

4 votes

Accepted

Oracle query against SQL Server database giving inconsistent results

answered Mar 21, 2011 at 22:35

4 votes

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

answered Feb 16, 2011 at 2:35

4 votes

Best way to delete very large recordset in Oracle

answered Jan 19, 2011 at 22:17

3 votes

Accepted

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

answered Jan 28, 2011 at 20:36

3 votes

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

answered May 28, 2011 at 0:37

3 votes

Accepted

SQL*Plus default output format

answered Aug 27, 2013 at 0:39

3 votes

Accepted

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

answered Oct 17, 2016 at 1:10

2 votes

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

answered Sep 21, 2010 at 5:10

2 votes

Oracle 11g delete by unique key slow

answered Apr 30, 2013 at 4:03

2 votes

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

answered Aug 23, 2011 at 0:12

2 votes

Detect Index Coalesce

answered Jan 25, 2011 at 20:58

2 votes

Accepted

Procedure "undeclared" despite execute being granted

answered Nov 15, 2016 at 23:56

1 vote

Accepted

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

answered Oct 6, 2019 at 1:42

1 vote

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

answered Nov 12, 2019 at 3:03

Stack Exchange Network

44 Answers

Oracle Creating ER Diagrams and Data Dictionaries

What does 'nls' in nls_date_format stand for?

Is there any point in undersizing VARCHAR columns?

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

How does the Oracle DUAL table work?

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

Oracle 10g dump file push into Oracle 11g database

Searching for a Data Dictionary for SQL or Oracle

Case Behavior Changed Between 11.2.0.1 and 11.2.0.2

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

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

FBI on function with concatenated string

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

Oracle monitoring db status

Can sqlplus fetch more than one row at a time?

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

Oracle query against SQL Server database giving inconsistent results

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

Best way to delete very large recordset in Oracle

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

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

SQL*Plus default output format

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

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

Oracle 11g delete by unique key slow

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

Detect Index Coalesce

Procedure "undeclared" despite execute being granted

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

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