The Oracle SQL Developer tool can connect to databases ... Developers can browse and execute basic SELECT queries on supported databases. However, write access is not supported for DB2.

PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed, its data are sorted and displayed as specified by the ORDER BY clause. This sorting on ...