Answer / shams tabrez

dba_data_files

What is the Symbol use for Inner Join

1 Answers   Oracle, TCS,

---

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   Alshaya,

---

can we drop dual table

7 Answers   Metric Stream,

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

1. What is PO rate variance gain and loss?

0 Answers   Oracle,

---

Compare and contrast TRUNCATE and DELETE for a table.

3 Answers  

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

0 Answers  

---

What is cardinality?

4 Answers  

---

as a technical developer in oracle applications which type errors feced in your experience sofar

0 Answers   HCL,

---

how to replace not in with not exist?

0 Answers   IBM,

---

QUESTION 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

0 Answers   Telesis,

---