To delete the duplicate record from Oracle table.

How do I delete the duplicate a record from an Oracle table? Please provide the command.

Least5 pointsBadges:

Customize Apache error page

In many cases when the apache or the instance is down, end users receive a "Page Can not be displayed" browser. How can I customize that that page to put situation friendly messages so that end user do not have to send mails and ask questions on that. I am trying to look into...

EBS11isysadmin5 pointsBadges:

Sort Select Columns

When you go to actions and 'Select Columns', I want to sort the 'do not display' section of the select columns in ascending order. How do I do that? I'm using Oracle Apex 4.1

Twist5 pointsBadges:

select command

i would like to collect informations from oracle date table through select query financial year wise my financial year starts from01 jul and ends on 30 jun. my task is to collect total number of entries from last ten financial years wise.

235235235305 pointsBadges:

To display not exit data in oracle

in my table there a,b,c,d are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose b & c are summing per month.but in some month there is no entry for a,b,c,d.so how to show them for that month as 0...

Deb4u50 pointsBadges:

Analyze Statistics on Oracle 10g

How do i run analyse statistics on oracle 10g and schedule it for sunday at 04:00 am

Bem405 pointsBadges: