Top "Oracle" questions

Oracle USING clause best practice

Disclaimer: I'm a developer and not a DBA. I've been a huge fan of the USING clause in Oracle since …

oracle join using natural-join

PL/SQL developer import dump

I have a dump file which includes two tables. Now I need to import this dump file. I was instructed …

oracle dump plsqldeveloper tablespace

Update SQL with two tables in Oracle

I have a sql like this UPDATE A SET A.TEMSILCI_KOD = 4 FROM S_MUSTERI A, S_TEKLIF B WHERE …

sql oracle sql-update ora-00933

Setting the value of a form field from a Query

I have a form field where one of the values has a default value defined in a an application settings …

oracle oracle-apex

Oracle form: How to disable/enable certain blocks or fields in form by switching radio buttons?

I have three radio buttons in my Oracle form. Ideally, selecting one option would enable block1 and disable block2 and …

oracle oracleforms

Convert milliseconds to Timestamp

I know that to convert a Unix timestamp in milliseconds to an SQL timestamp I can use SELECT TO_DATE(…

sql oracle timestamp unix-timestamp milliseconds

Oracle Time Comparisons

Is Oracle (10g) doing a proper TIME comparison here, or do I need to convert to decimal time and then …

sql oracle date-arithmetic to-char

Oracle Merge vs Select then Insert or Update

What is faster? the Merge statement MERGE INTO table_name USING dual ON (row_id = 'some_id') WHEN MATCHED THEN …

sql oracle sql-merge

ORACLE SQL: How do I replace NULL with 0 in a Pivot function

How can I replace NULL with 0 in a PIVOT function on ORACLE SQL? This is the query I'm trying to …

sql oracle pivot null-coalescing

SQL - How to store and navigate hierarchies?

What are the ways that you use to model and retrieve hierarchical info in a database?

sql sql-server oracle database-design hierarchy