Well, this is a fine statement to delete duplicates in a table : DELETE FROM table1 A WHERE A.rowid > ANY ( SELECT B.rowid FROM table1 B WHERE A.ID = B.ID and any additional condition ) and other conditions on...

Here goes a simple SQL to retrieve the amount of space that a partioned takes (partion by partition) in MB. select partition_name, bytes/1024/1024 as size_mb from dba_segments where segment_name = 'YOUR_TABLE' order by 1 There you all your partions in MB.

Here goes one fine and simple SQL statement to get your character set from your Oracle DB. SELECT * FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET' That’s it.

Here goes a tiny snippet that should get you started by using Oracle as your database instead of the classic MySql RDBMS. <?php // At first, get connected to the instance of your RDBMS $conn = oci_connect("user", "password",...