数字转日期 pl/sql_交换两个数字的PL / SQL程序

蔚落 2022-12-07 13:54 101阅读 0赞

![0e14885b70dcdd492fb2e85aefb00069.png][]

数字转日期 pl/sql

Here you will get pl/sql program to swap two numbers with and without using temporary variable.

在这里，您将获得pl / sql程序，可以在使用和不使用临时变量的情况下交换两个数字。

**Method 1: Using Temporary Variable**

**方法1：使用临时变量**

declare
        a number;
        b number;
        temp number;
     
    begin
        a:=5;
        b:=10;
        
        dbms_output.put_line('before swapping:');
        dbms_output.put_line('a='||a||' b='||b);
        
        temp:=a;
        a:=b;
        b:=temp;
        
        dbms_output.put_line('after swapping:');
        dbms_output.put_line('a='||a||' b='||b);
        
    end;
    /

**Output**

**输出量**

*before swapping:* *a=5 b=10* *after swapping:* *a=10 b=5*

*交换前：* *a = 5 b = 10* *交换后：* *a = 10 b = 5*

**Method 2: Without Using Temporary Variable**

**方法2：不使用临时变量**

declare
        a number;
        b number;
     
    begin
        a:=5;
        b:=10;
        
        dbms_output.put_line('before swapping:');
        dbms_output.put_line('a='||a||' b='||b);
        
        a:=a+b;
        b:=a-b;
        a:=a-b;
        
        dbms_output.put_line('after swapping:');
        dbms_output.put_line('a='||a||' b='||b);
        
    end;
    /

> 翻译自: [https://www.thecrazyprogrammer.com/2017/08/plsql-program-swap-two-numbers.html][https_www.thecrazyprogrammer.com_2017_08_plsql-program-swap-two-numbers.html]

数字转日期 pl/sql

[0e14885b70dcdd492fb2e85aefb00069.png]: /images/20221123/a69e7c3515154ec88f918594792351ba.png
[https_www.thecrazyprogrammer.com_2017_08_plsql-program-swap-two-numbers.html]: https://www.thecrazyprogrammer.com/2017/08/plsql-program-swap-two-numbers.html