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

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, 5441👍, 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, 5440👍, 0💬

How To Use Attributes of the Implicit Cursor
How To Use Attributes of the Implicit Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL Right after executing a DML statement, you retrieve any attribute of the implicit cursor by using SQL%attribute_name, as shown in the following tutorial exercise: CREATE TABLE student (id NUMBER(5) PRIMAR...
2007-04-29, 5440👍, 0💬

How To Write an Array to a File without a File Handle
How To Write an Array to a File without a File Handle? - PHP Script Tips - Reading and Writing Files If you have an array, want to write it to a file, and you don't want to open the file with a file handle, you can use the file_put_contents(). It opens the specified file, writes all values from the ...
2007-04-23, 5439👍, 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, 5439👍, 0💬

What is "this" keyword?
What is "this" keyword? It refers to the current object.
2008-11-04, 5438👍, 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, 5438👍, 0💬

What is the difference between XML and C or C++ or Java
What is the difference between XML and C or C++ or Java? C and C++ (and other languages like FORTRAN, or Pascal, or Visual Basic, or Java or hundreds more) are programming languages with which you specify calculations, actions, and decisions to be carried out in order. XML is a markup specification ...
2007-04-11, 5438👍, 0💬

How To Update Values on Multiple Rows
How To Update Values on Multiple Rows? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE 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...
2007-05-11, 5437👍, 0💬

How To Use "mysql" to Run SQL Statements
How To Use "mysql" to Run SQL Statements? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to run SQL statement to your server with "mysql", you need to start "mysql" and enter your SQL statement at the "mysql" prompt. Here is a good tutorial exercise that shows you how to ru...
2007-05-11, 5437👍, 0💬

How To Remove the New Line Character from the End of a Text Line
How To Remove the New Line Character from the End of a Text Line? - PHP Script Tips - PHP Built-in Functions for Strings If you are using fgets() to read a line from a text file, you may want to use the chop() function to remove the new line character from the end of the line as shown in this PHP sc...
2007-04-22, 5436👍, 0💬

How To Connect to MySQL from a PHP Script
How To Connect to MySQL from a PHP Script? - PHP Script Tips - Working with MySQL Database If you want access the MySQL server, you must create a connection object first by calling the mysql_connect() function in the following format: $con = mysql_connect($server, $username, $password); If you are c...
2007-04-18, 5436👍, 0💬

Walking us through the steps necessary to parse XML documents
Can you walk us through the steps necessary to parse XML documents? Superficially, this is a fairly basic question. However, the point is not to determine whether candidates understand the concept of a parser but rather have them walk through the process of parsing XML documents step-by-step. Determ...
2007-04-11, 5436👍, 0💬

How To Assign Data of the Deleted Row to Variables
How To Assign Data of the Deleted Row to Variables? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If a DELETE statement is deleting a single row, you can assign column values of the deleted row to variables by using the RETURNING clause, which an extension of DELETE statements for PL/SQ...
2007-04-27, 5435👍, 0💬

What Is MySQL
What Is MySQL? - MySQL FAQs - Database Basics and Terminologies MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com.
2007-05-10, 5434👍, 0💬

What Are the Non-Standard SQL Commands Supported by "mysql"
What Are the Non-Standard SQL Commands Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql There are many non-standard SQL commands that are supported by "mysql". Here is short list of some commonly used commands: "SHOW infoName" - Shows basic information of based on the speci...
2007-05-10, 5433👍, 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, 5433👍, 0💬

What is DCOM Can anybod explain in detail
What is DCOM Can anybod explain in detail Short for Distributed Component Object Model, an extension of the Component Object Model (COM) that allows COM components to communicate across network boundaries. Traditional COM components can only perform interprocess communication across process boundari...
2009-03-06, 5431👍, 0💬

Can we use events with threading
Can we use events with threading ? Yes, you can use events with thread; this is one of the techniques to synchronize one thread with other.
2007-10-22, 5431👍, 0💬

How To Recover a Dropped Table
How To Recover a Dropped Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you accidentally dropped a table, can you recover it back? The answer is yes, if you have the recycle bin feature turned on. You can use the FLASHBACK TABLE ... TO BEFORE DROP statement to recover a dropped table f...
2007-05-03, 5431👍, 0💬

What Is Oracle Server Autotrace
What Is Oracle Server Autotrace? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Autotrace is Oracle server feature that generates two statement execution reports very useful for performance tuning: Statement execution path - Shows you the execution loop logic of a DML statement...
2007-04-29, 5431👍, 0💬

How To Validate XHTML Documents Online
How To Validate XHTML Documents Online? - XHTML FAQs - Introduction To XHTML 1.0 If you have just finished a new XHTML document, and you want to make sure that confirms with the XHTML specification, you can use the XHTML online validator at http://validator.w3.org/ . There are 3 ways you can use thi...
2007-05-12, 5430👍, 0💬

What Is an XHTML Element
What Is an XHTML Element? - XHTML Tutorials - Introduction To Tag and Attribute Syntax An XHTML element is the basic building block of an XHTML document. An XHTML element has the following features: An XHTML element must have a name. An XHTML element may have zero or more attributes. An XHTML elemen...
2007-05-12, 5429👍, 0💬

What Happens If File Name is Missing in a URL
What Happens If File Name is Missing in a URL? - XHTML 1.0 Tutorials - Understanding Hyper Links and URLs If the file name part is missing in a URL, the one of the following two rules will be used. 1. If a URL has no file name, but a path name is given, the browser will let the hosting computer to s...
2007-05-12, 5427👍, 0💬

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