Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

update value

Posted on 2015-01-23
1
Medium Priority
?
94 Views
Last Modified: 2015-02-06
hi i have the following value to update
'LSAOQRAM.form'

 
       
  update tmp_cal_obj
          set obj_name = obj_name||'.fmb' 
          where obj_type = 'form'; 

Open in new window

after update the value must be

'LSAOQRAM.fmb'

how can i do that
0
Comment
Question by:chalie001
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 40565949
update tmp_cal_obj
          set obj_name = replace(obj_name , '.form', '.fmb' )
          where obj_type = 'form';
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Suggested Courses

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question