PL/SQL TRICKS SINGLE AND DOUBLE AMPERSAND AND BIND VARIABLE

 How to use below:-

&value, &column_name 👉for temporary submission of variable every time you execute a query it'll ask you for entering the value.

&&variable or &&column_name:-

iit's use to set permanent submission in current session;

BIND VARIABLES (:VARIABLE):-

GROUP BY EXPRESSION:-

select column1,column2,column3,...,columnN from table_name

group by column1,column2,column3,...,columnN;

we've to mention all columns in group by expression as below highlighted text...