Top "Oracle" questions

What is the best way to search the Long datatype within an Oracle database?

I am working with an Oracle database that stores HTML as a Long datatype. I would like to query the …

sql oracle sql-like ora-00932

Oracle Forms/Applications in Internet Explorer 8 using JInitator

Has anyone been able to get Oracle Forms running JInitator to loan in Internet Explorer 8 yet? I have tried removing …

java oracle internet-explorer web-applications oracleforms

ODBC Administrator Can't Find Oracle TNS Names File

With a new Oracle Installation when I go to Configuration Management Tools > Microsoft ODBC Administrator > System DSN > …

oracle oracle11g windows-server-2003 tnsnames

Changing precision of numeric column in Oracle

Currently I have a column that is declared as a NUMBER. I want to change the precision of the column …

sql oracle precision

How do you execute SQL from within a bash script?

I have some SQL scripts that I'm trying to automate. In the past I have used SQL*Plus, and called …

sql oracle bash plsql sqlplus

In Oracle SQL: How do you insert the current date + time into a table?

I've written below code, but it only seems to insert the current date and not the current time. Anyone knows …

sql oracle datetime sql-insert

Oracle SQL insert into with With clause

I'm new to sql, so maybe it is a dumb question, but is there any possibility to use With clause …

sql oracle with-statement

Evaluation of PL/SQL boolean variables in Oracle Forms

Suppose I have a BOOLEAN variable within a PL/SQL block in an Oracle Form: DECLARE is_viewable BOOLEAN; BEGIN …

oracle plsql boolean oracleforms

How to determine MAXSIZE of existing tablespace

I need to determine the MAXSIZE that was set for a tablespace when it was created (Oracle 10g) I'm sure …

oracle oracle10g tablespace

How to use existing Oracle sequence to generate id in hibernate?

I have legacy Oracle db with a sequence named PRODUCT_ID_SEQ. Here is the mapping of Product class for …

oracle hibernate sequence