Top "Oracle" questions

Changing password with Oracle SQL Developer

Many of my users do not use SQLPlus. I cannot give them alter user. We expire passwords every 60 days. I …

oracle oracle-sqldeveloper

Fetch the row which has the Max value for a column

Table: UserId, Value, Date. I want to get the UserId, Value for the max(Date) for each UserId. That is, …

sql oracle greatest-n-per-group

Best way to do multi-row insert in Oracle?

I'm looking for a good way to perform multi-row inserts into an Oracle 9 database. The following works in MySQL but …

sql database oracle sql-insert oracle9i

How can I create a copy of an Oracle table without copying the data?

I know the statement: create table xyz_new as select * from xyz; Which copies the structure and the data, but …

sql oracle copy database-table

How do I reset a sequence in Oracle?

In PostgreSQL, I can do something like this: ALTER SEQUENCE serial RESTART WITH 0; Is there an Oracle equivalent?

sql database oracle sequence

How do I spool to a CSV formatted file using SQLPLUS?

I want to extract some queries to a CSV output format. Unfortunately, I can't use any fancy SQL client or …

sql oracle csv sqlplus

How to Select a substring in Oracle SQL up to a specific character?

Say I have a table column that has results like: ABC_blahblahblah DEFGH_moreblahblahblah IJKLMNOP_moremoremoremore I would like to …

sql oracle substring trim

How to create a user in Oracle 11g and grant permissions

Can someone advise me on how to create a user in Oracle 11g and only grant that user the ability …

oracle oracle11g access-control

Oracle SQL, concatenate multiple columns + add text

So I basically wanna display this (whole row in ONE column): I like [type column] cake with [icing column] and …

sql oracle concatenation

How to generate an entity-relationship (ER) diagram using Oracle SQL Developer

I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new …

oracle oracle-sqldeveloper entity-relationship erd