Add a column with a default value to an existing table in SQL Server

When we give SELECT * FROM EMP How does oracle respond

When we give SELECT * FROM EMP How does oracle respond

When we give select * from emp

it will show the records of table emp if the table contains records.

If it hasn't any records then it will show no rows selected.