SQL
-
GRANT and REVOKE Commands
GRANT and REVOKE Commands GRANT SQL is also used in multi-user environments. The GRANT command is used to permit users access…
Read More » -
Creating Views in SQL
VIEW Views are tables whose contents are taken or derived from other tables. View tables do not contain data. They…
Read More » -
CURSORS IN SQL
CURSORS IN SQL A cursor in SQL is a temporary work area created in system memory when a SQL statement…
Read More » -
Embedded SQL
EMBEDDED SQL Programs written in high level languages such as C/C++ can use EMBEDDED SQL to access and update data…
Read More » -
what is a sequence
SEQUENCES A sequence is a database object used to generate sequence numbers for rows in table. It can be used…
Read More » -
SUB QUERIES /NESTED QUERIES
SUB QUERIES (NESTED QUERIES) You can nest the SQL queries within one another. Nested query or sub-query is an SQL…
Read More »