User contributions for Bacchas
Jump to navigation
Jump to search
- 18:29, 22 October 2017 diff hist +243 N Equality Joins Created page with "'''The most common type of join used in the workplace is based on two (or more) tables having equivalent data stored in a common column. These joins are called equality joins..."
- 18:28, 22 October 2017 diff hist +25 Oracle SQL
- 18:27, 22 October 2017 diff hist +192 Cartesian Join or Cross Join
- 17:58, 22 October 2017 diff hist +673 N Cartesian Join or Cross Join Created page with " '''In a Cartesian join, also called a Cartesian product or cross join, each record in the first''' '''table is matched with each record in the second table. This type of join..."
- 17:56, 22 October 2017 diff hist −4 Oracle SQL →Joining Data from multiple Tables
- 17:56, 22 October 2017 diff hist −161 Oracle SQL
- 21:19, 18 October 2017 diff hist +179 Transaction Control Statement
- 20:25, 18 October 2017 diff hist +190 Transaction Control Statement
- 20:22, 18 October 2017 diff hist 0 Transaction Control Statement
- 20:22, 18 October 2017 diff hist +525 N Transaction Control Statement Created page with "==Commit Command == '''A COMMIT command issued implicitly or explicitly permanently saves the DML statements issued previously''' *An explicit COMMIT occurs when you enter a C..."
- 20:13, 18 October 2017 diff hist +42 Oracle SQL →Data Manipulation and Transaction Control
- 20:12, 18 October 2017 diff hist −19 Delete Command
- 20:07, 18 October 2017 diff hist +78 Delete Command
- 20:01, 18 October 2017 diff hist +65 N Delete Command Created page with "= Delete Command = DELETE FROM acctmanager WHERE amid = 'J500';"
- 19:59, 18 October 2017 diff hist +26 Oracle SQL →Data Manipulation and Transaction Control
- 19:59, 18 October 2017 diff hist 0 Update Command current
- 19:57, 18 October 2017 diff hist +148 Update Command
- 13:59, 18 October 2017 diff hist +444 Update Command
- 13:44, 18 October 2017 diff hist +253 Update Command
- 13:30, 18 October 2017 diff hist +543 N Update Command Created page with "= Update Command = ''' Used to change the contents of existing rows ''' * The UPDATE clause identifies the table containing the records to be changed. * The SET clause ident..."
- 13:27, 18 October 2017 diff hist +26 Oracle SQL
- 13:27, 18 October 2017 diff hist +78 Insert Command
- 13:27, 18 October 2017 diff hist +79 Constraints
- 13:26, 18 October 2017 diff hist −3 Oracle SQL →Data Manipulation and Transaction Control
- 01:19, 18 October 2017 diff hist +92 Insert Command
- 01:14, 18 October 2017 diff hist +359 Insert Command
- 00:59, 18 October 2017 diff hist +514 Insert Command
- 00:43, 17 October 2017 diff hist +95 Insert Command
- 00:03, 17 October 2017 diff hist +100 N Insert Command Created page with "=Insert = ''' Adds new rows to a table, can include subquery to copy rows from an existing table '''"
- 23:51, 16 October 2017 diff hist +33 Oracle SQL
- 23:25, 13 October 2017 diff hist +148 Constraints
- 17:03, 13 October 2017 diff hist +119 Constraints
- 16:23, 13 October 2017 diff hist +315 Constraints
- 16:07, 13 October 2017 diff hist +514 N Constraints Created page with "= Constraints PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL = == Adding Constraints at table creation == CREATE TABLE a_animals( animal_id NUMBER(6), name VARCHAR2(25),..."
- 16:00, 13 October 2017 diff hist +4 Oracle SQL
- 15:59, 13 October 2017 diff hist +69 Oracle SQL →Table Creation and Management
- 13:08, 13 October 2017 diff hist +54 Table Creation and Management →MODIFY COMMAND Change a column size, datatype or default value
- 13:03, 13 October 2017 diff hist +50 Table Creation and Management
- 13:01, 13 October 2017 diff hist +15 Table Creation and Management →Change a column size, datatype or default value
- 13:00, 13 October 2017 diff hist −7 Table Creation and Management →Change a column size, datatype or default value
- 13:00, 13 October 2017 diff hist +155 Table Creation and Management
- 12:57, 13 October 2017 diff hist +316 Table Creation and Management
- 12:52, 13 October 2017 diff hist +327 Database Queries
- 12:50, 13 October 2017 diff hist −304 Table Creation and Management
- 12:47, 13 October 2017 diff hist +107 Table Creation and Management
- 12:41, 13 October 2017 diff hist −110 Table Creation and Management
- 00:35, 13 October 2017 diff hist −1,776 Database Queries
- 23:15, 12 October 2017 diff hist +110 Table Creation and Management
- 23:03, 12 October 2017 diff hist +128 Table Creation and Management
- 22:59, 12 October 2017 diff hist +1,778 Table Creation and Management