.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

<< < … 150 151 152 153 154 155 156 157 158 159 160 … > >>   Sort: Rank

How To Replace a Substring in a Given String
How To Replace a Substring in a Given String? - PHP Script Tips - PHP Built-in Functions for Strings If you know the position of a substring in a given string, you can replace that substring by another string by using the substr_replace() function. Here is a PHP script on how to use substr_replace()... 2007-04-21, 4832👍, 0💬

What Is a User Role
What Is a User Role? - Oracle DBA FAQ - Oracle Basic Concepts A user role is a group of privileges. Privileges are assigned to users through user roles. You create new roles, grant privileges to the roles, and then grant roles to users. 2007-04-21, 4701👍, 0💬

What Is the Relation of a User Account and a Schema
What Is the Relation of a User Account and a Schema? - Oracle DBA FAQ - Oracle Basic Concepts User accounts and schemas have a one-to-one relation. When you create a user, you are also implicitly creating a schema for that user. A schema is a logical container for the database objects (such as table... 2007-04-21, 4617👍, 0💬

How To Take a Substring from a Given String
How To Take a Substring from a Given String? - PHP Script Tips - PHP Built-in Functions for Strings If you know the position of a substring in a given string, you can take the substring out by the substr() function. Here is a PHP script on how to use substr(): &lt;?php $string = "beginning"; pri... 2007-04-21, 4852👍, 0💬

How To Omit Columns with Default Values in INSERT Statement
How To Omit Columns with Default Values in INSERT Statement? - Oracle DBA FAQ - Understanding SQL DML Statements If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you can provide a colum... 2007-04-21, 4627👍, 0💬

How To Pad an Array with the Same Value Multiple Times
How To Pad an Array with the Same Value Multiple Times? - PHP Script Tips - PHP Built-in Functions for Arrays If you want to add the same value multiple times to the end or beginning of an array, you can use the array_pad($array, $new_size, $value) function. If the second argument, $new_size, is pos... 2007-04-21, 5103👍, 0💬

How To Insert Multiple Rows with One INSERT Statement
How To Insert Multiple Rows with One INSERT Statement? - Oracle DBA FAQ - Understanding SQL DML Statements If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the target table. The f... 2007-04-21, 5442👍, 0💬

How To Create an Array with a Sequence of Integers or Characters
How To Create an Array with a Sequence of Integers or Characters? - PHP Script Tips - PHP Built-in Functions for Arrays The quickest way to create an array with a sequence of integers or characters is to use the range() function. It returns an array with values starting with the first integer or cha... 2007-04-21, 5134👍, 0💬

How To Convert Strings to Upper or Lower Cases
How To Convert Strings to Upper or Lower Cases? - PHP Script Tips - PHP Built-in Functions for Strings Converting strings to upper or lower cases are easy. Just use strtoupper() or strtolower() functions. Here is a PHP script on how to use them: &lt;?php $string = "PHP string functions are easy ... 2007-04-21, 5527👍, 0💬

How To Reformat a Paragraph of Text
How To Reformat a Paragraph of Text? - PHP Script Tips - PHP Built-in Functions for Strings You can wordwrap() reformat a paragraph of text by wrapping lines with a fixed length. Here is a PHP script on how to use wordwrap(): &lt;?php $string = "TRADING ON MARGIN POSES ADDITIONAL RISKS AND IS NO... 2007-04-21, 4920👍, 0💬

How To Update Values on Multiple Rows
How To Update Values on Multiple Rows? - Oracle DBA FAQ - Understanding SQL DML Statements If the WHERE clause in an UPDATE matches multiple rows, the SET clause will be applied to all matched rows. This rule allows you to update values on multiple rows in a single UPDATE statement. Here is a good e... 2007-04-21, 5236👍, 0💬

How To Update Values in a Table
How To Update Values in a Table? - Oracle DBA FAQ - Understanding SQL DML Statements If you want to update some values in one row or multiple rows in a table, you can use the UPDATE statement. The script below shows a good example: UPDATE fyi_links SET counts = 999, notes = 'Good site.' WHERE id = 1... 2007-04-21, 4777👍, 0💬

What is Program Global Area (PGA)
What is Program Global Area (PGA)? - Oracle DBA FAQ - Oracle Basic Concepts A Program Global Area (PGA) is a memory buffer that is allocated for each individual database session and it contains session specific information such as SQL statement data or buffers used for sorting. The value specifies t... 2007-04-21, 4880👍, 0💬

What Is a User Account
What Is a User Account? - Oracle DBA FAQ - Oracle Basic Concepts A user account is identified by a user name and defines the user's attributes, including the following: Password for database authentication Privileges and roles Default tablespace for database objects Default temporary tablespace for ... 2007-04-21, 4545👍, 0💬

How To Randomly Retrieve a Value from an Array
How To Randomly Retrieve a Value from an Array? - PHP Script Tips - PHP Built-in Functions for Arrays If you have a list of favorite greeting messages, and want to randomly select one of them to be used in an email, you can use the array_rand() function. Here is a PHP example script: &lt;?php $a... 2007-04-21, 5393👍, 0💬

How To Convert the First Character to Upper Case
How To Convert the First Character to Upper Case? - PHP Script Tips - PHP Built-in Functions for Strings If you are processing an article, you may want to capitalize the first character of a sentence by using the ucfirst() function. You may also want to capitalize the first character of every words ... 2007-04-21, 5281👍, 0💬

How To Compare Two Strings with strcmp()
How To Compare Two Strings with strcmp()? - PHP Script Tips - PHP Built-in Functions for Strings PHP supports 3 string comparison operators, &lt;, ==, and &gt;, that generates Boolean values. But if you want to get an integer result by comparing two strings, you can the strcmp() function, wh... 2007-04-21, 7601👍, 0💬

How To Use Values from Other Tables in UPDATE Statements
How To Use Values from Other Tables in UPDATE Statements? - Oracle DBA FAQ - Understanding SQL DML Statements If you want to update values in one with values from another table, you can use a subquery in the SET clause. The subquery should return only one row for each row in the update table that ma... 2007-04-21, 4848👍, 0💬

How To Use Existing Values in UPDATE Statements
How To Use Existing Values in UPDATE Statements? - Oracle DBA FAQ - Understanding SQL DML Statements If a row matches the WHERE clause in a UPDATE statement, existing values in this row can be used in expressions to provide new values in the SET clause. Existing values are represented by columns in ... 2007-04-21, 4727👍, 0💬

How To Use an Array as a Stack
How To Use an Array as a Stack? - PHP Script Tips - PHP Built-in Functions for Arrays A stack is a simple data structure that manages data elements following the first-in-last-out rule. You use the following two functions together to use an array as a stack: array_push($array, $value) - Pushes a new... 2007-04-21, 5137👍, 0💬

What Is a Initialization Parameter File
What Is a Initialization Parameter File? - Oracle DBA FAQ - Oracle Basic Concepts An initialization parameter file is a text file that contains a list of initialization parameters. The file should be written in the client's default character set. Sample initialization parameter files are provided on... 2007-04-21, 4713👍, 0💬

What is System Global Area (SGA)
What is System Global Area (SGA)? - Oracle DBA FAQ - Oracle Basic Concepts The System Global Area (SGA) is a memory area that contains data shared between all database users such as buffer cache and a shared pool of SQL statements. The SGA is allocated in memory when an Oracle database instance is s... 2007-04-21, 4965👍, 0💬

How To Delete an Existing Row from a Table
How To Delete an Existing Row from a Table? - Oracle DBA FAQ - Understanding SQL DML Statements If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: INSERT INTO fyi_links (url, id) VAL... 2007-04-21, 4900👍, 0💬

How To Use an Array as a Queue
How To Use an Array as a Queue? - PHP Script Tips - PHP Built-in Functions for Arrays A queue is a simple data structure that manages data elements following the first-in-first-out rule. You use the following two functions together to use an array as a queue: array_push($array, $value) - Pushes a ne... 2007-04-21, 8460👍, 0💬

<< < … 150 151 152 153 154 155 156 157 158 159 160 … > >>   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