Start Oracle Cryptographic Toolkit operation. dbms_output.put_line(`> Initialize');dbms_crypto_toolkit.Initialize;initialized := TRUE; Open a wallet at the default location. dbms_output.put_line(`> OpenWallet');dbms_crypto_toolkit.OpenWallet(`server1', wallet, persona_list, `default:');wallet...
plsql-hierarchical-profiler.zip This archive contains code to create several PL/SQL programs and to use the PL/SQL hierarchical performance profiler to record the execution of each. It also contains the profiler output for each run, prepared as a set of mutually cross-referencing HTML files. Th...
This collection of code samples demonstrates how to perform operations that change the Dataverse data structures.
Using the repository pattern to connect to Sqlite or SQL Azure databases Connecting to an external web API built with ASP.NET Core 6.0. This sample is designed to cover the core scenarios with minimal architectural complexity. For a more complex, full-featured sample that covers ...
phone_number IS 'Phone number of the employee; includes country code and area code'; COMMENT ON COLUMNemployees.hire_date IS 'Date when the employee started on this job. not null column.'; COMMENT ON COLUMN employees.job_id IS 'Current jobof the employee; foreign key to job_id ...
the JAR package ofudf1isudf1.jarand the JAR package ofudf2isudf2.jar. Assume that both JAR packages contain thecom.huawei.bigdata.iotdb.UDTFExampleclass. If you use two UDFs in the same SQL statement at the same time, the system will randomly load either of them and may cause inconsis...
SqlDBSQL project folder, data storage. Getting Started Prerequisites VS Code Docker .NET SDK 6.0.408 or newer Azure Functions Core Tools Static Web Apps CLI (optional) SignalR endpoint Deploy a local SQL instance The SQL database objects are defined in the SQL project folder an...
Installing the In-Memory OLTP sample based on AdventureWorks Description of the sample tables and procedures Show 3 more Applies to: SQL Server Azure SQL Database Overview This sample showcases the In-Memory OLTP feature. It shows memory-optimized tables and natively compiled stored procedures, ...
A.1.1.1 cr_spatial_index.sql Script The cr_spatial_index.sql script file shows an example of updating the spatial index for a layer, and executing a commit after every 50 GIDs have been entered. The procedures SDO_ADMIN.POPULATE_INDEX() and SDO_ADMIN.POPULATE_INDEX_FIXED() operate as a...
The location of the compiler that is shipped with this release of SQL Server is C:\<Windows root directory>\Microsoft.NET\Framework\v2.0.x. Drive C is the installation drive, <Windows root directory> is either Windows or WINNT, and x is five digits. See Also Other Resources System and ...