there is A table and B table in A table there 5 rows and in
b table there are 2 rows i am firing query select * from
a,b what will be the output?
- 7 Answers
- 11995 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / v.g.venkatesh babu
It gives error. If you want to access the data from two tables then we must use JOINS concept... so we need to use aliasis names for tables...
* so both tables A and B must have same no. of fields with same datatypes then only we can use joins.
*Both tables must associated with forign key...
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Why is pl sql needed?
What is form and report?
Can you call pl/sql package functions from within a fast formula?
Why do we use %rowtype & %type in plsql?
How do you declare a constant?
what is unique key constraint? : Sql dba
What is faster join or subquery?
How do you use collections in procedure to return the resultset?
Why left join is used in sql?
What is record type in pl sql?
What mean sql?
What are triggers in sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Can a trigger call a stored procedure?
how do you control the max size of a heap table? : Sql dba
