'Partition By using Oracle SQL Developer tool (GUI)


I have been given a task to create ROW_NUMBER() in the oracle database using graphical user interface GUI.
I am using the Oracle SQL developer tool but am unable to find any option which says 'Partition by' or 'Row_number'. I want to know if there is any option available using the graphical User interface (GUI) in the SQL developer tool.

currently, I am using:

  • Oracle Database 19c
  • Oracle SQL developer tool Version 21.4.1.349 Build 349.1822

Please share your expert thoughts, thanks :-)



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source