Top "Oracle" questions

ResultSet.getTimestamp("date") vs ResultSet.getTimestamp("date", Calendar.getInstance(tz))

java.util.Date, java.util.Timetamp were seems to be causing great confusion for many. Within StackOverflow there are so …

java oracle jdbc sybase

Oracle TIMESTAMP WITH TIMEZONE named zone vs offset

In oracle, is the named timezone always stored? I have been testing this column within our system, and in some …

oracle datetime timezone timestamp dst

How to call a function in a package

I'm doing the following but it doesnt work select package_name.function_name(param,param) from dual I'm calling a …

sql database oracle plsql sys-refcursor

use of ROLLBACK command in Oracle

I created table SQL>CREATE TABLE Student ( StudID NUMBER(6), StudName VARCHAR2(25), JoinDate DATE ); Table created. SQL>INSERT INTO …

oracle oracle11g rollback

Running total by grouped records in table

I have a table like this (Oracle, 10) Account Bookdate Amount 1 20080101 100 1 20080102 101 2 20080102 200 1 20080103 -200 ... What I need is new table grouped by Account …

sql oracle grouping sum cumulative-sum

Get IP address of oracle client users

I need a query to get all IP's of client users that have already a session to the database, I …

oracle client oracle-sqldeveloper ip-address database-administration

Modify unique constraint in Oracle

I need to update an existing constraint in Oracle database to add a new column there. ALTER TABLE MY_PARTNER_…

sql oracle constraints ora-00933

Oracle NVL with empty string

I have this table where NULL is the NULL value, not the string NULL: MYCOL -------- NULL example Why does …

sql oracle null nvl

Selecting all columns and constant value from Oracle table

How can I select all columns and add a column with a constant value in Oracle? With MS SQL Server, …

sql oracle select dml

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS'

I am running cron job which have following PL/SQL block: declare begin --insert into DB_LOGS_TEMP table from …

oracle cron segment tablespace