Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

WebSphere to Oracle - doesn't accept correct password

In WebSphere 6.1 I have created a datasource to an Oracle 11g instance using the thin JDBC client. In Oracle I …

oracle jdbc websphere ora-01017
Index on which tablespace

How to find out which 'tablespace' a particular 'index' belongs to. (oracle) (need to use it via jdbc)

database oracle jdbc indexing tablespace
Oracle SQL: select from table with nested table

I wonder how can i make select statement from table which have a typed column ? Type of this column is …

sql oracle oracle10g nested-table
How to use the 'as' keyword to alias a table in Oracle?

I'm trying to execute this query in Oracle SQL Developer: SELECT G.Guest_ID, G.First_Name, G.Last_Name …

sql oracle table-alias
Benefits Of Using SQL Ordinal Position Notation?

Background Information Ordinal position notation, AKA ordinals, is column shorthand based on the column order in the list of columns …

sql sql-server oracle ordinals
How to visualize the relationship of tables in an Oracle database

I know in Access there is a way I can visualize the relationship between tables in a diagram - kind …

database oracle visualization entity-relationship
Why does Oracle varchar2 have a mandatory size as a definition parameter?

I want to know why Oracle needs the size parameter in the definition of the VARCHAR2. I think that is …

oracle varchar2
Oracle CLOB can't insert beyond 4000 character?

How to insert more than 4000 characters to CLOB type column? --create test table s create table s ( a clob ); insert …

oracle insert clob
How to Import Oracle .DMP file into SQL Server?

I have a .dmp file (oracle data) and I have to import this file into SQL Server 2008 R2. I tried …

sql-server oracle import dmp
Where is Oracle sqlplus located?

Background Coming from a mysql background, I find getting started with Oracle quite a different experience. Question Where do I …

mysql sql oracle command-line sqlplus