Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve first and last records from a table?
- 7 Answers
- 11685 Views
- DELL, QSmart, I also Faced
- E-Mail Answers
Answer Posted / reddy
select*from emp where rowid in (select min(rowid),max(rowid) from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to delete a column in an existing table in oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is a nested table and how is it different from a normal table?
How do we get field detail of a table?
How to get maxsal , minsal, ename department wise in single query
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How to assign values to variables?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What is sharded cluster?
What is MTTR advisor in Oracle?
What happens to the current transaction if the session is ended?
What is the difference between sharding and partitioning?
What is an oracle and why it is used?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Why should I use oracle database?
