pisces225 / plsql Public

forked from jiw065/plsql

Notifications You must be signed in to change notification settings
Fork 0
Star 1

plsql practice

1 star 1 fork Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 33 Commits
leetcode		leetcode
.gitignore		.gitignore
.whitesource		.whitesource
Autonomous Transaction and Nested transaction.sql		Autonomous Transaction and Nested transaction.sql
Cursor.sql		Cursor.sql
README.md		README.md
SQL INTERVIEW PRACTICE.sql		SQL INTERVIEW PRACTICE.sql
Subprogram.sql		Subprogram.sql
TEST_UTILITY.pck		TEST_UTILITY.pck
bulk SQL and bulk binding.sql		bulk SQL and bulk binding.sql
collection and records(composite data type).sql		collection and records(composite data type).sql
dynamic sql.sql		dynamic sql.sql
exceptions.sql		exceptions.sql
materialized view.sql		materialized view.sql
merge.sql		merge.sql
object type.sql		object type.sql
package.sql		package.sql
plsql practice.sql		plsql practice.sql
scalar data type-label-goto-exit-continue.sql		scalar data type-label-goto-exit-continue.sql
sql_practice.sql		sql_practice.sql
trigger.sql		trigger.sql

Repository files navigation

plsql

plsql practice Notes

PL/SQL Fundamental

https://www.evernote.com/shard/s474/sh/c6ab2af9-c136-4287-bcb6-a6dc4c09154d/a68dbb45efd6f828b612a5e92649cd8e

Static SQL and Cursor

https://www.evernote.com/shard/s474/sh/6b91896c-1438-4af2-9464-34344e967fd6/86daf7be8a4925ac20dbaa2581cb69da

Collections

https://www.evernote.com/shard/s474/sh/6ce9cb7b-a582-4d3e-80ec-bb11de85a974/f3c6c344ef9105f4d2da94d9c0debe56

Record

https://www.evernote.com/shard/s474/sh/53fd2385-0577-42e4-bd01-3983cd241949/a617dc3d3a0c634f9d0bb671c52ddcca

Dynamic SQL

https://www.evernote.com/shard/s474/sh/e2ac5afb-9dbe-4f46-abb7-db486b8a83e3/b8096b9dcdde417b231529c68226218e

Subprograms

https://www.evernote.com/shard/s474/sh/d942ca9e-004c-4bb1-ba4d-6b8997af0c03/1a60cf7675acb707fba62509fd2fea9c

Trigger

https://www.evernote.com/shard/s474/sh/6b3e9b72-981a-49c8-a56f-753a1aebf6e4/a6819fbea4fc306ce330b908dd841bf6

Package

https://www.evernote.com/shard/s474/sh/3614091f-ccc8-4be3-bbe9-ded9cab133e4/cd7a2e7b261237d5d368da0a6a186911

PL/SQL Error Handling

https://www.evernote.com/shard/s474/sh/3fb93b09-ae08-4a13-b291-1deb3cd6d25d/bd48d5696b5a079d61dc454ff0096db4

Performance tuning

https://www.evernote.com/shard/s474/sh/f8246b8e-56a2-4c5f-bd7f-a6a739c11d18/2786def65c52c25ddd5b2fefbf7d91f2

Autonomous transaction and Nested transaction

https://www.evernote.com/shard/s474/sh/70a32882-c511-48de-81f8-d4c6557994dd/135ae93af376af35c62c7df9658bbf3e