Top "Oracle" questions

Why does Oracle 9i treat an empty string as NULL?

I know that it does consider ' ' as NULL, but that doesn't do much to tell me why this …

sql oracle null string

How to view the original script of a materialized view?

I am interested in moving a materialized view from one db to the other, regardless, I also need to change …

sql oracle view materialized

How to convert date to datetime in Oracle?

i have a date in oracle with this format DD-MM-YYY and i want to convert it to datetime with this …

sql oracle date datetime date-formatting

Execute scripts by relative path in Oracle SQL Developer

First, this question relates to Oracle SQL Developer 3.2, not SQL*Plus or iSQL, etc. I've done a bunch of searching …

sql oracle oracle-sqldeveloper relative-path sql-scripts

Time zone conversion in SQL query

I am using a query to get some application Received Date from Oracle DB which is stored as GMT. Now …

sql oracle gmt timezone-offset

How do I check if a sequence exists or not in Oracle 11g?

I am using Oracle 11g. I want to be able to determine whether a particular sequence exists or not. I …

oracle oracle11g sequence

How to store selection result in to variable in Oracle procedure

I write a simple procedure. I try to store selection result in variable. I use "SELECT INTO" query but I …

oracle stored-procedures select-into

Example of an Oracle PIVOT clause with subquery

Oracle's definition of the PIVOT clause specifies that there is a possibility to define a subquery in the IN clause. …

sql oracle syntax subquery pivot

Connection cannot be cast to oracle.jdbc.OracleConnection

Why java.sql.Connection cannot be cast to oracle.jdbc.OracleConnection in code below? My main goal is to pass …

java oracle hibernate jdbc jndi

Oracle query output in excel

I have an Oracle 10G database and I need to write a fairly straightforward query that joins two tables and …

oracle plsql excel-2003