PL/SQL (MOSC)

MOSC Banner

SQL UPDATE statement in MS Excel

edited Sep 17, 2012 5:57AM in PL/SQL (MOSC) 3 commentsAnswered ✓
Hi All,

I have a request to perform a column update in ap_invoices_all table. There are around 1000 rows to be updated. The input is in the form of MS Excel.

Can somebody suggest how to make an update statement using MS Excel.

My query using excel should look like below:

UPDATE AP_INVOICES_ALL
SET description = '',
last_update_date = ,
last_updated_by =
WHERE org_id =
AND vendor_site_id =
AND invoice_num = ''

Regards,
Radhika.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center