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 |
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Is ms sql traffic encrypted?
Why stored procedure is better than query?
what are the differences between char and nchar? : Sql dba
How to display the current date in sql?
what is unique key constraint? : Sql dba
What type of database is sql?
how to create a database in oracle?
How can you save or place your msg in a table?
How well can multiple sessions access the same data simultaneously ?
What is the life of an sql statement?
What is partition by in sql?
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)