Home » SQL & PL/SQL » SQL & PL/SQL » Updating Status W to A (SQL)
Updating Status W to A [message #652012] Tue, 31 May 2016 04:13 Go to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Hello friends,

In our office if any holiday is between leave i.e. emp_no=00000624 is applying for leave from 18-05-2016 to 24-05-2016 =07 days leave but in Bangladesh every Friday is weekly holiday, in that case 20-05-2016 should be holiday and leave should be 06 days, but it will remain leave. The leave days is 07.
http://s33.postimg.org/78e27c2f3/leave.jpghttp://s33.postimg.org/78e27c2f3/leave.jpg

In those case we have to update our Attn_details table.
/forum/fa/13147/0/

In image you see 20-05-2016 both status were W but we have to change it to A.
Is there sytex to update both status into A sync with my Leve_etry_details?

We posting our Leave on Leave_entry_details
SQL> desc leave_entry_details
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 LV_CAT_ID                                          VARCHAR2(10)
 YEAR                                               VARCHAR2(10)
 EMPNO                                              VARCHAR2(20)
 LEAVE_NAME                                         VARCHAR2(30)
 BALANCE                                            NUMBER(3)
 APPLICATION_NO                                     VARCHAR2(20)
 APPLICATION_DATE                                   DATE
 APPROVE_DATE                                       DATE
 APPROVE_DAYS                                       NUMBER(3)
 APPROVE_BY                                         VARCHAR2(40)
 LV_FROM                                            DATE
 LV_TO                                              DATE
 EFFECT_DAYS                                        NUMBER


We update our W to A on ATTENDANCE_DETAILS table.

SQL> desc ATTENDANCE_DETAILS;
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------------------
 ATT_DATE                                           DATE
 EMPNO                                              VARCHAR2(20)
 IN_TIME                                            DATE
 OUT_TIME                                           DATE
 OTHOUR                                             NUMBER
 LATE                                               NUMBER
 STATUS                                             VARCHAR2(10)
 MANUAL_STATUS                                      VARCHAR2(20)
 DEDUCT_VAL                                         NUMBER(3)
 IN_TIME2                                           DATE
 OUT_TIME2                                          DATE
 OTHOUR2                                            NUMBER
 NOROT                                              NUMBER
 EXTRAOT                                            NUMBER
 LATE2                                              NUMBER
 STATUS2                                            VARCHAR2(10)
 MANUAL_ATT                                         VARCHAR2(20)
 DEDUCT_DAYS                                        NUMBER
 REMARKS                                            VARCHAR2(250)
 S_OT                                               NUMBER
 FLOOR_DESC                                         VARCHAR2(15)
 S_OUT_TIME                                         DATE
 S_IN_TIME                                          DATE
 ADVANCE                                            NUMBER
 LEAVE                                              VARCHAR2(5)

I try to make my question easy, God knows can you understand?
  • Attachment: leave 2.jpg
    (Size: 177.67KB, Downloaded 676 times)

[Updated on: Tue, 31 May 2016 04:36]

Report message to a moderator

Re: Updating Status W to A [message #652016 is a reply to message #652012] Tue, 31 May 2016 04:58 Go to previous messageGo to next message
Littlefoot
Messages: 21530
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:

Is there sytex to update both status into A sync with my Leve_etry_details?


DECODE (or CASE) might do that. Check the day name (or, maybe even better, day number) and set the status according to that value.
Re: Updating Status W to A [message #652074 is a reply to message #652016] Wed, 01 June 2016 00:48 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
I tried something like that, or any other way to solve? Please help me

SQL>  
SQL> UPDATE ATTENDANCE_DETAILS ad
  2  SET    Status2='A'
  3  WHERE  empno IN
  4         (SELECT led.empno
  5          FROM   LEAVE_ENTRY_DETAILS led
  6          WHERE  led.LV_FROM BETWEEN TO_DATE ('01-jan-2015', 'dd-mon-yyyy') 
  7                                    AND TO_DATE ('31-jan-2015', 'dd-mon-yyyy')
  8   and    led.LV_to BETWEEN TO_DATE ('01-jan-2015', 'dd-mon-yyyy') 
  9                                    AND TO_DATE ('31-jan-2015', 'dd-mon-yyyy');
                                  AND TO_DATE ('31-jan-2015', 'dd-mon-yyyy')
                                                                           *
ERROR at line 9:
ORA-00907: missing right parenthesis
Re: Updating Status W to A [message #652077 is a reply to message #652074] Wed, 01 June 2016 01:37 Go to previous messageGo to next message
Littlefoot
Messages: 21530
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why don't you fix it? Do you understand what "missing right parenthesis" means?
Re: Updating Status W to A [message #652078 is a reply to message #652077] Wed, 01 June 2016 01:39 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Sorry I cant fix it don't understand 'missing right parenthesis' that please help me.
Re: Updating Status W to A [message #652079 is a reply to message #652078] Wed, 01 June 2016 01:49 Go to previous messageGo to next message
Littlefoot
Messages: 21530
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This:
)
is the right parenthesis. It is missing, so you have to add it. Every left (i.e. open) parenthesis has to have its pair (i.e. the right parenthesis which closes it).

For example:
to_date('01-jan-2015', 'dd-mon-yyyy'
                                    ^
                                    |
                               missing right parenthesis here!

to_date('01-jan-2015', 'dd-mon-yyyy')    --> fixed!
Re: Updating Status W to A [message #652082 is a reply to message #652079] Wed, 01 June 2016 02:53 Go to previous messageGo to next message
cookiemonster
Messages: 13787
Registered: September 2008
Location: Rainy Manchester
Senior Member
Also indent your code properly - the AND on line 8 should be indented to the same level as the 2nd WHERE.
Can lv_from and lv_to have times other than midnight?
If so your query will ignore all values on 31st Jan after midnight, which I doubt is what you want.
Re: Updating Status W to A [message #652149 is a reply to message #652012] Thu, 02 June 2016 15:01 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8919
Registered: November 2002
Location: California, USA
Senior Member
Your problem is not totally clear. Part of it is clear, but some of it is not. It would enable us to understand the whole problem and help you better if you were to provide create table and insert statements for your starting data and post an example of what you want after the update, in addition to your worded description. It makes it simpler if you can limit it to just the necessary columns, such as any columns to be updated, any columns needed to determine which columns to be updated, any columns needed to join the tables, and any key columns. It also helps if your data and attempted update match, such as updating data for the same month and year. It is useless to try to run an update statement for dates in January of 2015 on data for May of 2016.

I gather that you have a leave_entry_details table and you need to process all rows in that table, using that data to update some of the columns in some of the rows of the attendance_details table. I gather that, for each row in the leave_entry_details table, you want to update both the status and status2 columns to the value of 'A' for the rows in the attendance_details table where the empno in the attendance_details table is the same as the empno in that row of the leave_entry_details table and the att_date in the attendance_details table is between the lv_from and lv_to dates in that row of the leave_entry_details_table.

Since the empno and lv_from and lv_date must come from the same row and there might be multiple rows for the same empno, I think this situation is a good candidate for a MERGE statement. I have provided some limited sample data below and shown how to update the status and status2 to 'A' for the appropriate employee and dates. I am just trying to address how to update the status in general for provided dates in general here. The rest of your problem, as to what you do or do not want to update from what value to what value, depending on whether or not one of the dates is a Friday and what value you want for number of days, you will have to provide further clarification on that, if you cannot figure out how to modify the merge statement to include those things.

-- starting data:
SCOTT@orcl_12.1.0.2.0> SELECT empno, lv_from, lv_to
  2  FROM   leave_entry_details
  3  /

EMPNO                LV_FROM         LV_TO
-------------------- --------------- ---------------
00000624             Wed 18-May-2016 Fri 20-May-2016
00000624             Sun 22-May-2016 Tue 24-May-2016

2 rows selected.

SCOTT@orcl_12.1.0.2.0> SELECT att_date, empno, status, status2
  2  FROM   attendance_details
  3  /

ATT_DATE        EMPNO                STATUS     STATUS2
--------------- -------------------- ---------- ----------
Tue 17-May-2016 00000624
Wed 18-May-2016 00000624
Thu 19-May-2016 00000624
Fri 20-May-2016 00000624
Sat 21-May-2016 00000624
Sun 22-May-2016 00000624
Mon 23-May-2016 00000624
Tue 24-May-2016 00000624

8 rows selected.


-- merge statement to update rows:
SCOTT@orcl_12.1.0.2.0> MERGE INTO attendance_details ad
  2  USING (SELECT empno, lv_from, lv_to
  3  	    FROM   leave_entry_details) led
  4  ON    (ad.empno = led.empno AND
  5  	    ad.att_date BETWEEN led.lv_from AND led.lv_to)
  6  WHEN  MATCHED THEN UPDATE SET ad.status = 'A', ad.status2 = 'A'
  7  /

6 rows merged.


-- results:
SCOTT@orcl_12.1.0.2.0> SELECT att_date, empno, status, status2
  2  FROM   attendance_details
  3  /

ATT_DATE        EMPNO                STATUS     STATUS2
--------------- -------------------- ---------- ----------
Tue 17-May-2016 00000624
Wed 18-May-2016 00000624             A          A
Thu 19-May-2016 00000624             A          A
Fri 20-May-2016 00000624             A          A
Sat 21-May-2016 00000624
Sun 22-May-2016 00000624             A          A
Mon 23-May-2016 00000624             A          A
Tue 24-May-2016 00000624             A          A

8 rows selected.


Re: Updating Status W to A [message #652200 is a reply to message #652149] Fri, 03 June 2016 21:59 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Wow!! its working, But I want only a particular month will be changed as you can see I tried to change Jan 2015. When I run your code on my database its changed the whole.
SQL> MERGE INTO attendance_details ad
  2  USING (SELECT empno, lv_from, lv_to
  3  FROM   leave_entry_details) led
  4  ON    (ad.empno = led.empno AND
  5  ad.att_date BETWEEN led.lv_from AND led.lv_to)
  6  WHEN  MATCHED THEN UPDATE SET ad.status = 'A', ad.status2 = 'A'
  7  /

21618 rows merged.

See that.
Re: Updating Status W to A [message #652203 is a reply to message #652200] Sat, 04 June 2016 01:22 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8919
Registered: November 2002
Location: California, USA
Senior Member
MERGE INTO attendance_details ad
USING (SELECT empno, lv_from, lv_to
       FROM   leave_entry_details) led
ON    (ad.empno = led.empno AND
       ad.att_date BETWEEN led.lv_from AND led.lv_to AND
       ad.att_date BETWEEN TO_DATE ('01-jan-2015', 'dd-mon-yyyy') 
                       AND TO_DATE ('31-jan-2015', 'dd-mon-yyyy'))
WHEN  MATCHED THEN UPDATE SET ad.status = 'A', ad.status2 = 'A';

Re: Updating Status W to A [message #652206 is a reply to message #652203] Sat, 04 June 2016 01:47 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Wow!! Its working, thank's again.
Don't know how many times I have to say this.
God bless you.
Is this possible Comments 'Leave' on remark column at attendance_details table which table are merged?
Re: Updating Status W to A [message #652213 is a reply to message #652206] Sat, 04 June 2016 07:03 Go to previous messageGo to next message
Solomon Yakobson
Messages: 2908
Registered: January 2010
Location: Connecticut, USA
Senior Member
Don't be scared Smile, try it yourself. All that's needed is adding

remarks = 'leave'

to SET clause, same like in UPDATE statement.

SY.
Re: Updating Status W to A [message #652233 is a reply to message #652213] Sun, 05 June 2016 01:13 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Sorry I tried but failed Embarassed
Where should I write this code?
Tried on top of the code.
SQL> SET AD.REMARKS='Leave'
SP2-0735: unknown SET option beginning "AD.REMARKS..."
SQL> MERGE INTO attendance_details ad
  2  USING (SELECT empno, lv_from, lv_to
  3         FROM   leave_entry_details) led
  4  ON    (ad.empno = led.empno AND
  5         ad.att_date BETWEEN led.lv_from AND led.lv_to AND
  6         ad.att_date BETWEEN TO_DATE ('01-apr-2015', 'dd-mon-yyyy') 
  7                         AND TO_DATE ('30-apr-2015', 'dd-mon-yyyy'))
  8  WHEN  MATCHED THEN UPDATE SET ad.status = 'A', ad.status2 = 'A';

1742 rows merged.

SQL> commit;

Commit complete.

SQL> 


Tried on bottom of code.

SQL> MERGE INTO attendance_details ad
  2  USING (SELECT empno, lv_from, lv_to
  3         FROM   leave_entry_details) led
  4  ON    (ad.empno = led.empno AND
  5         ad.att_date BETWEEN led.lv_from AND led.lv_to AND
  6         ad.att_date BETWEEN TO_DATE ('01-apr-2015', 'dd-mon-yyyy') 
  7                         AND TO_DATE ('30-apr-2015', 'dd-mon-yyyy'))
  8  WHEN  MATCHED THEN UPDATE SET ad.status = 'A', ad.status2 = 'A'
  9  SET AD.REMARKS='Leave';
SET AD.REMARKS='Leave'
*
ERROR at line 9:
ORA-00933: SQL command not properly ended
Re: Updating Status W to A [message #652235 is a reply to message #652233] Sun, 05 June 2016 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 66797
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just read line 8 to see how you have to write the new setting.

Re: Updating Status W to A [message #652238 is a reply to message #652233] Sun, 05 June 2016 02:20 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8919
Registered: November 2002
Location: California, USA
Senior Member
MERGE INTO attendance_details ad
USING (SELECT empno, lv_from, lv_to
       FROM   leave_entry_details) led
ON    (ad.empno = led.empno AND
       ad.att_date BETWEEN led.lv_from AND led.lv_to AND
       ad.att_date BETWEEN TO_DATE ('01-jan-2015', 'dd-mon-yyyy') 
                       AND TO_DATE ('31-jan-2015', 'dd-mon-yyyy'))
WHEN  MATCHED THEN UPDATE SET ad.status = 'A', ad.status2 = 'A', ad.remarks = 'Leave';

Re: Updating Status W to A [message #652243 is a reply to message #652238] Sun, 05 June 2016 04:19 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Thank's again
Re: Updating Status W to A [message #653122 is a reply to message #652243] Tue, 28 June 2016 03:45 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
How can I add a table emp_official to this syntax because I want to run it only Company_name: 'Clifton Apparels Ltd' which is on emp_official table
Re: Updating Status W to A [message #653123 is a reply to message #653122] Tue, 28 June 2016 04:15 Go to previous messageGo to next message
Littlefoot
Messages: 21530
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's called a join.
Re: Updating Status W to A [message #653195 is a reply to message #653122] Tue, 28 June 2016 17:14 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8919
Registered: November 2002
Location: California, USA
Senior Member
You need to determine what column(s) is/are appropriate to join leave_entry_details and emp_official.

MERGE INTO attendance_details ad
USING (SELECT d.empno, d.lv_from, d.lv_to
       FROM   leave_entry_details d JOIN emp_official o
              ON (d.empno = o.empno) -- or whatever join condition is appropriate
       WHERE  o.company_name = 'Clifton Apparels Ltd') led
ON    (ad.empno = led.empno AND
       ad.att_date BETWEEN led.lv_from AND led.lv_to AND
       ad.att_date BETWEEN TO_DATE ('01-01-2015', 'dd-mm-yyyy') 
                       AND TO_DATE ('31-01-2015', 'dd-mm-yyyy'))
WHEN  MATCHED THEN UPDATE SET ad.status = 'A', ad.status2 = 'A', ad.remarks = 'Leave';
Re: Updating Status W to A [message #653237 is a reply to message #653195] Wed, 29 June 2016 22:24 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Ohh when I run this code another server I found this

SQL*Plus: Release 8.0.6.0.0 - Production on Thu Jun 30 09:21:46 2016

(c) Copyright 1999 Oracle Corporation.  All rights reserved.


Connected to:
Personal Oracle8i Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> MERGE INTO attendance_details ad
unknown command beginning "MERGE INTO..." - rest of line ignored.
SQL> USING (SELECT empno, lv_from, lv_to
unknown command beginning "USING (SEL..." - rest of line ignored.
SQL>        FROM   leave_entry_details) led
unknown command beginning "FROM   lea..." - rest of line ignored.
SQL> ON    (ad.empno = led.empno AND
unknown command beginning "ON    (ad...." - rest of line ignored.
For a list of known commands enter HELP
and to leave enter EXIT.
SQL>        ad.att_date BETWEEN led.lv_from AND led.lv_to AND
unknown command beginning "ad.att_dat..." - rest of line ignored.
SQL>        ad.att_date BETWEEN TO_DATE ('01-JUN-2016', 'dd-mon-yyyy') 
unknown command beginning "ad.att_dat..." - rest of line ignored.
SQL>                        AND TO_DATE ('30-JUN-2016', 'dd-mon-yyyy'))
unknown command beginning "AND TO_DAT..." - rest of line ignored.
SQL> WHEN  MATCHED THEN UPDATE SET ad.status = 'A', ad.status2 = 'A', ad.remarks = 'Leave';
unknown command beginning "WHEN  MATC..." - rest of line ignored.
For a list of known commands enter HELP
and to leave enter EXIT.

Please help me
Re: Updating Status W to A [message #653239 is a reply to message #653237] Wed, 29 June 2016 22:56 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8919
Registered: November 2002
Location: California, USA
Senior Member
MERGE did not exist in Oracle 8.1.7. That is ridiculously outdated. You need to upgrade that server to a currently supported version.
Re: Updating Status W to A [message #653240 is a reply to message #653239] Wed, 29 June 2016 22:58 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Is there any way to run your code to Oracle 8.1.7. As I said you earlier that my office database is running Oracle 8.1.7

[Updated on: Wed, 29 June 2016 23:13]

Report message to a moderator

Re: Updating Status W to A [message #653244 is a reply to message #653240] Thu, 30 June 2016 00:33 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8919
Registered: November 2002
Location: California, USA
Senior Member
Salehin wrote on Wed, 29 June 2016 20:58
Is there any way to run your code to Oracle 8.1.7. As I said you earlier that my office database is running Oracle 8.1.7


No, you can't use MERGE on 8.1.7. It has been so long that I can't remember for sure, but I don't think you could even use the ANSI join syntax in 8.1.7. I don't have 8.1.7 to test with, so I can't be sure what will run on it. The following is about the simplest update statement that I can think of that might work on such an outdated version.

UPDATE attendance_details ad
SET    ad.status = 'A', ad.status2 = 'A', ad.remarks = 'Leave'
WHERE  EXISTS
       (SELECT *
        FROM   leave_entry_details d, emp_official o
        WHERE  ad.empno = d.empno 
        AND    d.empno = o.empno
        AND    o.company_name = 'Clifton Apparels Ltd'
        AND    ad.att_date BETWEEN d.lv_from AND d.lv_to)
AND    ad.att_date BETWEEN TO_DATE ('01-01-2015', 'dd-mm-yyyy') 
                       AND TO_DATE ('31-01-2015', 'dd-mm-yyyy');
Re: Updating Status W to A [message #653348 is a reply to message #653244] Sun, 03 July 2016 03:27 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Sorry when I run your code it become hang.
Re: Updating Status W to A [message #653351 is a reply to message #653348] Sun, 03 July 2016 14:36 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8919
Registered: November 2002
Location: California, USA
Senior Member
Please post a copy and paste of that run.
Re: Updating Status W to A [message #653352 is a reply to message #653351] Sun, 03 July 2016 21:46 Go to previous messageGo to next message
Salehin
Messages: 61
Registered: March 2013
Location: Chittagong, Bangladesh
Member
SQL*Plus: Release 8.0.6.0.0 - Production on Mon Jul 4 08:45:10 2016

(c) Copyright 1999 Oracle Corporation.  All rights reserved.


Connected to:
Personal Oracle8i Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> UPDATE attendance_details ad
  2  SET    ad.status = 'A', ad.status2 = 'A', ad.remarks = 'Leave'
  3  WHERE  EXISTS
  4         (SELECT *
  5          FROM   leave_entry_details d, emp_official o
  6          WHERE  ad.empno = d.empno 
  7          AND    d.empno = o.empno
  8          AND    o.company_name = 'Clifton Apparels Ltd'
  9          AND    ad.att_date BETWEEN d.lv_from AND d.lv_to)
 10  AND    ad.att_date BETWEEN TO_DATE ('01-01-2015', 'dd-mm-yyyy') 
 11                         AND TO_DATE ('31-01-2015', 'dd-mm-yyyy');
Re: Updating Status W to A [message #653353 is a reply to message #653352] Sun, 03 July 2016 22:20 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8919
Registered: November 2002
Location: California, USA
Senior Member
How long did it run before you determined that it was hung?

What happens if you add AND ROWNUM=1 to the bottom of the code?

Does the same code run on a server with a newer version of Oracle?

I am trying to determine if it is just slow or if there is a problem with the code.

I can't think of anything simpler, but perhaps somebody else has an idea.

In general, Oracle corporation, most consultants, and others will refuse to even attempt support of such an old version.


Re: Updating Status W to A [message #653355 is a reply to message #653352] Sun, 03 July 2016 22:25 Go to previous messageGo to next message
BlackSwan
Messages: 26649
Registered: January 2009
Location: SoCal
Senior Member
>SQL*Plus: Release 8.0.6.0.0 - Production on Mon Jul 4 08:45:10 2016
why are you using different SQL*Plus version & not using same SQL*Plus version as the database?
>Personal Oracle8i Release 8.1.7.0.0 - Production

I suggest that prior to invoking the UPDATE statement that you do as below

SQL> ALTER SESSION SET SQL_TRACE=TRUE;

The content of the trace file will show what is happening inside the DB engine.
Re: Updating Status W to A [message #653365 is a reply to message #653355] Mon, 04 July 2016 02:59 Go to previous message
cookiemonster
Messages: 13787
Registered: September 2008
Location: Rainy Manchester
Senior Member
Are you trying to update rows that are locked by another session?
Run this when it hangs to check:
select 
(select username from v$session where sid=a.sid) blocker,
a.sid,
' is blocking ',
(select username from v$session where sid=b.sid) blockee,
b.sid
from v$lock a, v$lock b
where a.block = 1
and b.request > 0
and a.id1 = b.id1
and a.id2 = b.id2;
Previous Topic: PLSQL grant script not working correctly
Next Topic: Procidure includ not duplicate
Goto Forum:
  


Current Time: Fri Jan 24 12:01:39 CST 2020