Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need help to get the output in SQL/PLSQL

Sphoorti kushwahaJul 4 2024 — edited Jul 4 2024
  1. Need to get the data based on gender column one male and one female alternatively.

2. Need to get the output in single query without using concatenation || for keyword 'oracle' in which ‘ace’ should in upper case and remaining ‘orl’ in lower case.

This post has been answered by James Su on Jul 4 2024
Jump to Answer
Comments
Post Details
Added on Jul 4 2024
7 comments
519 views