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
Answers were Sorted based on User's Feedback
Answer / sudarshanbehera07@gmail.com
Ans: showing error (ORA-00904: "A"."A": invalid identifier)
| Is This Answer Correct ? | 3 Yes | 4 No |
Is keyword pl sql?
Can triggers stop a dml statement from executing on a table?
How to combine two stored procedures in sql?
How do I run a sql script?
What is mdf ldf and ndf?
What is pl sql in oracle?
What is varchar data type in sql?
What are secondary keys?
What are sql functions? Describe the different types of sql functions?
What is a primary key example?
How much ram can sql express use?
how can i create a user defined datatype
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)