Top "Oracle" questions

How can I insert into a BLOB column from an insert statement in sqldeveloper?

Is it possible to insert into a BLOB column in oracle using sqldeveloper? i.e. something like: insert into mytable(…

oracle blob oracle-sqldeveloper

How do I format my oracle queries so the columns don't wrap?

I've tried this, but it doesn't work: col * format a20000 Do I really have to list every column specifically? That …

oracle sqlplus

Oracle - How to create a readonly user

It's possible create a readonly database user at an Oracle Database? How?

oracle readonly

How to catch a unique constraint error in a PL/SQL block?

Say I have an Oracle PL/SQL block that inserts a record into a table and need to recover from …

oracle plsql

What is the equivalent of the Oracle "Dual" table in MS SqlServer?

What is the equivalent of the Oracle "Dual" table in MS SqlServer? This is my Select: SELECT pCliente, 'xxx.x.…

sql-server oracle dual-table

How to configure Glassfish Server in Eclipse manually

I have GlassFish server3.1.2.2 pre installed on my machine. Which I want to use in my Eclipse Luna How do …

java eclipse oracle configuration glassfish

Error System.Data.OracleClient requires Oracle client software version 8.1.7 or greater when installs setup

I have made a desktop app Setup that connects with remote Oracle 10g Database. When I install Setup on remote …

c# oracle oracle10g oracleclient

Proper way of checking if row exists in table in PL/SQL block

I was writing some tasks yesterday and it struck me that I don't really know THE PROPER and ACCEPTED way …

sql oracle select plsql

In Oracle, is it possible to INSERT or UPDATE a record through a view?

In Oracle, is it possible to INSERT or UPDATE a record (a row) through a view?

sql oracle plsql views

Inner join vs Where

Is there a difference in performance (in oracle) between Select * from Table1 T1 Inner Join Table2 T2 On T1.ID = …

sql performance oracle