.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

< 1 2   Sort: Date

Operators used in SELECT statements
Name some operators used in SELECT statements = Equal or != Not equal > Greater than = Greater than or equal <= Less than or equal BETWEEN Between an inclusive range LIKE Search for a pattern 2007-04-15, 5264👍, 0💬

What Are Group Functions
What Are Group Functions? Group Functions returns results based upon groups of rows rather than one result per row, use group functions. They are AVG, COUNT, MAX, MIN and SUM. 2007-04-15, 5231👍, 0💬

What Are Synonyms
What Are Synonyms? Synonyms is the alias name for table, views, sequences and procedures and are created for reasons of Security and Convenience. Two levels are Public - created by DBA and accessible to all the users. Private - Accessible to creator only. Advantages are referencing without specifyin... 2007-04-15, 5228👍, 0💬

What Is NVL
What Is NVL? NVL is a function lets you substitute a value when a null value is encountered. 2007-04-15, 5228👍, 0💬

Examples of INSERT INTO Statements
Examples of INSERT INTO Statements INSERT INTO table_name VALUES (value1, value2,....) INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....) 2007-04-15, 5224👍, 0💬

What Are Indexes
What Are Indexes? Indexes are optional structures associated with tables used to speed query execution and/or guarantee uniqueness. Create an index if there are frequent retrieval of fewer than 10-15% of the rows in a large table and columns are referenced frequently in the WHERE clause. Implied tra... 2007-04-15, 5099👍, 0💬

< 1 2   Sort: Date

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML