Select top 5 records
"Samir Chitkara , Gurgaon" <[email protected]> Mon, 31 Mar 2003 16:56:58 +0530
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-933988-2003.03.31-12.23.47--gcdod-oracle#[email protected]> |
hi! can any one give me a solution to find of top 5 record in a table ; without using rownum / order by . Thanks Samir -----Original Message----- From: manit_jain [mailto:[email protected]] Sent: Monday, March 31, 2003 12:51 PM To: Oracle Subject: [oracle] Re: How can I Export/Import a single or multiple tables from/to Oracle 8 for windows95? the ORACLE_SID is the name of the oracle service you are using.if you are using Oracle8.0 then it would be orcl.Also in order to run imp/exp the classpath must be set to %ORACLE_HOME%/bin directory. if it is not set then go to prompt c:\orawin95\bin:\> then type exp. also to export/import you must log on with DBA previleges.try it with system/manager account or grant the DBA role to the user through which you want to import the data. regards. Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now ! --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to %%email.unsub%%. --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to [email protected].