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?
- Modified
- 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?
- Modified
- 16 Aug at 20:12
What does SQL Select symbol || mean?
What does SQL Select symbol || mean? What does `||` do in SQL?
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?
- Modified
- 4 Oct at 13:23
Calling Oracle stored procedure from C#?
Calling Oracle stored procedure from C#? How does one call a stored procedure in oracle from C#?
- Modified
- 9 Sep at 18:31
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?
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:/...
- Modified
- 13 Jun at 06: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.
- Modified
- 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?
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
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?
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?
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.
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?
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
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
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?
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
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
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
SQL Error: ORA-00922: missing or invalid option
SQL Error: ORA-00922: missing or invalid option
- Modified
- 7 Dec at 17:24
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?
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)?
- Modified
- 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?
Is there any boolean type in Oracle databases?
Is there any boolean type in Oracle databases? Is there any Boolean type in Oracle databases, similar to the `BIT` datatype in Ms SQL Server?
- Modified
- 4 Sep at 04:5