Query of complex stored procedures or functions in PL/SQL = avoid writing SQL statements in PL/SQL to query stored procedures or functions

Source: Internet
Author: User

In fact, this is also a problem at work. To tell the truth, I am not willing to do it myself. I also want to write statements for queries, but I have not thoroughly studied this kind of information,
Write SQL statements in JavaProgramAt the same time, I chose to be lazy.

First, if it is golden, of course there is no need to say that the Direct Write statement is similar to select. If it is PL/SQL, it is not that simple. If the storage process is relatively simple,
Or, if the content is relatively simple, it is easy to do. You can write a few more lines at most. If it is a combination of 10 or more tables, at least I have not found a simple method,
So I have to learn.

Second: Let's say the Method = right-click the Stored Procedure =, click test (Chinese or test) =, And then you can see a visual view of the following conditions.
The left side is the condition name, and the right side is the parameter. At this time, you only need to enter the parameter in the parameter column and click Run in the upper left corner. Everything is OK, =, and then click the button next to the last returned result, see? Data Query or operation data has been released.

In fact, this is faster than golden. You don't need to write a statement, but you just need to fill in the parameter. It's easy,

Of course, statements must be written, because many things are satisfied only when pursued.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.