tagged [oracle]

What is the difference between varchar and varchar2 in Oracle?

What is the difference between varchar and varchar2 in Oracle? What is the difference between varchar and varchar2?

2 Sep at 13:14

Is there a free GUI management tool for Oracle Database Express?

Is there a free GUI management tool for Oracle Database Express? Like Microsoft SQL Server Management Studio for MSSQL?

16 Aug at 20:12

What does SQL Select symbol || mean?

What does SQL Select symbol || mean? What does `||` do in SQL?

14 Oct at 14:5

Can we update primary key values of a table?

Can we update primary key values of a table? Can we update primary key values of a table?

4 Oct at 13:23

Oracle 10g express home page is not coming up

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:/...

Calling Oracle stored procedure from C#?

Calling Oracle stored procedure from C#? How does one call a stored procedure in oracle from C#?

How to rename a table column in Oracle 10g

How to rename a table column in Oracle 10g I would like to know: How to rename a table column in Oracle 10g?

23 Jul at 23:1

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.

4 Dec at 20:14

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?

11 Feb at 19:58

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?

24 Jan at 14:19

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?

20 Jul at 11:46

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?

23 Jul at 18:13

SQL Error: ORA-00922: missing or invalid option

SQL Error: ORA-00922: missing or invalid option

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.

26 Mar at 06:14

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?

5 Jul at 15:29

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

2 Nov at 02:57

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?

8 Apr at 11:26

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?

19 Nov at 20:53

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?

1 Nov at 23:0

Extract number from string with Oracle function

Extract number from string with Oracle function I need to create an Oracle DB function that takes a string as parameter. The string contains letters and numbers. I need to extract all the numbers from...

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?

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?

11 Sep at 23:42

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?

19 Mar at 08:25

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)?

8 Aug at 10:47

SQL to generate a list of numbers from 1 to 100

SQL to generate a list of numbers from 1 to 100 Using the DUAL table, how can I get a list of numbers from 1 to 100?

17 May at 07:51