Creating an Oracle UPDATE Statement from Excel rows
I've been given an Excel spreadsheet with 122 record UPDATEs. I have tried a
CONCATENATE Statement, see below. My one problem is getting the "/" into my Oracle statements to separate them so that it will properly process the multiple UPDATE statements. Can someone help me with this formula??? I'm not sure how to carriage retun so that the "/" appears in the first column. This is where Oracle wants it when I copy and paste my values into a SQL Script. Any help is GREATLY appreciated and Thanks in advance for your review and hopeful for a reply. PSULionRP =CONCATENATE("UPDATE TableName SET ColumnName = ", "'", TRIM(E2), "'", " WHERE KeyColumn = ", B2, " /") |
Creating an Oracle UPDATE Statement from Excel rows
use =char(13) to get the CR in.
"PSULionRP" wrote: I've been given an Excel spreadsheet with 122 record UPDATEs. I have tried a CONCATENATE Statement, see below. My one problem is getting the "/" into my Oracle statements to separate them so that it will properly process the multiple UPDATE statements. Can someone help me with this formula??? I'm not sure how to carriage retun so that the "/" appears in the first column. This is where Oracle wants it when I copy and paste my values into a SQL Script. Any help is GREATLY appreciated and Thanks in advance for your review and hopeful for a reply. PSULionRP =CONCATENATE("UPDATE TableName SET ColumnName = ", "'", TRIM(E2), "'", " WHERE KeyColumn = ", B2, " /") |
All times are GMT +1. The time now is 09:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com