Interested to Buy Any Domain ? << Click Here >> for more details...
how to write a query without using where?
Example- select * from employee where empno=10
I need to write this query without where clause.
- 1 Answers
- 3297 Views
- Alshaya, I also Faced
- E-Mail Answers
Answer Posted / ananymous
Select empid,empname,sal from emp group by empid,ename,sal
having empid = 10
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what are the API of GL,PO,AP
Where in the Oracle directory tree structure are audit traces placed?
HOW TO SPOT AHIERARCHY?
Why more redos are generated when the oracle database is in begin backup mode?
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.
can we use lexical perameter in oracle plsql if yes how
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
i want to know about the javaBean.what is its purpose and how it can use in Forms.
key flexfield structure
Explain prerequisites and post activities of oracle database installation
What is chargeback invoice? How do we create it? : oracle accounts receivable
what is difference between inner join & nested query or subqueries
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
Are These Dff's Flexible?
Difference between transaction type and transaction sources. : oracle accounts receivable
