Home » SQL & PL/SQL » SQL & PL/SQL » Validating data
Validating data [message #357660] Thu, 06 November 2008 03:16 Go to next message
sheetalda
Messages: 2
Registered: November 2008
Junior Member
Hi
Welcome to Orafaq. You must try to follow the posting guidelines, particularly when it comes to formatting your posts the guidelines it makes it more possible for people to properly understand your requirements.
[Edit pablolee: I mucked this up and accidentally edited this msg instead of replying. Will try to get the OP to repost his question]

[Updated on: Thu, 06 November 2008 08:27] by Moderator

Report message to a moderator

Re: Validating data [message #357878 is a reply to message #357660] Fri, 07 November 2008 00:31 Go to previous messageGo to next message
sheetalda
Messages: 2
Registered: November 2008
Junior Member
Hi all

I have to validate the following data in a single query.Please help

SELECT * FROM conv_ch_chqbk_issue_brains


This table contains chq issued

REF_CHQ_START_NO REF_CHQ_END_NO

00000000200 00000000250

00000000260 00000000280


SELECT * FROM conv_ch_stop_chq_brains


This table contains Stooped cheques.

validate all the cheques in this tables must be present in the range in conv_ch_chqbk_issue_brains for that account.


REF_STP_CHQ_ST_NO REF_STP_CHQ_END_NO

00000000201 00000000210

00000000248 00000000249

00000000200 00000000252

00000000252 00000000255

00000000245 00000000265


Rows in red color are invalid rows need to report same.

Re: Validating data [message #357880 is a reply to message #357878] Fri, 07 November 2008 00:37 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You had a chance to repost correctly reading pablolee reamrk and guidelines, why didn't you do it?

Regards
Michel
Previous Topic: %rowtype
Next Topic: LOBSEGMENT
Goto Forum:
  


Current Time: Thu Dec 08 01:54:50 CST 2016

Total time taken to generate the page: 0.21918 seconds