Hi,
I have seen other RDBMS front-ends that have a feature where you can right-click on a table, and it will generate a query with all of the columns, ready for you to run it (or just runs it).
For example, you might have another option when you right-click a table, named “Query Rows” below “Open”:
For the SCOTT schema, table EMP, it would open an editor with a script to query all columns:
SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO
FROM EMP;
It doesn't have to run the query, but the goal is not having to write SELECT *, then type in all the column names desired for my query. Classic SQL Developer had options to expand the asterisk or copy column names to the clipboard, which are also possible solutions with the same goal in mind.
Thank you for your consideration!