Responsibility like
"Super User" or "System Administrator"
Thanks,...
User Profile
Collapse
-
How to get the List of Active Users in a Responsibility (Oracle Apps)
Hi all,
Can any one help me in getting the list of users associated with a responsibility in Oracle Apps.
Thanks, -
Hey Debasis its working now i ran the different code. Ur amazing . Thanks alot....Leave a comment:
-
SQL> CREATE or REPLACE PROCEDURE SIDS
2 AS
3 blocking_rec blocking_sid_cu rsor%ROWTYPE;
4 CURSOR blocking_sid_cu rsor
5 IS
SELECT * FROM gv$lock a, gv$lock b
6 7 WHERE (a.block <>0 AND b.request > 0 AND a.id1 = b.id1 AND a.id2 = b.id2);
8 BEGIN
9 OPEN blocking_sid_cu rsor;
10 LOOP
11 FETCH blocking_sid_cu rsor INTO blocking_rec;
12 EXIT...Leave a comment:
-
CREATE or REPLACE PROCEDURE SIDS
AS
blocking_rec gv$lock%ROWTYPE ;
CURSOR blocking_sid_cu rsor
IS
SELECT * FROM gv$lock a, gv$lock b
WHERE (a.block <>0 AND b.request > 0 AND a.id1 = b.id1 AND a.id2 = b.id2);
BEGIN
OPEN blocking_sid_cu rsor;
LOOP
FETCH blocking_sid_cu rsor INTO blocking_rec;
EXIT WHEN blocking_sid_cu rsor%NOTFOUND;
DBMS_OUTPUT.PUT _LINE('SID...Leave a comment:
-
Declaring a cursor ROWTYPE%
Hi all,
I need to fetch data from two tables into a cursor(Using inner Join), and i want to declare a ROWTYPE variable for this cursor.
Pls Guide. Its urgent.
thanks in advance -
Can we deploy .jsp pages on IIS?
Hi All,
I am new to web arch. Please help me.
Can we deploy .jsp pages on IIS.
Please help
Thanks -
-
How to Deploy a JSP on Apache WebServer?
Hi all,
I am new to Web Architecture, pls help me.
I have a jsp and i want it to be deployed on Apache(or any other webserver).
for this what are the steps? what al files in webserver needs to be changed?
Pls help me.
Thanks -
How to Deploy a JSP on Apache WebServer?
Hi all,
I am new to Web Architecture, pls help me.
I have a jsp and i want it to be deployed on Apache(or any other webserver).
for this what are the steps? what al files in webserver needs to be changed?
Pls help me.
Thanks -
About Execution Plan
Hi all,
How to get Execution Plan for a SQL in SQL*Plus prompt?
Thanks,
No activity results to display
Show More
Leave a comment: