.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

What Is a Sequences
What Is a Sequences? Sequences are used for generating sequence numbers without any overhead of locking. Drawback is that after generating a sequence number if the transaction is rolled back, then that sequence number is lost. 2007-04-15, 5030👍, 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, 5015👍, 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, 5005👍, 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, 5004👍, 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, 4989👍, 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, 4936👍, 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