what is the querry to get first 10 records from the emp
table?(emp no is the primary key)
Answer Posted / lara
SELECT column FROM table
WHERE ROWNUM <= 10
| Is This Answer Correct ? | 21 Yes | 2 No |
Post New Answer View All Answers
what are the tools used for oracle 10g in real time.
can we use lexical perameter in oracle plsql if yes how
How many segment are present in Oracle Manufacturing
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
Explain the use of table functions.
A scenario for amount correction & how to use amount correction functionality in AP invoices
can u give guidance abt packages of plsql
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
Explain prerequisites and post activities of oracle database installation
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.