Are we use SELECT *FROM TABLENAME; for show displays information contained in the database and its tables?

Question

Because I using oracle software.In oracle SELECT *FROM TABLENAME; command use for show displays information contain in table.