In-depth analysis of Oracle-specific information sequencing _oracle

In an Oracle query, use Oracle's Decode (field, ' field value ', number) if there is no sort, but you want to have the information of a particular value in a column go ahead.

If you want to have name= ' John ' results in front of all the data from the select name from user query,
Use the following:
Select name from User order by decode (name, ' John ', 0)
Similarly, if you want to make Lee four to the second, you can continue to increase the Decode method
Select name from User order by decode (name, ' John ', 0), decode (name, ' Dick ', 1)