Outer Web | Explore

/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.

You are here		www.binovarghese.com PL SQL Constraints
\|	\|	buttondown.com Integrity Constraints and the Relational Derivative Buttondown	24.2 parsecs away Travel
\|	\|	In a SQL database, you can set up a foreign key with REFERENCES: nullbitmap=# CREATE TABLE ab (a INT PRIMARY KEY, b INT); CREATE TABLE nullbitmap=# INSERT...	24.2 parsecs away Travel
\|	\|	sqlmaria.com Extremely useful Partitioning enhancements in Oracle Database 12c	61.4 parsecs away Travel
\|	\|	Back in January, I promised I would write a series of blogs on some of my favorite new 12c enhancements, designed to make your life easier. I'm finally getting around to keeping that promise with t...	61.4 parsecs away Travel
\|	\|	blog.dancrisan.com Intro to Database Systems - Part 8 to 10 : Intermediate SQL	7.7 parsecs away Travel
\|	\|	Using the next common keywords will return a column with only one row. They are called aggregate functions: 1) COUNT 2) AVG 3) SUM 4) MIN/MAX 1) COUNT : returns the number of rows matching a specific criteria. SELECT COUNT * FROM Skaters SELECT... \| Dan Crisan \| Techie, Blogger, Diversity Advocate and A Little Bit More . This is my technical blog (:	7.7 parsecs away Travel
\|	\|	blog.dancrisan.com Intro to Database Systems : Concurrency Control - Scheduling problems	54.6 parsecs away Travel
\|		In real life, users access a database concurrently. Database access is done through transactions. What is a transaction? a unit of work that has to be treated as "a whole" it has to happen in full or not at all A real life example of a transaction... \| Dan Crisan \| Techie, Blogger, Diversity Advocate and A Little Bit More . This is my technical blog (:	54.6 parsecs away Travel