<< < 61 62 63 64 65 66 67 68 69 70 71 > >>   Sort: Date

How To Add a New Column to an Existing Table
How To Add a New Column to an Existing Table? - Oracle DBA FAQ - Understanding SQL DDL Statements If you have an existing table with existing data rows, and want to add a new column to that table, you can use the ALTER TABLE ... ADD statement to do this. Here is an example script: SQL> connect HR/fy...
2007-04-22, 5263👍, 0💬

What Are the Options to Transfer Session IDs
What Are the Options to Transfer Session IDs? - PHP Script Tips - Understanding and Using Sessions Once a new session is created, its session ID must be transferred to the client browser and included in the next client request, so that the PHP engine can find the same session created by the same vis...
2007-04-18, 5263👍, 0💬

What Is SQL*Plus
What Is SQL*Plus? SQL*Plus is an Oracle command line utility used for executing SQL and PL/SQL commands. The GUI version is called SQL Worksheet.
2007-04-15, 5263👍, 0💬

What does undefined value mean in JavaScript?
What does undefined value mean in JavaScript? Undefined value means the variable used in the code doesn't exist or is not assigned any value, or the property doesnt exist.
2008-11-18, 5262👍, 0💬

How To Specify Domain and Path for a Cookie
How To Specify Domain and Path for a Cookie? - PHP Script Tips - Understanding and Managing Cookies If you want to specify domain and path for cookie, you can use the setcookie() function with two extra parameters. The sample PHP script below shows you how to set the domain and path attributes for t...
2007-04-24, 5262👍, 0💬

How do I sign out in forms authentication
How do I sign out in forms authentication ? FormsAuthentication.Signout()
2007-10-24, 5261👍, 0💬

When we use windows API in .NET is it managed or unmanaged code
When we use windows API in .NET is it managed or unmanaged code ? Windows API in .NET is unmanaged code. Note:- Even though VB6 and V C++ has gone off still many people do ask these old questions again and again. Still there are decent old application which are working with COM very much fine. So in...
2007-10-22, 5261👍, 0💬

How Data Locks Are Respected
How Data Locks Are Respected? - Oracle DBA FAQ - Understanding SQL Transaction Management Here are the rules on how data locks are respected: All statements ignore data locks owned its own transaction. SELECT query statements ignores data locks owned by any transactions. INSERT, UPDATE, and DELETE s...
2007-04-17, 5261👍, 0💬

How To Insert Data into an Existing Table
How To Insert Data into an Existing Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql ...
2007-05-10, 5260👍, 0💬

What’s the difference between Cache object and application object
What’s the difference between Cache object and application object ? The main difference between the Cache and Application objects is that the Cache object provides cache-specific features, such as dependencies and expiration policies.
2007-10-23, 5259👍, 0💬

What Happen to Font Sizes with Relative Page Width Units
What Happen to Font Sizes with Relative Page Width Units? - CSS Tutorials - Page Layout and Background Image Design If you set your page width to relative length units like pixels, what will happen to font sizes? Usually, font sizes have absolute length units like point (pt). If you specify font siz...
2007-05-11, 5259👍, 0💬

How To Write a Query with a Left Outer Join
How To Write a Query with a Left Outer Join? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you want to query from two tables with a left outer join, you can use the LEFT OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a left outer join from two...
2007-05-11, 5259👍, 0💬

How To Retrieve Data from an Cursor to a RECORD
How To Retrieve Data from an Cursor to a RECORD? - Oracle DBA FAQ - Working with Cursors in PL/SQL If you have a cursor opened ready to use, you can also use the FETCH statement to retrieve data from the cursor into a RECORD variable as shown in the tutorial exercise below: CREATE OR REPLACE PROCEDU...
2007-04-29, 5259👍, 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, 5259👍, 0💬

Building Search Engines for Large Volumes of XML Data
How would you build a search engine for large volumes of XML data? The way candidates answer this question may provide insight into their view of XML data. For those who view XML primarily as a way to denote structure for text files, a common answer is to build a full-text search and handle the data...
2007-04-11, 5259👍, 0💬

What Is "mysqlshow"
What Is "mysqlshow"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqlshow" is a command-line interface for end users to see information on tables and columns. Here are some sample commands supported by "mysqlshow": "mysqlshow" - Shows all the databases. "mysqlshow databaseName" - ...
2007-05-11, 5258👍, 0💬

Where Are PHP Configuration Settings Stored
Where Are PHP Configuration Settings Stored? - PHP Script Tips - Downloading and Installing PHP PHP stores configuration settings in a file called php.ini in PHP home directory. You can open it with any text editor to your settings.
2007-04-22, 5258👍, 0💬

What Is the HEAD Tag/Element
What Is the HEAD Tag/Element? - XHTML 1.0 Tutorials - Document Structure and Head Level Tags The head element is the second element you need to learn. The head element is used to provide information about the XHTML document. The head element should not be used to contain any contents of the XHTML do...
2007-05-12, 5257👍, 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, 5257👍, 0💬

What Is a Data Lock
What Is a Data Lock? - Oracle DBA FAQ - Understanding SQL Transaction Management A data lock is logical flag the Oracle server is placed on data objects to give an exclusive right to a transaction. Statements in other transactions needs to respect data locks based on certain rules. Rules on data loc...
2007-04-17, 5257👍, 0💬

Why Is XML Such an Important Development?
Why is XML such an important development? It removes two constraints which were holding back Web developments: Dependence on a single, inflexible document type (HTML) which was being much abused for tasks it was never designed for; The complexity of full SGML, whose syntax allows many powerful but h...
2007-04-11, 5257👍, 0💬

How To Specify Default Values in INSERT Statement
How To Specify Default Values in INSERT Statement? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If a column is defined with a default value in a table, you can use the key word DEFAULT in the INSERT statement to take the default value for that column. The following tutorial ...
2007-05-11, 5256👍, 0💬

How To Connect to MySQL Server on a Different Port
How To Connect to MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration If your MySQL server is listening on port number different than 3306, you need to specify "--port=portNumber" option to any client program that needs to connect to the server. The tutorial exercise...
2007-05-11, 5256👍, 0💬

How to Add Event Handlers?
How to Add Event Handlers? You can add an event handler in the HTML definition of the element like this: &lt;script type="text/javascript">&lt ;!--function hitme() { alert("I've been hit!"); } // --&gt; &lt;/script> &lt;input type="button" id="hitme" name="hitme" value="hit me" o...
2009-01-28, 5254👍, 0💬

<< < 61 62 63 64 65 66 67 68 69 70 71 > >>   Sort: Date