Answer Posted / ray

if we not give exception then the program will terminate
abruptly during run time but if exception is there then it
is caught and the program runs as usual .

how can we implement locks in plsql?

2246

---

Can anyone send me NIC question papers alongwith answers on nidhi1485@yahoo.co.in? Urgently needed.. Thanks in advance

2324

---

Hi All, Can any one please send me the difference between informatica 7i and 8i versions, Thanks in advance. vinod

1935

---

what is session state?

1897

---

SELECT A~FTRMI A~AUFNR B~MATNR D~MAKTX B~PSMNG B~WEMNG C~MTART E~CHARG C~MATKL C~SPART R~BWART R~CHARG R~MATNR E~BWART R~BDMNG INTO TABLE ITAB FROM AFKO AS A INNER JOIN AFPO AS B ON A~AUFNR = B~AUFNR * INNER JOIN AFVC AS A1 ON A~AUFPL = A1~AUFPL AND B~DWERK = A1~WERKS INNER JOIN MARA AS C ON B~MATNR = C~MATNR INNER JOIN MAKT AS D ON C~MATNR = D~MATNR INNER JOIN MSEG AS E ON B~MATNR = E~MATNR AND A~AUFNR = E~AUFNR AND B~DWERK = E~WERKS INNER JOIN RESB AS R ON A~AUFNR = R~AUFNR AND E~AUFNR = R~AUFNR AND R~RSNUM = A~RSNUM AND R~WERKS = E~WERKS AND R~BAUGR = E~MATNR INNER JOIN MARA AS C1 ON R~MATNR = C1~MATNR WHERE A~FTRMI IN S_DATE AND A~AUFNR IN S_AUFNR AND C~MTART IN S_TYPE AND C~MATKL = 'T' AND R~BWART ='261' AND E~BWART = '101' AND R~XWAOK ='X' AND B~DWERK = '2000' AND R~XLOEK EQ SPACE AND E~KZBEW ='F' AND D~SPRAS = 'E' AND R~KZEAR = 'X' AND C~MATNR IN S_MATNR. This query gives repetative records from RESB.There must be some common field which i am not taking thats why its giving repetative records. If u find any solution pls lety me know ASAP. Thanks Swati Ghadge

3268

---

Find out the list of authorization objects which contains activity as a field? Thanks in advance.

2141

---

how do we provide security for web services

2291

---

what is the diff bw sql direct and jdbc update can't we do select and updating operation in sql direct

2115

---

purpose of abstraction and interface

1938

---

Any real time example of O2C process from taking order till creating invoice.

2302

---

1.Mutating table

1803

---

how to get second highest salary from a employee table and how get a 5th highest salary from a employee table by using proc sql?

2311

---

Write a pascal program to calculate the sum of the first 100 even number and odd number

4335

---

Outline the two important features of a terminating recursion. Any ideas?

2161

---

Difference of Console, web & windows applications?

2135

---