2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A
Full outer join ( select 1 B from dual Union select 2 B from dual)B
On A.A=B.B
Answer Posted / sudarshanbehera07@gmail.com
Ans: showing error (ORA-00904: "A"."A": invalid identifier)
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Explain what is a field in a database and record in a database?
What is %type in pl sql?
What is mdf ldf and ndf?
Which is faster view or stored procedure?
What's the procedure?
What is the difference between function and procedure in pl/sql?
Is mariadb a nosql database?
how many columns can be used for creating index? : Sql dba
what is normalization? : Sql dba
Explain the structure of pl/sql in brief.
What are stored procedures in mysql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What is sql not null constraint?
how to convert character strings to dates? : Sql dba
How to use distinct and count in sql query? Explain