Interested to Buy Any Domain ? << Click Here >> for more details...
T1: T2
A X--- this is updated record
B B
like this T1 table having no.of records updated. write a
query"retrive updated record from T2"
- 2 Answers
- 4957 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / suman rana
select * from T2
minus
select * from T1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is merge statement used for?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to connect to a local oracle 10g xe server?
What are temporal data types in oracle?
What are the tools for Oracle ?
How to define default values for formal parameters?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
types of indexes and the rationale behind choosing a particular index for a situation.
How to use subqueries with the exists operator in oracle?
What is oracle data type?
Does oracle partitioning improve performance?
How to define an anonymous procedure without variables?
What are the varoius components of physical database structure of oracle database?
What is format trigger?
What is data block in Oracle?
