User contributions for Bacchas
Jump to navigation
Jump to search
- 22:17, 18 November 2017 diff hist +515 N SYNTAX FOR GROUP HAVING ORDER BY Created page with "SELECT ... AGRIGATEDFUNCTION() FROM TABLE1, ... WHERE < CONDITION> GROUP BY COL1, COL2... HAVING <AGG> ORDER BY '''' FIND SALARY BASED ON EACH DEPARTMENT NUMBER''' NOTE: THE..."
- 21:57, 18 November 2017 diff hist +45 Oracle SQL →GROUP BY CLAUSE
- 23:29, 14 November 2017 diff hist +65 INDEX current
- 23:20, 14 November 2017 diff hist +346 N INDEX Created page with "An INDEX is a performance tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed column. By default, Oracl..."
- 23:18, 14 November 2017 diff hist +28 Oracle SQL
- 23:08, 14 November 2017 diff hist +54 SUB QUERIES current
- 23:04, 14 November 2017 diff hist +291 SUB QUERIES
- 21:55, 14 November 2017 diff hist +86 SUB QUERIES
- 21:48, 14 November 2017 diff hist +269 SUB QUERIES
- 20:40, 14 November 2017 diff hist +228 SUB QUERIES
- 20:20, 14 November 2017 diff hist +294 SUB QUERIES
- 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