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

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, 5225👍, 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, 5225👍, 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, 5225👍, 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, 5224👍, 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, 5224👍, 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, 5223👍, 0💬

How about 2+5+8?
How about 2+5+"8"? Since 2 and 5 are integers, this is number arithmetic, since 8 is a string, it’s concatenation, so 78 is the result.
2008-09-16, 5223👍, 0💬

What Is the Body Tag/Element
What Is the Body Tag/Element? - XHTML 1.0 Tutorials - Body Tag and Block Level Tags The body element is used to provide content of the XHTML document. Here are some rules about the body tag/element: The body element is a second level element. The body element must be the second child element of the ...
2007-05-12, 5223👍, 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, 5223👍, 0💬

How To Drop an Existing Index
How To Drop an Existing Index? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you don't need an existing index any more, you should delete it with the "DROP INDEX indexName ON tableName" statement. Here is an example SQL script: mysql> DROP INDEX tip_subject ON tip; Query OK, ...
2007-05-11, 5222👍, 0💬

How To Insert a Record into a Table
How To Insert a Record into a Table? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a RECORD variable with data fields matching a table structure, you can insert a row to this table with this RECORD variable using the INSERT statement as shown in the example below: CREATE TAB...
2007-04-26, 5222👍, 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, 5222👍, 0💬

How To Download Oracle Database 10g XE
How To Download Oracle Database 10g XE? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If you want to download a copy of Oracle Database 10g Express Edition, visit http://www.oracle.com/technolo gy/software/products/database/ xe/.If you are using Windows systems, there are dow...
2007-04-23, 5222👍, 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, 5222👍, 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, 5222👍, 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, 5221👍, 0💬

How To Read One Character from a File
How To Read One Character from a File? - PHP Script Tips - Reading and Writing Files If you have a text file, and you want to read the file one character at a time, you can use the fgetc() function. It reads the current character, moves the file pointer to the next character, and returns the charact...
2007-04-22, 5221👍, 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, 5220👍, 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, 5219👍, 0💬

What is project management?
What is project management Applying knowledge, skills, tools, techniques in project and deliver project deliverables is a short definition of project management.It’s basically managing project time, cost and scope.
2007-10-30, 5218👍, 0💬

What Is the Icon for Atom Syndication
What Is the Icon for Atom Syndication? - RSS FAQs - Atom Feed Introduction and File Generation The Web browser and Website syndication industry has adopted a standard icon to identify syndicated content as shown below: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
2007-05-12, 5218👍, 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, 5218👍, 0💬

What Are Character Functions
What Are Character Functions? Character Functions are INITCAP, UPPER, LOWER, SUBSTR and LENGTH. Additional functions are GREATEST and LEAST.
2007-04-15, 5218👍, 0💬

How To Change the Password for Your Own User Account
How To Change the Password for Your Own User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to change the password of your own user account, you should use your user account connect to the server "mysql" first. You should then use the "SET PASSWORD ..." command to c...
2007-05-10, 5217👍, 0💬

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