User contributions for Bacchas
Jump to navigation
Jump to search
- 20:13, 14 November 2017 diff hist +428 N SUB QUERIES Created page with "A SUB QUERY is a query within a query which can return one or more rows SELECT * FROM SALES WHERE CUSTOMER_ID = (SELECT CUSTOMER_ID FROM CUSTOMER WHERE LAST_NAME = 'JOSEPH'..."
- 20:07, 14 November 2017 diff hist +23 Oracle SQL →Restricting Rows and Sorting Data
- 19:09, 14 November 2017 diff hist +276 N REVOKE Created page with "REVOKE command can be used to take back the granted privileges to the user REVOKE SELECT, INSERT DELETE, ON sales FROM scott REVOKE ALL ON sales FROM scott REVOKE UPDATE..." current
- 17:40, 14 November 2017 diff hist +1 Oracle SQL →=REVOKE
- 17:40, 14 November 2017 diff hist +16 Oracle SQL →TABLE PERMISSIONS - GRANT
- 17:36, 14 November 2017 diff hist −1 GRANT current
- 17:36, 14 November 2017 diff hist 0 GRANT
- 17:36, 14 November 2017 diff hist +392 N GRANT Created page with "GRANT command can be used to grant schema object privileges to roles or to users With GRANT OPTION enables the grantee to pass on his privileges GRANT SELECT, INSERT, DELE..."
- 17:33, 14 November 2017 diff hist −1 Oracle SQL →TABLE PERMISSIONS - GRANT
- 17:33, 14 November 2017 diff hist +50 Oracle SQL
- 17:31, 14 November 2017 diff hist +446 N Sequences Created page with "A sequence is an object in oracle that is used to generate a number sequence. this can be useful when you need to create a unique number to act as a primary key. CREATE SEQUE..." current
- 17:25, 14 November 2017 diff hist +38 Oracle SQL
- 17:24, 14 November 2017 diff hist +53 SYNONYM current
- 17:22, 14 November 2017 diff hist +100 SYNONYM
- 16:20, 14 November 2017 diff hist 0 SYNONYM
- 16:20, 14 November 2017 diff hist +2 SYNONYM
- 16:20, 14 November 2017 diff hist +252 N SYNONYM Created page with "==SYNONYM is an alternative name for a table, view, sequence, procedure, stored function The main advantage is that they provide * Data independence * Location transparency..."
- 16:19, 14 November 2017 diff hist +31 Oracle SQL
- 16:03, 14 November 2017 diff hist +172 View →CREATING A VIEW FROM MORE THAN ONE TABLE current
- 16:01, 14 November 2017 diff hist +45 View
- 15:40, 14 November 2017 diff hist +148 View →UPDATING THE VIEW
- 15:12, 14 November 2017 diff hist +24 View
- 15:08, 14 November 2017 diff hist +238 View
- 14:51, 14 November 2017 diff hist +117 View
- 14:40, 14 November 2017 diff hist +332 View
- 14:39, 14 November 2017 diff hist +116 N View Created page with "* A view is the representation of a S Back To Top- Home - Category"
- 14:38, 14 November 2017 diff hist +26 Oracle SQL
- 23:46, 13 November 2017 diff hist +84 Constraints current
- 23:43, 13 November 2017 diff hist +142 Constraints
- 20:36, 13 November 2017 diff hist +27 Delete Command current
- 17:34, 13 November 2017 diff hist +44 TYPES OF PSEUDO COLUMNS current
- 17:32, 13 November 2017 diff hist +80 TYPES OF PSEUDO COLUMNS
- 17:31, 13 November 2017 diff hist +490 N TYPES OF PSEUDO COLUMNS Created page with "A pseudo-column is an Oracle assigned value (pseudo-field) used in the same context as an oracle database column, but not stored on disk ===SYSDATE=== Returns the current date..."
- 17:27, 13 November 2017 diff hist +54 Oracle SQL
- 20:09, 12 November 2017 diff hist +82 Table Creation and Management current
- 19:36, 12 November 2017 diff hist −1 Table Creation and Management →ADDING COMMENTS TO COLUMNS
- 19:04, 12 November 2017 diff hist +57 Table Creation and Management →ADDING COMMENTS TO COLUMNS
- 19:03, 12 November 2017 diff hist +113 Table Creation and Management
- 00:36, 10 November 2017 diff hist +296 CHARACTER BUILT IN FUNCTIONS current
- 19:10, 9 November 2017 diff hist +2 CHARACTER BUILT IN FUNCTIONS →LPAD and RPAD
- 21:31, 8 November 2017 diff hist +207 GROUP BY →GROUPING SETS
- 17:23, 8 November 2017 diff hist +161 GROUP BY →Group by And HAVING
- 17:17, 8 November 2017 diff hist +585 GROUP BY →Group by And HAVING
- 21:12, 7 November 2017 diff hist +116 TYPES →COUNT() Returns the number or rows current
- 20:10, 7 November 2017 diff hist +116 TYPES →SUM() Returns the sum of values
- 14:03, 7 November 2017 diff hist +713 GROUP BY
- 13:59, 7 November 2017 diff hist +166 TYPES
- 13:53, 7 November 2017 diff hist +31 TYPES →AVG() Returns the Average of Values
- 21:30, 6 November 2017 diff hist +124 CHARACTER BUILT IN FUNCTIONS
- 21:26, 6 November 2017 diff hist +218 CHARACTER BUILT IN FUNCTIONS