Answer Posted / mohammed ashfaq
SELECT attr1,attr2..attrn
FROM TABLE1,TABLE2..TABLEn;
(IT IS SIMPLE SELECT)
(FOR COMPLEX SELECT)
SELECT attr1,attr2..attrn
FROM TABLE1,TABLE2..TABLEn
WHERE CONDITION;
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to convert a date to char in oracle? Give one example.
How many types of table in Oracle?
What do you understand by a database object? Can you list a few of them?
What do you mean by a deadlock?
Explain cascading triggers.
How to retrieve data from an cursor to a record?
What is the purpose of save points in oracle database?
What is index in Oracle?
How to define an explicit cursor in oracle?
In which language oracle has been developed?
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
What is meant by a deadlock situation?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is the usage of save points in oracle database?
What are the tools for Oracle ?