Home » SQL & PL/SQL » SQL & PL/SQL » How To Show Non Matching rows in oracle (Oracle 11G)
How To Show Non Matching rows in oracle [message #679226] Sun, 16 February 2020 23:55 Go to next message
ssyr
Messages: 65
Registered: January 2017
Member
Hello ,

I need to show all the non matching rows from tables as well as non matching records.
At the same time I have to compare 2 conditions-
Re: How To Show Non Matching rows in oracle [message #679227 is a reply to message #679226] Mon, 17 February 2020 00:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Then do it.

Re: How To Show Non Matching rows in oracle [message #679228 is a reply to message #679226] Mon, 17 February 2020 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

From your previous topic:

Michel Cadot wrote on Tue, 10 September 2019 07:17

Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

From your previous topic;


Michel Cadot wrote on Fri, 30 August 2019 15:17

...
Also feed back in your previous topics.

And your answer:

ssyr wrote on Tue, 10 September 2019 07:23
Sure Michel ,

Next time onward I will follow rules.
...

Hem...

[Updated on: Mon, 17 February 2020 03:39]

Report message to a moderator

Re: How To Show Non Matching rows in oracle [message #679237 is a reply to message #679228] Mon, 17 February 2020 07:10 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
Without the columns or structure how are we supposed to help you?
Previous Topic: AS_XLSX. how to set worksheet name
Next Topic: How to export multiple blob and character data into a text file?
Goto Forum:
  


Current Time: Thu Mar 28 08:26:59 CDT 2024