Oracle is an Object-relational Database Management System (ORDBMS) created by Oracle Corporation.
I have 3 tables table1,table2,table3. I want to grant(select for example) these tables to a user, user1. I …
select oracle11g grantI am trying to copy a table from one database to another using oracle sql developer. I have the username, …
sql database oracle oracle11g oracle-sqldeveloperI am getting the following errors while from the lsnrctl status command: C:\Users\pna105>lsnrctl stat LSNRCTL for 64…
oracle oracle11g tnsI have a stored procedure as follows. CREATE OR REPLACE PROCEDURE TEST( X IN VARCHAR2 DEFAULT 'P', Y IN NUMBER …
stored-procedures parameters plsql oracle11g defaultI have one db setup in a test machine and second in production machine. When I run: select to_number(…
oracle oracle11g oracle-sqldeveloperWhenever I try to login into SQL*Plus (11g Standar Edition Win 64) I get an error related to some connection …
oracle oracle11g sqlplusI have a specific scenario where i have to insert two new columns in an existing table in Oracle. I …
oracle oracle11gWith a new Oracle Installation when I go to Configuration Management Tools > Microsoft ODBC Administrator > System DSN > …
oracle oracle11g windows-server-2003 tnsnames