Top "Oracle" questions

sqlplus statement from command line

Is it possible to do something like this? $ sqlplus -s user/pass "select 1 from dual" or $ echo "select 1 from dual" | …

sql oracle sqlplus

How to use Oracle's LISTAGG function with a unique filter?

I have a table like this: group_id name -------- ---- 1 David 1 John 1 Alan 1 David 2 Julie 2 Charles And I want …

oracle group-by oracle11g aggregate-functions

SQL Error: ORA-00942 table or view does not exist

I use SQL developer and i made a connection to my database with the system user, after I created a …

sql oracle oracle11g

BadImageFormatException. This will occur when running in 64 bit mode with the 32 bit Oracle client components installed

I am getting this error while on of my .Net application are trying to make a connection to oracle database. …

.net oracle oracle11g

ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 536

Below is the code i use to extract data from a table to a flat file. BEGIN DECLARE file_name …

oracle plsql oracle11g ora-06512

Using setDate in PreparedStatement

In order to make our code more standard, we were asked to change all the places where we hardcoded our …

java sql oracle jdbc prepared-statement

Disable all table constraints in Oracle

How can I disable all table constrains in Oracle with a single command? This can be either for a single …

sql oracle

create table with sequence.nextval in oracle

i created a sequence using the following query, create sequence qname_id_seq start with 1 increment by 1 nocache; Now when …

sql database oracle plsql

How to output oracle sql result into a file in windows?

I tried select * from users save D:\test.sql create; But SQL plus gives me "no proper ended" How to …

sql oracle sqlplus

dbms_lob.getlength() vs. length() to find blob size in oracle

I'm getting the same results from select length(column_name) from table as select dbms_lob.getlength(column_name) from …

sql oracle blob