Top "Oracle" questions

Best way to reset an Oracle sequence to the next value in an existing column?

For some reason, people in the past have inserted data without using sequence.NEXTVAL. So when I go to use …

sql oracle oracle10g primary-key sequence

OVER clause in Oracle

What is the meaning of the OVER clause in Oracle?

sql oracle window-functions

Inserting into Oracle and retrieving the generated sequence ID

I have a handful of raw SQL queries for SQL Server which use SCOPE_IDENTITY to retrieve the generated ID …

sql oracle stored-procedures identity-column scope-identity

Add a auto increment primary key to existing table in oracle

I want to add a new auto increment primary column to a existing table which has data. How do I …

oracle

How can I issue a single command from the command line through sql plus?

Using SQL Plus, you can run a script with the "@" operator from the command line, as in: c:\>sqlplus …

oracle command-line sqlplus

How to get records randomly from the oracle database?

I need to select rows randomly from an Oracle DB. Ex: Assume a table with 100 rows, how I can randomly …

oracle select random

UNION with WHERE clause

I'm doing a UNION of two queries on an Oracle database. Both of them have a WHERE clause. Is there …

sql oracle union

Where's my invalid character (ORA-00911)

I'm trying to insert CLOBs into a database (see related question). I can't quite figure out what's wrong. I have …

java oracle jdbc prepared-statement

how to set auto increment column with sql developer

How do I set a column to increment automatically with Oracle SQL Developer? Why is the form disabled? Note: The …

database oracle oracle-sqldeveloper

Get resultset from oracle stored procedure

I'm working on converting a stored procedure from SQL server to Oracle. This stored procedure provides a direct resultset. I …

oracle stored-procedures plsql