Questions tagged [oracle11g]

Oracle is an Object-relational Database Management System (ORDBMS) created by Oracle Corporation. Specific releases of the product are known as Oracle9i, Oracle10g, Oracle 11g and Oracle 12c, where "i", "g" and "c" stand for "internet", "grid" and "cloud" respectively. Generally there are two releases within each major version. Questions tagged [oracle11g] are assumed to be specific to this version or features introduced in this version.

There are two releases of the Oracle 11g ORDBMS software, 11gR1 and 11gR2. Questions tagged with are assumed to be specific to this version or features introduced in this version. It is generally advisable to specify the full database version (e.g. 11.2.0.2) and it is often useful to include the underlying operating system.

Oracle Corporation discontinued support for 11g as of 31-Dec-2020.

Questions for 11.1.x should be tagged and questions specific to 11.2.x should be tagged

Questions should probably be additionally tagged for the widest readership.

Questions about SQL in general should probably be tagged .

Questions about PL/SQL in particular should probably be tagged as well as .

Questions concerning installation or operation may be asked at Server Fault.

Oracle's documentation is quite extensive, and answers to many questions can be found there. It can be found at:

20282 questions
326
votes
31 answers

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly…
Jacques
  • 6,936
  • 8
  • 43
  • 102
292
votes
9 answers

How do I do top 1 in Oracle?

How do I do the following? select top 1 Fname from MyTbl In Oracle 11g?
Gold
  • 60,526
  • 100
  • 215
  • 315
137
votes
8 answers

Display names of all constraints for a table in Oracle SQL

I have defined a name for each of the constraint for the multiple tables that I have created in Oracle SQL. The problem is that to drop a constraint for the column of a particular table I need to know the name that I have supplied for each…
Jeris
  • 2,355
  • 4
  • 26
  • 38
118
votes
5 answers

How to create a new database after initally installing oracle database 11g Express Edition?

I have installed Oracle Database 11g Express Edition on my pc (windows 7) and I have installed Oracle SQL Developer as well. I want to create a simple database to start with, maybe with one table or two and then use Oracle SQL Developer to insert…
Zo72
  • 14,593
  • 17
  • 71
  • 103
114
votes
2 answers

Difference between oracle DATE and TIMESTAMP

What are the difference between Oracle DATE and TIMESTAMP type? Both have date and time component? Also what is corresponding type in Java for these date types?
supernova
  • 3,111
  • 4
  • 33
  • 30
107
votes
5 answers

Hibernate dialect for Oracle Database 11g?

Is there a Hibernate dialect for Oracle Database 11g? Or should I use the org.hibernate.dialect.Oracle10gDialect that ships with Hibernate?
Landon Kuhn
  • 76,451
  • 45
  • 104
  • 130
97
votes
15 answers

Where does Oracle SQL Developer store connections?

I have an application that I can't get connected to my Oracle Database 11g Express Edition. I created a test database in this edition, and I can connect to the database fine using Oracle SQL Developer, create tables, views etc. However, I'm having a…
Shane
  • 1,325
  • 3
  • 12
  • 18
92
votes
5 answers

How to display databases in Oracle 11g using SQL*Plus

With help of this command show databases; I can see databases in MySQL. How to show the available databases in Oracle?
Nubkadiya
  • 3,285
  • 13
  • 40
  • 45
91
votes
5 answers

How to create a new schema/new user in Oracle Database 11g?

I have applied for an internship in a company and as a question they have asked me to create a schema for their company with certain requirements and mail them the DDL file. I have installed Oracle database 11g Express edition, but how do I create a…
acoder
  • 1,045
  • 1
  • 8
  • 5
84
votes
17 answers

ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying

When I try to query objects, I end up with following error: ORA-01461: can bind a LONG value only for insert into a LONG column Could someone please help me on the cause and solution of the problem?
Rupesh
  • 983
  • 3
  • 11
  • 20
84
votes
4 answers

Default passwords of Oracle 11g?

I installed Oracle 11g. I didn't change the passwords for SYSTEM and SYS. However now I find that the default passwords do not work. Please help.
Xolve
  • 22,298
  • 21
  • 77
  • 125
84
votes
3 answers

Left Outer Join using + sign in Oracle 11g

Can any one tell me whether below 2 queries are an example of Left Outer Join or Right Outer Join?? Table Part: Name Null? Type PART_ID NOT NULL VARCHAR2(4) SUPPLIER_ID VARCHAR2(4) PART_ID SUPPLIER_ID P1 …
Mike
  • 7,606
  • 25
  • 65
  • 82
81
votes
3 answers

How to import an Oracle database from dmp file and log file?

How would I go about creating a database from a dump file? I do not have an existing database with the same structure on my system so it has to be complete with jobs, events, tables, and so on. I placed the dump and log file in E: drive I have tried…
praveenb
  • 10,549
  • 14
  • 61
  • 83
80
votes
9 answers

How to create a user in Oracle 11g and grant permissions

Can someone advise me on how to create a user in Oracle 11g and only grant that user the ability only to execute one particular stored procedure and the tables in that procedure. I am not really sure how to do this!
Andy5
  • 2,319
  • 11
  • 45
  • 91
80
votes
4 answers

How to uninstall / completely remove Oracle 11g (client)?

How to uninstall or completely remove Oracle 11g (client)? Running deinstall.bat doesn't work. Edit: Further discussion related to why this question was closed and deleted: Why was this question related to uninstalling the Oracle Database Client…
Yves
  • 12,059
  • 15
  • 53
  • 57
1
2 3
99 100