What?
Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the ...
What?
So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting ...
Previously
For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in ...
... that there appears a link that will run a stored procedure which
Updates a timestamp in an existing table
Inserts a row into an audit table
I need the report to run the stored procedure, then ...
... add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services.
The Error
ORA-00911: invalid character
ORA-06512: at "SYS.DBMS_UTILITY", line 114 ...
... in a secure environment, and access to the data is restricted to authorized personnel only. OpenAI also has strict policies and procedures in place to prevent unauthorized access, disclosure, or modificatio ...
... using Zoho Deluge and not another server-side script such as PHP to send the requests via API.
Following standard OAuth 2.0 procedures, we will get a Code to generate a Refresh token, once we have ...
... suitable physical, electronic and managerial procedures to safeguard and secure the information we collect online.
How we use cookies
A cookie is a small file which asks permission to be placed on your ...
... to the DOR code)
Complete the form as per previous details ensuring you use the same Message Group as the DOR.
In our example, our Type is "SQL db connector" and we use a stored procedure that the ...
What?
Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts ...
What?
This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values:
Before:
ID Name DateOfBirth
--------- ------------ ...
... "WarehouseLoadKey" and the value we want to search on is "3" (the 3rd incremental load).
How?
The below stored procedure can be reduced to just a script as long as you declare and set the parameters ...
... example which outputs a huge SQL query which you then copy & paste and run against your database.
Step 1 of 2
The following stored procedure will generate the full query to your output panel:
CREATE ...
... - Sorna Kumar
IF OBJECT_ID('usp_SearchDB','P') IS NOT NULL
DROP PROCEDURE usp_SearchDB
GO
CREATE PROCEDURE usp_SearchDB
@Tablenames VARCHAR(500)
,@SearchStr NVARCHAR(60)
,@GenerateSQLOnly ...
What?
How to use the randomization features of Oracle PL/SQL.
Why?
I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing ...
Why?
Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the ...
... of this page.
Go go go
Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one.
-- drop a stored procedure if it exists
IF ...
This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...
Why?
We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return ...
I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on ...
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.