.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

<< < … 153 154 155 156 157 158 159 160 161 162 163 … > >>   Sort: Rank

How Many Ways to Include Variables in Double-Quoted Strings
How Many Ways to Include Variables in Double-Quoted Strings? - PHP Script Tips - Understanding String Literals and Operations There are 3 formats to include variables in double-quoted strings: "part 1 $variable part 2" - This is the simplest format to include a variable in a string. The variable nam... 2007-04-20, 5044👍, 0💬

How To Include Variables in Double-Quoted Strings
How To Include Variables in Double-Quoted Strings? - PHP Script Tips - Understanding String Literals and Operations Variables included in double-quoted strings will be interpolated. Their values will be concatenated into the enclosing strings. For example, two statements in the following PHP script ... 2007-04-20, 5010👍, 0💬

How To Use Group Functions in the SELECT Clause
How To Use Group Functions in the SELECT Clause? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If group functions are used in the SELECT clause, they will be used on the rows that meet the query selection criteria, the output of group functions will be returned as output of the query.... 2007-04-20, 5226👍, 0💬

What Are Group Functions
What Are Group Functions? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements Group functions are functions applied to a group of rows. Examples of group functions are: COUNT(*) - Returns the number of rows in the group. MIN(exp) - Returns the minimum value of the expression evaluated on ea... 2007-04-20, 4859👍, 0💬

Can You Add Values to an Array without a Key
Can You Add Values to an Array without a Key? - PHP Script Tips - Understanding PHP Arrays and Their Basic Operations Can You Add Values to an Array with a Key? The answer is yes and no. The answer is yes, because you can add values without specifying any keys. The answer is no, because PHP will add... 2007-04-20, 5467👍, 0💬

How Values in Arrays Are Indexed
How Values in Arrays Are Indexed? - PHP Script Tips - Understanding PHP Arrays and Their Basic Operations Values in an array are all indexed their corresponding keys. Because we can use either an integer or a string as a key in an array, we can divide arrays into 3 categories: Numerical Array - All ... 2007-04-20, 5093👍, 0💬

How Many Ways to Include Array Elements in Double-Quoted Strings
How Many Ways to Include Array Elements in Double-Quoted Strings? - PHP Script Tips - Understanding String Literals and Operations There are 2 formats to include array elements in double-quoted strings: "part 1 $array[key] part 2" - This is called simple format. In this format, you can not specify t... 2007-04-20, 4887👍, 0💬

How To Access a Specific Character in a String
How To Access a Specific Character in a String? - PHP Script Tips - Understanding String Literals and Operations Any character in a string can be accessed by a special string element expression: $string{index} - The index is the position of the character counted from left and starting from 0. Here i... 2007-04-20, 5207👍, 0💬

Can Group Functions Be Mixed with Non-group Selection Fields
Can Group Functions Be Mixed with Non-group Selection Fields? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If a group function is used in the SELECT clause, all other selection fields must be group level fields. Non-group fields can not be mixed with group fields in the SELECT clause... 2007-04-20, 5323👍, 0💬

How To Divide Query Output into Groups
How To Divide Query Output into Groups? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements You can divide query output into multiple groups with the GROUP BY clause. It allows you specify a column as the grouping criteria, so that rows with the same value in the column will be considered a... 2007-04-20, 5849👍, 0💬

How To Retrieve Values out of an Array
How To Retrieve Values out of an Array? - PHP Script Tips - Understanding PHP Arrays and Their Basic Operations You can retrieve values out of arrays using the array element expression $array[$key]. Here is a PHP example script: &lt;?php $languages = array(); $languages["Zero"] = "PHP"; $languag... 2007-04-20, 4941👍, 0💬

How To Assigning a New Character in a String
How To Assigning a New Character in a String? - PHP Script Tips - Understanding String Literals and Operations The string element expression, $string{index}, can also be used at the left side of an assignment statement. This allows you to assign a new character to any position in a string. Here is a... 2007-04-20, 4939👍, 0💬

