Top "Oracle" questions

Creating Indexes for Group By Fields?

Do you need to create an index for fields of group by fields in an Oracle database? For example: select * …

sql oracle plsql indexing

How to store unlimited characters in Oracle 11g?

We have a table in Oracle 11g with a varchar2 column. We use a proprietary programming language where this column …

oracle types blob oracle11g clob

SQL date conversion results to "invalid number format model parameter."

I have to select some data from Oracle 11g database, but I can't seem to figure out why following select …

sql oracle oracle11g date-formatting date-arithmetic

"SET FOREIGN_KEY_CHECKS = 0;" Oracle Equivalent

Is there some equivalent to the Mysql specific instruction that disable the check of the foreign keys constraints ? SET FOREIGN_…

oracle key database-integrity

Difference between Oracle jdbc driver classes?

I'm using Oracle's ojdbc5.jar and noticed that it includes two JDBC driver classes. What is the difference between oracle.…

java oracle jdbc

Oracle ODP.net Managed vs Unmanaged Driver

Are there any performance benchmarks between the managed and unmanaged Oracle ODP.Net drivers? (i.e. is there any advantage …

oracle odp.net

What is the difference between USER() and SYS_CONTEXT('USERENV','CURRENT_USER')?

In an Oracle Database, what are the differences between the following: user() sys_context('USERENV', 'CURRENT_USER') sys_context('USERENV', …

oracle plsql oracle10g oracle11g

Oracle: Avoiding NULL value in to_date

I have a functional select statement that has a where clause, in the where clause there is a statement like …

sql oracle date datetime to-date

How to connect SQLPlus with tnsnames.ora

I want to connect with my Oracle database without installing Oracle Client. I downloaded: "Instant Client Package - Basic" and "…

oracle sqlplus tnsnames

Grant alter on only one column in table

I want to grant a user only to edit one column in my table. What command do I use here? …

database oracle oracle11g grant