Jyothsna, you are correct too. Regards, Bunty

what is the difference between union and union all

Question Posted / banti

Answer Posted / banti

Jyothsna,

you are correct too.

Regards,
Bunty

Is This Answer Correct ?

19 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Can we use ddl commands in pl sql?

1234

What are the benefits of pl/sql packages?

1157

What is the use of sqlerrd 3?

993

how are mysql timestamps seen to a user? : Sql dba

1196

Explain table and field in sql?

1117

What is native sql query?

1076

what are the advantages of using stored procedures? : Sql dba

1154

What are inbuilt functions in sql?

1108

define sql update statement ? : Sql dba

1159

What is nosql db?

1014

Explain isolation levels. : Transact sql

1108

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1056

Is left join inner or outer by default?

1074

What do you think about pl/sql?

1125

How to fix oracle error ora-00942: table or view does not exist

1084