CODEWITHSUNDEEP
sqloracle-database
Mythpills
Mythpills

Reputation: 153

Sql query to udpate a column

enter image description here

I pulled the values in the above table by joining 2 tables ROL_PRMSSN & ROL_MSTR. I then added the column ROL_DSC_REVISED for the revised values in excel. I need to update ROL_DSC to the values in column D (ROL_DSC_REVISED). The PRMSSN_NM comes from ROL_PRMSSN table and ROL_NM and ROL_DSC come from ROL_MSTR table. Not sure how to write the query for it.

Upvotes: 0

Views: 52

Answers (1)

MJB
MJB

Reputation: 7686

It looks like the join is irrelevant to your question. Are you simply asking for code to change the values from 'update a record' to 'update access', and so forth? That seems really straight forward, like

update table ROL_PRMSSN set ROL_DSC='update access'   where ROL_DSC='update a record';
update table ROL_PRMSSN set ROL_DSC='delete a record' where ROL_DSC='delete access';
etc

If it is more complicated, please update your question to add details. I feel like I am missing something important, but I'm not sure what it is.

Upvotes: 1

Related Questions