User miracle173

71 votes

Accepted

How to make sqlplus output appear in one line?

answered May 7, 2014 at 5:45

14 votes

Accepted

Convert a Unix timestamp to a DATETIME in a View

answered Apr 13, 2012 at 7:02

13 votes

Accepted

Can I combine the results from multiple columns into a single column without UNION?

answered Jul 27, 2015 at 19:09

11 votes

Accepted

How to tune the query on all_constraints in Oracle 12c?

answered Sep 10, 2015 at 8:23

10 votes

Accepted

Why isn't oracle using an index for distinct query ?

answered Aug 14, 2013 at 9:05

6 votes

Accepted

Why are some aggregates treated differently in the RHS of a rule in the model clause?

answered Aug 18, 2013 at 20:56

6 votes

Update year alone in date (Oracle 11g)

answered Aug 23, 2013 at 13:23

6 votes

I have a powerful machine with 70 GB RAM. How many Oracle instances with 20 GB can be created?

answered May 3, 2012 at 10:17

6 votes

Accepted

Database Design (Stores + Products)

answered Aug 5, 2012 at 13:08

6 votes

DISTINCT not using an index

answered Apr 17, 2014 at 22:41

6 votes

How to handle big data update based on excel spreadsheet

answered Dec 3, 2014 at 9:04

6 votes

Query to get ORACLE_HOME path in Oracle 11G

answered Apr 9, 2015 at 9:25

6 votes

Accepted

Is there a shortcut for 'SELECT * FROM table' in relational algebra?

answered Jan 27, 2018 at 4:33

5 votes

Accepted

mysql query only works when value is compared with primary key

answered May 17, 2017 at 19:06

5 votes

Why the term "relation(al)"?

answered May 21, 2017 at 18:34

5 votes

Accepted

Are three equalities on a join operation legal in relational algebra?

answered Mar 15, 2016 at 2:19

5 votes

Materialized view became INVALID and USER_MVIEWS.COMPILE_STATE becomes 'NEEDS_COMPILE'

answered Jan 9, 2018 at 12:31

5 votes

ORA-03113 when starting up an Oracle 11g database

answered Nov 17, 2018 at 21:44

5 votes

How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora

answered Dec 14, 2014 at 1:52

5 votes

Accepted

Why MAX() of SUM() giving wrong output?

answered Aug 24, 2014 at 0:34

5 votes

Oracle SQL Developer 4: how to tell under which user I connected

answered Mar 20, 2014 at 23:28

5 votes

Accepted

Oracle optional select value

answered May 12, 2014 at 4:33

5 votes

Accepted

How to reference a table from another schema inside a package?

answered Jun 19, 2014 at 3:49

5 votes

Accepted

Oracle: How can I track the progress of an index rebuild?

answered Sep 8, 2015 at 17:20

5 votes

Why would I need a third table in a one-to-many relationship?

answered Jul 31, 2015 at 7:56

5 votes

Accepted

ORA-01031 while creating a view as DBA

answered Aug 12, 2013 at 18:20

5 votes

Database Design - One table from many source(One to One)

answered Jan 4, 2013 at 15:24

4 votes

Accepted

The four properties of a primary key

answered Dec 4, 2012 at 7:33

4 votes

sqlnet.ora or tnsnames.ora changes require reboot?

answered Oct 24, 2012 at 19:09

4 votes

Estimate a Database Size

answered Aug 27, 2012 at 15:21

Stack Exchange Network

248 Answers

How to make sqlplus output appear in one line?

Convert a Unix timestamp to a DATETIME in a View

Can I combine the results from multiple columns into a single column without UNION?

How to tune the query on all_constraints in Oracle 12c?

Why isn't oracle using an index for distinct query ?

Why are some aggregates treated differently in the RHS of a rule in the model clause?

Update year alone in date (Oracle 11g)

I have a powerful machine with 70 GB RAM. How many Oracle instances with 20 GB can be created?

Database Design (Stores + Products)

DISTINCT not using an index

How to handle big data update based on excel spreadsheet

Query to get ORACLE_HOME path in Oracle 11G

Is there a shortcut for 'SELECT * FROM table' in relational algebra?

mysql query only works when value is compared with primary key

Why the term "relation(al)"?

Are three equalities on a join operation legal in relational algebra?

Materialized view became INVALID and USER_MVIEWS.COMPILE_STATE becomes 'NEEDS_COMPILE'

ORA-03113 when starting up an Oracle 11g database

How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora

Why MAX() of SUM() giving wrong output?

Oracle SQL Developer 4: how to tell under which user I connected

Oracle optional select value

How to reference a table from another schema inside a package?

Oracle: How can I track the progress of an index rebuild?

Why would I need a third table in a one-to-many relationship?

ORA-01031 while creating a view as DBA

Database Design - One table from many source(One to One)

The four properties of a primary key

sqlnet.ora or tnsnames.ora changes require reboot?

Estimate a Database Size