478 skills found · Page 9 of 16
raverkamp / Plsql ParserA parser for Oracle PL/SQL in written in java. Complete for packages. But no conditional compilation.
ehmad11 / SuiteqlRun SQL queries against Oracle NetSuite using SuiteQL through SuiteTalk Rest Webservices.
mayswind / DotMaysWind.Data非常轻量级的数据库访问工具库，链式代码编写，封装了SQL语句以及各个数据库中常用的函数，支持Access、SQLite、SQL Server CE、SQL Server、MySQL以及Oracle数据库。
jeffreykemp / Clicksend Plsql ApiClicksend API for Oracle PL/SQL
akkadotnet / Akka.Persistence.SqlLinq2Db implementation of Akka.Persistence.Sql. Common implementation for SQL Server, Sqlite, Postgres, Oracle, and MySql.
Apress / Modern Oracle Database ProgrammingSource Code for "Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON" by Alex Nuijten and Patrick Barel
mortenbra / Quick PlsqlCode generator for Oracle PL/SQL based on a simple markup language
DmitryNFomin / Pg 10046Oracle 10046 inspired SQL tracing for PostgreSQL
NordPerfEngg / OracleDBALiteApplication: DBALite Oracle Database Performance Summary App Application Purpose: Provide Oracle host and database performance info suitable for non-dbas. Target users are Non-dba performance engineers, testers, prod support staff and application team members who want to proactively and reactively monitor their databases. Licensing: Because this App queries the dba_hist_sqlstat AWR data, a license must exist for the Oracle Diagnostic Pack. Most facilities running Oracle databases have this license. Application Basic Structure: Four stored procedures run in the Oracle database. They read performance data tables and write it out to datafiles which are consumed by Splunk. Oracle Scheduler jobs execute the stored procedures at configurable intervals. The app also uses the Splunk Add-on for Unix and Linux to get host metrics. Dependencies: Splunk Add-on for Unix and Linux (http://docs.splunk.com/Documentation/UnixAddOn/latest/User/InstalltheSplunkAdd-onforUnixandLinux) Stored procedures and scheduler jobs running in Oracle Database 11.1 or higher (procedures scripts included in the setup files.) Index creation: Splunk Add-on For Unix and Linux will create the 'unix_metrics' index. This DBALite app will create the 'database' index. Sourcetypes: om:oracle:locks -- snapshot information about blocking locks om:oracle:memory -- Oracle sga and pga memory statistics om:oracle:osstat -- Operating System stats from v$osstat table om:oracle:sql -- top resource consuming sqls from dba_hist_sqlstat om:oracle:sqltext -- sqltext for the top resource consuming sqls om:oracle:sysevent -- wait event information om:oracle:sysstat -- performance statistics from v$sysstat table Installation: Oracle Setup: Copy all the sql scripts from the Oracle_Performance_Summary_For_Splunk/bin directory to your database server or run them in SQL Developer or other tool. Connect to your database. As sysdba, create the splunk sch_spl user. (Sysdba is required for this one script in order to grant privileges on DBMS_LOCK and UTL_FILE: @cr_sch_spl.sql Create a unix directory where you want Oracle to write the output files. Splunk will pick up the data from these output files created by the stored procedures. If the owner of the directory is not the ORACLE user, then make the ORACLE user a member of the Unix group for the directory so that Oracle can write to the directory. Make the permissions on the directory 774. Note: For a RAC database, just create the directory on one node. The app is not elaborate enough to provide failover capabilities, so in case of an outage of its node, the data would just not be written until the node came back online. Create an Oracle Directory called 'DIR_SPLUNK' using the above unix directory. Example: CREATE DIRECTORY dir_splunk as '/u01/perf/dbdashboard/data'; grant read,write on directory dir_splunk to sch_spl; As the splunk user SCH_SPL, create the stored procedures and scheduler jobs that will run them: @cr_procs_and_jobs.sql After 10 minutes, check the data files to confirm there is data being written to them. These data files should exist: dbd_locks.txt dbd_memory.txt dbd_osstat.txt dbd_sysevents.txt dbd_sysstat.txt dbd_top_sql_text.txt dbd_top_sql.txt To check the scheduler jobs, as SCH_SPL user, execute: 'SELECT job_name, actual_start_date, status, additional_info from user_scheduler_job_run_details order by actual_start_date;'
ManmeetBains / Hotel Management System DatabaseA Hotel Reservation system Database was designed in Oracle SQL. Database was created and loaded with data using SQL queries. Then to answer Business questions and creates reports on Hotel Business, data was extracted using complex SQL queries. Database was also connected with Tableau to create visualizations to easily understand the Key data insights. TheFinal Project report contains the Database Schema, SQL codes, SQL queries to extract data and visualizations generated from Tableau.
Sean-Lu / DbRepository🔥ORM framework, support databases: MySQL, MariaDB, TiDB, OceanBase, SQL Server, Oracle, SQLite, DuckDB, MS Access, Firebird, PostgreSql, OpenGauss, HighgoDB, IvorySQL, QuestDB, DB2, Informix, ClickHouse, 达梦, 人大金仓, 神通, 虚谷, ...
logcorner / How To Customize Asp.NET Identity Core With External Database Storage Step By StepASP.NET Core Identity is designed to enable us to easily use a number of different storage providers for our ASP.NET applications. We can use the supplied Identity providers that are included with the .NET Framework, or we can implement your own providers. There are two primary reasons for creating a custom Identity provider. We need to store Identity information in a data source that is not supported by the Identity providers included with the .NET Framework, such as a MysQL database, an Oracle database, or other data sources. We need to manage Identity information using a database schema that is different from the database schema used by the providers that ship with the .NET Framework. A common example of this would be to use authentication data that already exists in a SQL Server database for a company or Web site. In this tutorial, we are going to implement and configure a custom Identity Provider using ASP.NET MVC Core and IndentityCore
Apress / Beg Oracle Pl SqlSource code for 'Beginning Oracle PL/SQL' by Donald Bales
HicServices / FAnsiSqlC# library for abstracting the DBMS layer away in ETL applications. Supports table discovery, table creation, bulk insert and type translation for Sql Server, Oracle, PostgresSql and MySql. FAnsiSql is not an ORM its an ETL enabler.
chenquan / SqltraceA low-code intrusion library that provides SQL tracing capabilities, suitable for any relational database (Sqlite3, MySQL, Oracle, SQL Server, PostgreSQL, TiDB, TDengine, etc.) and ORM libraries for various relational database (gorm, xorm, sqlx, ent, etc.)
mmzeeman / EsqlESQL provides an abstraction layer between Erlang programs and SQL relational databases. This lets you write database code once, in Erlang, and have it work with any number of backend SQL databases (Sqlite, MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)
maclochlainn / Plsql 12c ProgrammingOracle Database 12c PL/SQL Programming
Apress / Pro Oracle Sql DevSource code for 'Pro Oracle SQL Development' by Jon Heller
sokolsaiti / Oracle Dba Sql ScriptsVarious SQL scripts for Oracle RDBMS administration that can be used in conjunction with SQL*Plus utility
aamirpatel23 / Oracle Database SQL 1Z0 071 Free Dump QuestionsNo description available