How To Concatenate Two Strings Together
How To Concatenate Two Strings Together? - PHP Script Tips - Understanding String Literals and Operations You can use the string concatenation operator (.) to join two strings into one. Here is a PHP script example of string concatenation: &lt;?php echo 'Hello ' . "world!\n"; ?&gt; This scri... 2007-04-20, 5168👍, 0💬

How To Count Duplicated Values in a Column
How To Count Duplicated Values in a Column? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you have a column with duplicated values, and you want to know what are those duplicated values are and how many duplicates are there for each of those values, you can use the GROUP BY ... HAV... 2007-04-20, 5066👍, 0💬

How To Apply Filtering Criteria at Group Level
How To Apply Filtering Criteria at Group Level? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you want to return only specific groups from the query, you can apply filtering criteria at the group level by using the HAVING clause inside the GROUP BY clause. The following script give... 2007-04-20, 4993👍, 0💬

How To Test If a Variable Is an Array
How To Test If a Variable Is an Array? - PHP Script Tips - Understanding PHP Arrays and Their Basic Operations Testing if a variable is an array is easy. Just use the is_array() function. Here is a PHP script on how to use is_array(): &lt;?php $var = array(0,0,7); print("Test 1: ". is_array($var... 2007-04-20, 5253👍, 0💬

How To Create an Array
How To Create an Array? - PHP Script Tips - Understanding PHP Arrays and Their Basic Operations You can create an array using the array() constructor. When calling array(), you can also initialize the array with pairs of keys and values. Here is a PHP script on how to use array(): &lt;?php print... 2007-04-20, 5280👍, 0💬

How To Compare Two Strings with Comparison Operators
How To Compare Two Strings with Comparison Operators? - PHP Script Tips - Understanding String Literals and Operations PHP supports 3 string comparison operators, &lt;, ==, and &gt;, that generates Boolean values. Those operators use ASCII values of characters from both strings to determine ... 2007-04-20, 5022👍, 0💬

Can Group Functions Be Used in the ORDER BY Clause
Can Group Functions Be Used in the ORDER BY Clause? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If the query output is aggregated as groups, you can sort the groups by using group functions in the ORDER BY clause. The following statement returns how many employees are having the sam... 2007-04-20, 4969👍, 0💬

Can Multiple Columns Be Used in GROUP BY
Can Multiple Columns Be Used in GROUP BY? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements You can use multiple columns in the GROUP BY clause as shown in the following example. It returns how many employees are having the same salary in each department: SQL> SELECT department_id, salary... 2007-04-20, 5251👍, 0💬

What Is an Array in PHP
What Is an Array in PHP? - PHP Script Tips - Understanding PHP Arrays and Their Basic Operations An array in PHP is really an ordered map of pairs of keys and values. Comparing with Perl, an array in PHP is not like a normal array in Perl. An array in PHP is like an associate array in Perl. But an a... 2007-04-20, 5239👍, 0💬

How To Convert Numbers to Strings
How To Convert Numbers to Strings? - PHP Script Tips - Understanding String Literals and Operations In a string context, PHP will automatically convert any numeric value to a string. Here is a PHP script examples: &lt;?php print(-1.3e3); print("\n"); print(strlen(-1.3e3)); print("\n"); print("Pr... 2007-04-20, 5228👍, 0💬

How To Convert Strings to Numbers
How To Convert Strings to Numbers? - PHP Script Tips - Understanding String Literals and Operations In a numeric context, PHP will automatically convert any string to a numeric value. Strings will be converted into two types of numeric values, double floating number and integer, based on the followi... 2007-04-20, 5272👍, 0💬

How To Join Two Tables in a Single Query
How To Join Two Tables in a Single Query? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements Two tables can be joined together in a query in 4 ways: Inner Join: Returns only rows from both tables that satisfy the join condition. Left Outer Join: Returns rows from both tables that satisfy t... 2007-04-20, 5395👍, 0💬

<< < … 153 154 155 156 157 158 159 160 161 162 163 … > >>   Sort: Rank

.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