<< < 43 44 45 46 47 48 49 50 51 52 53 > >>   Sort: Date

What Are the Impacts on Applications from Locks, Timeouts, and DeadLocks
What Are the Impacts on Applications from Locks, Timeouts, and DeadLocks? - MySQL FAQs - Transaction Management: Commit or Rollback If you are using transactions with REPEATABLE READ isolation level and transaction safe storage engines in your applications, data locks, lock timeouts, and dead lock d...
2007-05-08, 5601👍, 0💬

How To Set a Transaction To Be READ ONLY
How To Set a Transaction To Be READ ONLY? - Oracle DBA FAQ - Understanding SQL Transaction Management If you want a transaction to be set as READ ONLY, you need to the transaction with the SET TRANSACTION READ ONLY statement. Note that a DML statement will start the transaction automatically. So you...
2007-04-17, 5601👍, 0💬

What is difference between dataset and datareader
What is difference between dataset and datareader ? Following are some major differences between dataset and datareader ? DataReader provides forward-only and read-only access to data, while the DataSet object can hold more than one table (in other words more than one rowset) from the same data sour...
2007-10-24, 5600👍, 0💬

Can you list best practices for globalization and localization
Can you list best practices for globalization and localization? Below are the best practices while developing international language support software: Do not hardcode strings or user interface resources. Make sure your application depends on Unicode. When ever you read or write data from various enc...
2007-11-02, 5599👍, 0💬

How White Spaces Are Formatted
How White Spaces Are Formatted? - CSS Tutorials - Understanding Multiple Element Formatting Rules White spaces are formatted depending where they are located: White spaces will be ignored between block elements. White spaces will be preserved in &lt;PRE> tags. White spaces will be collapsed into...
2007-05-11, 5599👍, 0💬

How To Use SELECT Statement to Count the Number of Rows
How To Use SELECT Statement to Count the Number of Rows? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following tutorial exercise shows you some good example: mysql> SELECT COUNT(*) FROM ...
2007-05-11, 5599👍, 0💬

How to Retrieve SQLWarning
How to Retrieve SQLWarning? SQLWarning objects are a subclass of SQLException that deal with database access warnings. Warnings do not stop the execution of an application, as exceptions do. They simply alert the user that something did not happen as planned. A warning can be reported on a Connectio...
2007-04-03, 5599👍, 0💬

How can we use Culture Auto in project
How can we use Culture Auto in project? We will make a simple login screen which we will try to use for English as well as Greek. The login screen will display English settings when an English user logs in and Greek Settings when a Greek user logs in. So below are the steps to start with. In the abo...
2007-11-01, 5598👍, 0💬

How To Use NULL as Conditions
How To Use NULL as Conditions? - Oracle DBA FAQ - Understanding SQL Basics If you want to compare values against NULL as conditions, you should use the "IS NULL" or "IS NOT NULL" operator. Do not use "=" or "&lt;>" against NULL. The sample script below shows you some good examples: SELECT 'A' IS...
2007-04-23, 5598👍, 0💬

How To Add Images to Backgrounds
How To Add Images to Backgrounds? - CSS Tutorials - HTML Formatting Model: Block, Inline and Floating Elements One image can be specified to the background at a particular position. It can also be repeated in horizontal direction, vertical direction, or both directions with the following style prope...
2007-05-11, 5597👍, 0💬

What Is Atom 1.0 Standard
What Is Atom 1.0 Standard? - RSS FAQs - Atom Feed Introduction and File Generation Atom is an XML-based document format that describes lists of related information known as "feeds". Feeds are composed of a number of items, known as "entries", each with an extensible set of attached metadata. For exa...
2007-05-12, 5596👍, 0💬

How To Write a Query with a Left Outer Join
How To Write a Query with a Left Outer Join? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements 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-04-19, 5596👍, 0💬

How To Convert Times to Characters
How To Convert Times to Characters? - Oracle DBA FAQ - Understanding SQL Basics You can convert dates to characters using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(SYSDATE, 'HH:MI:SS') FROM DUAL; 04:49:49 SELECT TO_CHAR(SYSDATE, 'HH24:MI:SS.FF') FROM DUAL; -- Error: S...
2007-04-23, 5595👍, 0💬

How To Force the PHP Engine to Use Cookies to Transfer Session IDs
How To Force the PHP Engine to Use Cookies to Transfer Session IDs? - PHP Script Tips - Understanding and Using Sessions If you want to force your PHP engine to use cookies to transfer session IDs instead of URL parameters, you can open the PHP configuration file, php.ini, and make the following cha...
2007-04-18, 5595👍, 0💬

Can DIV Elements Be Nested
Can DIV Elements Be Nested? - XHTML 1.0 Tutorials - Understanding DIV and SPAN elements Can "div" elements be nested? The answer is yes. In fact, nested "div" elements provides you more flexibilities to specify CSS properties at different levels. Here is a tutorial example of nested "div" elements: ...
2007-05-12, 5594👍, 0💬

How To Submit Values without a Form
How To Submit Values without a Form? - PHP Script Tips - Processing Web Forms If you know the values you want to submit, you can code the values in a hyper link at the end of the URL. The additional values provided at the end of a URL is called query string. There are two suggestions on how to use q...
2007-04-22, 5594👍, 0💬

Can SELECT Statements Be Used on Views
Can SELECT Statements Be Used on Views? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements Select (query) statements can used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: SQL> CREATE VIEW managed_de...
2007-04-20, 5594👍, 0💬

What Is a Join
What Is a Join? Join is the form of SELECT command that combines info from two or more tables. Types of Joins are Simple (Equijoin and Non-Equijoin), Outer and Self join. Equijoin returns rows from two or more tables joined together based upon a equality condition in the WHERE clause. Non-Equijoin r...
2007-04-15, 5594👍, 0💬

publish-and-subscribe and point-to-point
How many messaging models do JMS provide for and what are they? JMS provide for two messaging models, publish-and-subscribe and point-to-point queuing.
2007-04-03, 5594👍, 0💬

General
General - XHTML 1.0 - Interview Questions Do you use any tools when authoring new XHTML documents? Do you use any tools when converting HTML documents to XHTML? How to validate your XHTML documents? How comfortable are you with writing XHTML entirely by hand? Are you excited about XHTML? What would ...
2007-05-12, 5592👍, 0💬

How To Loop through an Array without Using "foreach"
How To Loop through an Array without Using "foreach"? - PHP Script Tips - PHP Built-in Functions for Arrays PHP offers the following functions to allow you loop through an array without using the "foreach" statement: reset($array) - Moves the array internal pointer to the first value of the array an...
2007-04-14, 5592👍, 0💬

Basic Concepts
Basic Concepts - XHTML 1.0 - Interview Questions What is XHTML? How is XHTML related to HTML? How is XHTML related to XML? What are the main advantages of XHTML over HTML? Is an XHTML document an XML document? Is an XML document an XHTML document? Is XHTML going to replace HTML? Is XML going to repl...
2007-05-12, 5591👍, 0💬

What is SIX sigma
What is SIX sigma? Sigma means deviation in Greek language. Deviation means how much variations exist in a set of data. For instance let’s say in a software maintenance project out of 100 defects 68 defects are rectified to the mark and remaining bounce back that means your bug fixing process is on ...
2007-10-30, 5590👍, 0💬

How To Get Execution Path Reports on Query Statements
How To Get Execution Path Reports on Query Statements? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON EXPLAIN" command to turn on execution path reports on query statements. The tutorial...
2007-04-30, 5590👍, 0💬

<< < 43 44 45 46 47 48 49 50 51 52 53 > >>   Sort: Date