Shulou(Shulou.com)05/31 Report--

This article focuses on "SYS.STANDARD package analysis in Oracle database". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn about the analysis of SYS.STANDARD packages in Oracle database.

About the SYS.STANDARD package in the Oracle database

FUNCTION SET (collection IN "") return ""

Pragma BUILTIN ('SET',18,2,40)

Method (focusing on the output of the last line):

Declare

TYPE ABC IS TABLE OF VARCHAR2 (20)

V_abc ABC: = ABC ()

J number: = 0

Begin

FOR i IN 1.. ten

LOOP

J: = j + 1

V_abc.EXTEND

V_abc (j): = trunc (dbms_random.value (1mem10));-- take an integer between 1 and 10

Dbms_output.put_line ('1st' | j | | 'times' | | the resulting value abc (j) is:'| | v_abc (j))

END LOOP

Dbms_output.put_line ('Total number after weight removal' | | SET (v_abc) .count)

End

The output is as follows:

The value abc (j) obtained for the first time is 8

The value abc (j) obtained for the second time is: 2

The value abc (j) obtained for the third time is: 7

The value abc (j) obtained for the fourth time is: 4

The value abc (j) obtained for the fifth time is: 8

The value abc (j) obtained for the sixth time is: 3.

The value abc (j) obtained for the seventh time is: 8.

The value abc (j) obtained for the 8th time is: 7.

The value abc (j) obtained for the 9th time is: 4

The value abc (j) obtained for the 10th time is: 6.

The total number of data after weight removal is: 6

At this point, I believe you have a deeper understanding of "SYS.STANDARD package analysis in Oracle database". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.