.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

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

How Does Oracle Handle Read Consistency
How Does Oracle Handle Read Consistency? - Oracle DBA FAQ - Understanding SQL Transaction Management Oracle supports two options for you on how to maintain read consistency: READ WRITE (the default option), also called statement-level read consistency. READ ONLY, also called transaction-level read c... 2007-04-18, 5345👍, 0💬

How can you increase SQL performance
How can you increase SQL performance ? Following are tips which will increase your SQl performance Every index increases the time takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be too much. Try to use maximum 4-5 indexes on one table, not more. If you have read-on... 2007-10-25, 5344👍, 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, 5344👍, 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, 5344👍, 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, 5343👍, 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, 5343👍, 0💬

What are benefits and limitations of using Hidden frames?
.NET INTERVIEW QUESTIONS - What are benefits and limitations of using Hidden frames? Following are the benefits of using hidden frames: * You can cache more than one data field. * The ability to cache and access data items stored in different hidden forms. * The ability to access JScript® variable v... 2009-07-14, 5342👍, 0💬

What is DISCO
What is DISCO ? DISCO is the abbreviated form of Discovery. It is basically used to club or group common services together on a server and provides links to the schema documents of the services it describes may require. 2007-10-23, 5342👍, 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, 5342👍, 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, 5341👍, 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, 5339👍, 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, 5337👍, 0💬

DOM and XML
What is DOM and how does it relate to XML? The Document Object Model (DOM) is an interface specification maintained by the W3C DOM Workgroup that defines an application independent mechanism to access, parse, or update XML data. In simple terms it is a hierarchical model that allows developers to ma... 2007-04-11, 5337👍, 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, 5336👍, 0💬

What Is a Cursor
What Is a Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL A cursor looks like a variable, but it is not a variable. A cursor looks like a procedure, but it is not a procedure. A cursor is a cursor. It is a logical representation of a resource connects to a set of data rows related to a DML... 2007-04-29, 5336👍, 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, 5336👍, 0💬

What is WSDL
What is WSDL? Web Service Description Language (WSDL)is a W3C specification which defines XML grammar for describing Web Services.XML grammar describes details such as:- ã Where we can find the Web Service (its URI)? ã What are the methods and properties that service supports? ã Data type suppo... 2007-10-23, 5335👍, 0💬

What To Do If DBA Lost the SYSTEM Password
What To Do If DBA Lost the SYSTEM Password? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If the DBA lost the password of the SYSTEM user account, he/she can go to the Oracle server machine, and run SQL*Plus on server locally with the operating system authentication method to ... 2007-04-28, 5335👍, 0💬

Can You Define an Array Argument as a Reference Type
Can You Define an Array Argument as a Reference Type? - PHP Script Tips - Creating Your Own Functions You can define an array argument as a reference type in the function definition. This will automatically convert the calling arguments into references. Here is a PHP script on how to define an array... 2007-04-24, 5335👍, 0💬

What Is a Savepoint
What Is a Savepoint? Savepoint is a point within a particular transaction to which you may rollback without rolling back the entire transaction. 2007-04-15, 5335👍, 0💬

What are the steps to create a windows service in VB.NET
What are the steps to create a windows service in VB.NET? Windows Services are long-running executable applications that run in its own Windows session, which then has the ability to start automatically when the computer boots and also can be manually paused, stopped or even restarted. Following are... 2007-10-24, 5333👍, 0💬

How To Create a Database
How To Create a Database? - PHP Script Tips - Working with MySQL Database A database in a MySQL server is a logical container used to group tables and other data objects together as a unit. If you are a the administrator of the server, you can create and delete databases using the CREATE/DROP DATABA... 2007-04-18, 5333👍, 0💬

Forms authentication
Forms authentication Forms authentication provides you with a way to handle authentication using your own custom logic with in an ASP.NET application. The following applies if you choose forms authentication. ? When a user requests a page for the application, ASP.NET checks for the presence of a spe... 2007-10-24, 5332👍, 0💬

What Are the Attributes of an IMG Element
What Are the Attributes of an IMG Element? - XHTML 1.0 Tutorials - Understanding Inline Images and Image Maps There are 4 commonly used attributes for an "img" element: "src" - Required attribute. Used to specify the URL of the image file. "alt" - Required attribute. Used to specify the name of the ... 2007-05-12, 5331👍, 0💬

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

.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