Popular "oracle" questions | Page 30

When or Why to use a "SET DEFINE OFF" in Oracle Database

I'm watching a Script in Oracle and I see something I don't recognize REM INSERTING into database1."Users" SET DEFINE …

oracle sqlplus

How do i convert a oracle varchar value to number eg table - exception exception_value 555 where exception_value is …

oracle numbers varchar

Difference between VARCHAR2(10 CHAR) and NVARCHAR2(10)

I've installed Oracle Database 10g Express Edition (Universal) with the default settings: SELECT * FROM NLS_DATABASE_PARAMETERS; NLS_CHARACTERSET AL32…

oracle oracle-xe

How to find out when a particular table was created in Oracle?

In Oracle, is there a way to find out when a particular table was created? Similarly, is there a way …

oracle oracle11g database-metadata

Oracle - Insert New Row with Auto Incremental ID

I have a workqueue table that has a workid column. The workID column has values that increment automatically. Is there …

sql oracle plsql oracle10g

Conditional WHERE clause with CASE statement in Oracle

I'm brand-new to the Oracle world so this could be a softball. In working with an SSRS report, I'm passing …

sql oracle where-clause

null vs empty string in Oracle

Possible Duplicate: Why does Oracle 9i treat an empty string as NULL? I have a table in Oracle 10g named …

oracle null oracle10g string

Display all views on oracle database

Is there a way to display all the views currently set on an oracle database via sql developer? Thanks.

database oracle view oracle-sqldeveloper

SQL to add column and comment in table in single command

I am using Oracle 11g for my web application. I want to add a column and a comment to an …

sql oracle oracle11g

How can I access Oracle from Python?

How can I access Oracle from Python? I have downloaded a cx_Oracle msi installer, but Python can't import the …

python oracle database-connection cx-oracle

Top "Oracle" questions