Top "Oracle" questions

Reading clob line by line with pl\sql

In my project i use oracle as primary database and i've faced a problem with parsing clob. So suppose we …

oracle plsql plsqldeveloper

How to write / update Oracle blob in a reliable way?

I'm trying to write and update a pdf document in a blob column but I'm just able to update the …

java oracle jdbc blob

Materialized View vs. Tables: What are the advantages?

It's clear to me why a materialized view is preferable over just querying a base table. What is not so …

sql oracle materialized-views

IS vs AS keywords for PL/SQL Oracle Function or Procedure Creation

I have been trying to find out what the difference is between the IS and AS keywords in PL/SQL …

sql oracle plsql

How to find the default location in which Oracle DBF files are created?

During the creation of a new Tablespace in Oracle Database, the user has to enter the DBF file name that …

sql oracle dbf

What's the difference between pls_integer and binary_integer?

I've inherited some code which is going to be the base for some additional work. Looking at the stored procs, …

oracle plsql oracle10g associative-array

JDBC returning empty result set

I'm using JDBC for very simple database connectivity. I have created my connection/statement and executed a query. I check …

java sql oracle jdbc resultset

"Safe" TO_NUMBER()

SELECT TO_NUMBER('*') FROM DUAL This obviously gives me an exception: ORA-01722: invalid number Is there a way …

oracle type-conversion ora-01722

ORA-00119: invalid specification ORA-00132: syntax error

Below are outputs from my SQLPLUS startup , LSNRCTRL SERVICES, LSNRCTRL STATUS and TNSPING. Also included are my LISTENER.ORA file, …

oracle listener oracle12c

Oracle SQL - Add Primary Key to table

I have some columns with no primary key and want to add a primary key column. NAME Age ------------- Peter 45 …

sql oracle key add