Home » SQL & PL/SQL » SQL & PL/SQL » how to use migrate script (oracle 10g)
how to use migrate script [message #390827] Mon, 09 March 2009 23:47 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
Hi,

select * from emrpatientproblems;

date comes like this

columns data
1)problem_id 1511
2)problem_desc 20000-RETCLSRC UNSP XTRNDL ORG 3)problem_code NULL
4)problem_name NULL

now what i want is i want to transfer
20000 in problem_code and RETCLSRC UNSP XTRNDL ORG in problem_name.
is it possible?can anyone suggest me
Re: how to use migrate script [message #390828 is a reply to message #390827] Mon, 09 March 2009 23:54 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>Messages: 131
Slow learner?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Re: how to use migrate script [message #390829 is a reply to message #390828] Mon, 09 March 2009 23:58 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
three columns are there in a table

p_id p_desc p_code p_name

1 xyz-fers null null

Now my requirement is to put the p_desc value xyz-fers as
upto xyz in p_code column and fers in p_name column
Re: how to use migrate script [message #390834 is a reply to message #390827] Tue, 10 March 2009 00:01 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Post DDL for tables.
Post DML for test data.

Post expected/desired results.
Re: how to use migrate script [message #390837 is a reply to message #390829] Tue, 10 March 2009 00:03 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
As blackswan said
Quote:
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/




POST your code here.....how you are inserting your data into the table?

Blackswan is so faster than me..
Re: how to use migrate script [message #390843 is a reply to message #390827] Tue, 10 March 2009 00:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From one of your previous topic:
Michel Cadot wrote on Mon, 23 February 2009 08:11
Michel Cadot wrote on Mon, 23 February 2009 07:49
From one of your previous topic with the same function:
Michel Cadot wrote on Tue, 17 February 2009 10:20
From your previous posts:
BlackSwan wrote on Tue, 17 February 2009 05:35
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.


Yes, if you are willing to Read The Fine Manual.

BlackSwan wrote on Tue, 10 February 2009 05:58
>iam getting exceptions
Exceptions? What exceptions? I don't see any problem.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you


Michel Cadot wrote on Tue, 10 February 2009 07:55
From your previous topic:
Michel Cadot wrote on Mon, 09 February 2009 07:28
Copy and paste EXACTLY what you did.
Before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel

Which the same one than this one, so I merged one and the following is still true:
Michel Cadot wrote on Mon, 09 February 2009 12:32
You still didn't post what I asked and how I asked it.

Regards
Michel


And so on.

Regards
Michel





[Updated on: Tue, 10 March 2009 00:13]

Report message to a moderator

Re: how to use migrate script [message #390903 is a reply to message #390827] Tue, 10 March 2009 04:19 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Quote:

three columns are there in a table

p_id p_desc p_code p_name



I find 4..P_id,P_Desc,P_Code,P_Name Smile

Lets all decide that untill the OP posts his solution(whatever he has tried so far) with formatting we won't reply.

Regards,
Ashoka BL

[Updated on: Tue, 10 March 2009 04:21]

Report message to a moderator

Re: how to use migrate script [message #390909 is a reply to message #390903] Tue, 10 March 2009 04:43 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Let's all decide that moderators will point people to the rules, if they violate them and that the others stick to answering questions.
Re: how to use migrate script [message #390912 is a reply to message #390827] Tue, 10 March 2009 04:46 Go to previous message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

I was waiting for this reply Frank, point agreed and taken.
Previous Topic: how to count comma seprated values
Next Topic: Sql Filter
Goto Forum:
  


Current Time: Tue Dec 06 15:46:06 CST 2016

Total time taken to generate the page: 0.06911 seconds