oracle Archives - Page 5 of 5

Please clarify two things for me: Can a Foreign key be NULL? Can a Foreign key be duplicate? As fair as I know, ...

In SQL I (sadly) often have to use “LIKE” conditions due to databases that violate nearly every rule of normalization. I can’t change ...

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

I’m interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting ...

It appears that there is no concept of AUTO_INCREMENT in Oracle, up until and including version 11g. How can I create a column ...

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

How do I query an Oracle database to display the names of all tables in it? 2 24 SELECT owner, table_name FROM dba_tables ...

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: ...

If that’s a SQLException thrown by Java, it’s most likely because you are trying to get or set a value from a ResultSet, ...

This simply means that something in the backend ( DBMS ) decided to stop working due to unavailability of resources etc. It has ...