Questions tagged [oracle]

Oracle 10g express home page is not coming up My Oracle 10g Express Edition , I can login in the SQL plus but I cannot login into oracle via SQL developer and cannot view the Home page at link [http:/...

Modified: 13 Jun at 06:1

253 votes

0 answers

265.3k views

What is the dual table in Oracle?

What is the dual table in Oracle? I've heard people referring to this table and was not sure what it was about.

Modified: 4 Dec at 20:14

181 votes

0 answers

742k views

How do I list all tables in a schema in Oracle SQL?

How do I list all tables in a schema in Oracle SQL? How do i list all tables in a schema in Oracle SQL?

Modified: 11 Feb at 19:58

54 votes

0 answers

215.6k views

Find the server name for an Oracle database

Find the server name for an Oracle database Is there a way of finding the name of the server an Oracle database is hosted on?

Modified: 24 Jan at 14:19

62 votes

0 answers

191.8k views

Oracle: SQL query to find all the triggers belonging to the tables?

Oracle: SQL query to find all the triggers belonging to the tables? how can i find all the triggers that belong to a table?

Modified: 20 Jul at 11:46

70 votes

0 answers

459.7k views

Calculating difference between two timestamps in Oracle in milliseconds

Calculating difference between two timestamps in Oracle in milliseconds How do I calculate the time difference in milliseconds between two timestamps in Oracle?

Modified: 23 Jul at 18:13

131 votes

0 answers

198.7k views

Change Oracle port from port 8080

Change Oracle port from port 8080 How do I change Oracle from port 8080? My Eclipse is using 8080, so I can't use that.

Modified: 26 Mar at 06:14

5 votes

0 answers

256k views

How to find top three highest salary in emp table in oracle?

How to find top three highest salary in emp table in oracle? How to find top three highest salary in `emp` table in oracle?

Modified: 5 Jul at 15:29

54 votes

0 answers

268.7k views

How to know installed Oracle Client is 32 bit or 64 bit?

How to know installed Oracle Client is 32 bit or 64 bit? OS: Windows 2008 Server R2 Oracle Client: 11.2 Many Thanks

Modified: 2 Nov at 02:57

217 votes

0 answers

307.6k views

What is the maximum length of a table name in Oracle?

What is the maximum length of a table name in Oracle? What are the maximum length of a table name and column name in Oracle?

Modified: 8 Apr at 11:26

12 votes

0 answers

159.1k views

Oracle: how to set user password unexpire?

Oracle: how to set user password unexpire? There is some construction But how can I similair set password to unexpired state?

Modified: 19 Nov at 20:53

107 votes

0 answers

142.7k views

Get table name by constraint name

Get table name by constraint name Oracle constraint name is known. How do I find the name of the table for which this constraint is applied?

Modified: 1 Nov at 23:0

419 votes

0 answers

751.9k views

What is the difference between Views and Materialized Views in Oracle?

What is the difference between Views and Materialized Views in Oracle? What is the difference between Views and Materialized Views in Oracle?

Modified: 24 Dec at 19:58

27 votes

0 answers

133.8k views

SQL query to find Primary Key of a table?

SQL query to find Primary Key of a table? How can I find which column is the of a table by using a query?

Modified: 11 Sep at 23:42

4 votes

0 answers

148.4k views

SQL Error: ORA-00922: missing or invalid option

Modified: 7 Dec at 17:24

17 votes

0 answers

220.2k views

How do I import a .dmp file into Oracle?

How do I import a .dmp file into Oracle? I have a `.dmp` file that I would like to import into Oracle 9i. How do I do that?

Modified: 19 Mar at 08:25

47 votes

0 answers

250.2k views

Oracle - How to generate script from sql developer

Oracle - How to generate script from sql developer How to take script for schema of the tables, stored procedures of Oracle through SQL Developer tool (SQLPLUS command line interface)?