Top "Oracle11g" questions

Oracle is an Object-relational Database Management System (ORDBMS) created by Oracle Corporation.

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 oracle11g sqlplus
Calling a stored procedure in Oracle with IN and OUT parameters

I have this procedure: CREATE OR REPLACE PROCEDURE PROC1(invoicenr IN NUMBER, amnt OUT NUMBER) AS BEGIN SELECT AMOUNT INTO …

sql oracle11g
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

I am getting the above error when trying to connect to a server database from a client using service name …

oracle oracle11g ora-01034 ora-27101
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 …

oracle oracle11g oracle-sqldeveloper oracle-xe
Where to get this Java.exe file for a SQL Developer installation

I just installed Oracle 11g, and tried to start Oracle SQL developer so as to start writing queries. It is …

oracle11g oracle-sqldeveloper
IO Error: The Network Adapter could not establish the connection

I am new to Oracle, and am trying to run a simple example code with Java, but am getting this …

java windows-7 jdbc oracle11g bootcamp
Timestamp conversion in Oracle for YYYY-MM-DD HH:MM:SS format

I'm trying to insert records with YYYY-MM-DD HH:MM:SS format into Oracle from Netezza, but I'm getting invalid date …

sql oracle oracle11g sql-timestamp
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 …

oracle oracle11g
Add days Oracle SQL

SELECT ORDER_NUM, CUSTOMER_NUM, CUSTOMER_NAME, ADD_DAYS (ORDER_DATE, 20) FROM CUSTOMER, ORDERS; Oracle Express says ADD_DAYS invalid? …

sql oracle11g
Oracle SQL query for Date format

I always get confused with date format in ORACLE SQL query and spend minutes together to google, Can someone explain …

sql database oracle oracle11g