Manual pl sql developer em portugues
Regarding the image of the folders is just one way or organizing the information if you right click a query you can place it within a folder. In fact having an SQL Query on the power query if you replace the filtering on the SQL syntax by a parameter you can in fact use an input from the user (excel or other type) to make the SQL return a different filter from the ones you created the query, this is the same behaviour has you have in any SQL consultation that you can define variable to filter your information the only thing is that Power BI allows you to add the values of those parameters in several different ways using the custom function. So in summary the SalesPersonId you see on the image of the custom function is the column name on the table where you are calling the function. Then they use the values on this table to call the custom function.
In this case what you see is that they create a new Sheet 1 where the columns are the SalespersonID Hi custom function uses the columns of the table were you invoke it to populate the parameters of the function. Does anyone have any better examples of when to use "Invoke a custom function"?
#Manual pl sql developer em portugues code#
Based on this example, no code was written - So Im not sure exactly whats going on?Īlso, Im not sure how realistic this example would be - To have someone input a list of excel values in order to pull data in. Im not sure what happened here - As when I think function, I think PL/SQL functions/procedures where there is code written.
I see the previously defined parameter "SalesPerson" - Ok - And another drop down listing "SalesPersonID"
#Manual pl sql developer em portugues how to#
In this tutorial, you have learned how to use the PL/SQL IF statement to either execute or skip a sequence of statements depending on a specified condition. So there is a drop down "Function Query" - I choose the function that was created earlier "GetSalesPerson", which will then auto-populate the "New column name" Code language: SQL (Structured Query Language) (sql) However, if you have too many levels of nesting, the code will be hard to read and maintain, so you should avoid nesting the IF statements. Moving along - The example goes on to say to go to the "Sheet1" query (which is now renamed as SalesPersonID supposedly) and "Invoke Custom Function" which then yields the following screen I dont understand why suddenly it would show with another subfolder ? Cool beans so farĪfter clicking OK it should then pop up the following screen The if I understand correctly was the parameter that was created earlier on in the example and is being used in the query. So far this is easy, I just gave a name to a function. So going through the given example it says to "Right click query 1 and select " - A new window will pop up asking for a name for the function as shown below Now this entire page is talking about parameters and how to use parameters. Specifically on this page in the section "Create dynamic reports for multiple values"
So Im going through the Microsoft Training for DA100 and am a bit confused by something in one of the modules.