i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value
IBM,
6 8141can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )
1 3725now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
1789How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
8 8226QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
1637while creating requisitions i am unable to see the list of organisation can anyone help me out ?
1695how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
1 2775What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
TCS,
3320Post New Oracle AllOther Questions
Give two methods you could use to determine what DDL changes have been made.
What Are Cross Validation & Adi?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
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
What is the sql query to find the employee who has Nth maximum salary?
What is chargeback invoice? How do we create it? : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
can we use lexical perameter in oracle plsql if yes how
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
where the dff data will be stored
How would you go about increasing the buffer cache hit ratio?
What is autocashrule set? : oracle accounts receivable
A scenario for amount correction & how to use amount correction functionality in AP invoices
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable