Category "oracle10g"

Can't select the package body from other schema in Oracle 10.2.0.4

My user has the following privileges: `GRANT CREATE SESSION to user1; GRANT SELECT ANY TABLE to user1; GRANT SELECT_CATALOG_ROLE to user1; GRANT SELECT ANY DICT

Protocol violation exception in Java application

We have an application developed in java(jdk1.5 and DB is oracle 10g). At some point of time our application is giving below error and terminating. I had search

Semicolon and Single Quote Issue in SQL Insert Statements

I am executing a SQL script which has spaces, semicolons, single-quotes, special characters etc. in of the column called prod_desc. I need to execute the script

Oracle appending string to a select statement

I have a column in a oracle table Lic_num char(7 byte) SELECT column1, 'ABC' + Lic_num FROM TABLE One I wanted ABC appended to all the rows that are returned