The DISPLAY command must be placed immediately after the query statement on which you want it to take effect. For example: SELECT pno, pname FROM part WHERE color=’BLUE’; DISPLAY; When the system encounters this DISPLAY command, it displays the Result window containing the part number and name for all blue parts.
How do I display a table in SQL?
- Show all tables owned by the current user: SELECT table_name FROM user_tables;
- Show all tables in the current database: SELECT table_name FROM dba_tables;
- Show all tables that are accessible by the current user:
How do I show in MySQL?
MySQL SHOW BINARY LOGSMySQL SHOW ERRORSMySQL SHOW SLAVE HOSTSMySQL SHOW CREATE DATABASEMySQL SHOW INDEXMySQL SHOW TRIGGERS
