OraFAQ Forum: SQL & PL/SQL » Put data from one field to another.

Home » SQL & PL/SQL » SQL & PL/SQL » Put data from one field to another. (PLSQL)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Put data from one field to another. [message #671132]

Thu, 16 August 2018 05:48

twardybidon
Messages: 2
Registered: August 2018

Junior Member

Good morning,
maybe someone can help me. This is just an example and I think it is the best way to "describe" my problem.
This is what I got. You can see it on the top of the attached file. I would like to receive the results as on the picture below. Fulfill columns C and D based on the results from first entry.
Thank you so much.
select t.a, t.b,t.c, t.d from tsu t where t.x = 100 and t.y = 7 order by 1;

PLSQL.

Attachment: test.png
(Size: 32.31KB, Downloaded 1209 times)

Report message to a moderator

[Message index]

		Put data from one field to another. By: twardybidon on Thu, 16 August 2018 05:48
		Re: Put data from one field to another. By: John Watson on Thu, 16 August 2018 07:02
		Re: Put data from one field to another. By: Michel Cadot on Thu, 16 August 2018 07:59
		Re: Put data from one field to another. By: twardybidon on Thu, 16 August 2018 10:27
		Re: Put data from one field to another. By: BlackSwan on Thu, 16 August 2018 10:29
		Re: Put data from one field to another. By: Michel Cadot on Thu, 16 August 2018 10:34

Previous Topic:	failing in Creation of PL/SQL function
Next Topic:	Teradata To Oracle MOD Function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 19:33:40 CDT 2024