Top "Oracle" questions

Oracle: how to add minutes to a timestamp?

I need to add 30 minutes to values in a Oracle date column. I do this in my SELECT statement by …

oracle date timestamp date-arithmetic

How to use BOOLEAN type in SELECT statement

I have a PL/SQL function with BOOLEAN in parameter: function get_something(name in varchar2, ignore_notfound in boolean); …

sql oracle plsql oracle10g ora-00904

How to know installed Oracle Client is 32 bit or 64 bit?

OS: Windows 2008 Server R2 Oracle Client: 11.2 Many Thanks

oracle 64-bit oracleclient

How can I get the number of days between 2 dates in Oracle 11g?

I'm trying to find an integer number of days between two dates in Oracle 11g. I can get close by …

sql oracle oracle11g

How to convert CLOB to VARCHAR2 inside oracle pl/sql

I have a clob variable, need to assign it to varchar2 variable. The data inside clob var is less than 4000 (…

oracle plsql clob

SQL not a single-group group function

When I run the following SQL statement: SELECT MAX(SUM(TIME)) FROM downloads GROUP BY SSN It returns the maximum …

sql oracle group-by sum max

Printing the value of a variable in SQL Developer

I wanted to print the value of a particular variable which is inside an anonymous block. I am using Oracle …

oracle plsql oracle-sqldeveloper

How can I confirm a database is Oracle & what version it is using SQL?

I'm building an installer for an application. The user gets to select a datasource they have configured and nominate what …

sql oracle

How to use a table type in a SELECT FROM statement?

This question is more or less the same as this In the package header : Declared the following row type: TYPE …

oracle select row

URL string format for connecting to Oracle database with JDBC

I'm a newbie to Java-related web development, and I can't seem to get a simple program with JDBC working. I'm …

oracle jdbc oracle-xe