... You can put a distinct on it (not forgetting the collate).
This example is expanded in a further article called "Search a database with soundex":
/* USING A CURSOR */
DECLARE @SqlToExecute nvarchar(max);
DECLARE ...
... you need permission to create this function. Don't forget to GRANT permission to execute this function for whatever user/system account that will run it.
-- Drop the function if it already exists
IF ...
... grant execute for your SSRS user)
Add a data source to your SSRS report
Add an SSRS input parameter
Add a dataset
Query type: Stored Procedure
Refresh fields button
Parameter name (oracle input ...
... sac180786.txt
Permissions
CREATE PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR base_table_owner.sp_get_studentdetails_from_ad;
GRANT EXECUTE ON sp_get_studentdetails_from_ad ...
What?
I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function ...
... milliseconds it took for a report to execute... I decided to do a database level calculation using two datasets:
-- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime)
SELECT
field1,
field2,
TO_CHAR(systimestamp, ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.