Top "Oracle11g" questions

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

Subtracting Dates in Oracle - Number or Interval Datatype?

I have a question about some of the internal workings for the Oracle DATE and INTERVAL datatypes. According to the …

sql oracle date plsql oracle11g
Grant SELECT on multiple tables oracle

I have 3 tables table1,table2,table3. I want to grant(select for example) these tables to a user, user1. I …

select oracle11g grant
copy from one database to another using oracle sql developer - connection failed

I am trying to copy a table from one database to another using oracle sql developer. I have the username, …

sql database oracle oracle11g oracle-sqldeveloper
Oracle listener not running and won't start

I am getting the following errors while from the lsnrctl status command: C:\Users\pna105>lsnrctl stat LSNRCTL for 64…

oracle oracle11g tns
Default Values to Stored Procedure in Oracle

I have a stored procedure as follows. CREATE OR REPLACE PROCEDURE TEST( X IN VARCHAR2 DEFAULT 'P', Y IN NUMBER …

stored-procedures parameters plsql oracle11g default
NLS_NUMERIC_CHARACTERS setting for decimal

I have one db setup in a test machine and second in production machine. When I run: select to_number(…

oracle oracle11g oracle-sqldeveloper
Oracle PL/SQL string compare issue

I have the following Oracle PL/SQL codes that may be rusty from you guys perspective: DECLARE str1 varchar2(4000); str2 …

sql oracle plsql oracle10g oracle11g
TNS Protocol adapter error while starting Oracle SQL*Plus

Whenever I try to login into SQL*Plus (11g Standar Edition Win 64) I get an error related to some connection …

oracle oracle11g sqlplus
How to insert a column in a specific position in oracle without dropping and recreating the table?

I have a specific scenario where i have to insert two new columns in an existing table in Oracle. I …

oracle oracle11g
ODBC Administrator Can't Find Oracle TNS Names File

With a new Oracle Installation when I go to Configuration Management Tools > Microsoft ODBC Administrator > System DSN > …

oracle oracle11g windows-server-2003 tnsnames