.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

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

How To Name Query Output Columns
How To Name Query Output Columns? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements Each column in the query output has a default name. If you don't like the default name, you can specify a new name for any column in the query output by using the AS clause. The following statement shows y... 2007-04-19, 5689👍, 0💬

How To Create a Single Index for Multiple Columns
How To Create a Single Index for Multiple Columns? - Oracle DBA FAQ - Managing Oracle Table Indexes If you know a group of multiple columns will be always used together as search criteria, you should create a single index for that group of columns with the "ON table_name(col1, col2, ...)" clause. He... 2007-04-27, 5688👍, 0💬

What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND
What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND? - Oracle DBA FAQ - Understanding SQL Basics The main differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND are: INTERVAL YEAR TO MONTH stores values as time intervals at the month level. INTERVAL DAY ... 2007-04-24, 5688👍, 0💬

How To Break a File Path Name into Parts
How To Break a File Path Name into Parts? - PHP Script Tips - Working with Directoris and Files If you have a file name, and want to get different parts of the file name, you can use the pathinfo() function. It breaks the file name into 3 parts: directory name, file base name and file extension; and... 2007-04-23, 5688👍, 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, 5687👍, 0💬

What Happens If a META Element Is Not Closed
What Happens If a META Element Is Not Closed? - XHTML 1.0 Tutorials - Document Structure and Head Level Tags Meta tags, link tags and base tags must be closed in XHTML documents. If you forget to close them like the HTML format, you will get validation errors. Try the following tutorial sample XHTML... 2007-05-12, 5685👍, 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, 5685👍, 0💬

What is a CLS
What is a CLS(Common Language Specification)? This is a subset of the CTS which all .NET languages are expected to support. It was always a dream of Microsoft to unite all different languages in to one umbrella and CLS is one step towards that. Microsoft has defined CLS which are nothing but guideli... 2007-10-22, 5684👍, 0💬

How To Write Date and Time Literals
How To Write Date and Time Literals? - MySQL FAQs - Introduction to SQL Date and Time Handling MySQL offers a number of formats for you to use to enter date and time literals: ANSI standard format: "YYYY-MM-DD HH:MM:SS". Non-standard limiters. Like: "YYYY/MM/DD HH^MM^SS" or "YYYY.MM.DD HH-MM-SS". No... 2007-05-11, 5684👍, 0💬

What Is a Result Set Object
What Is a Result Set Object? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts A result set object is a logical representation of data rows returned by mysql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in t... 2007-05-10, 5683👍, 0💬

How To Convert a Character to an ASCII Value
How To Convert a Character to an ASCII Value? - PHP Script Tips - PHP Built-in Functions for Strings If you want to convert characters to ASCII values, you can use the ord() function, which takes the first charcter of the specified string, and returns its ASCII value in decimal format. ord() complem... 2007-04-21, 5682👍, 0💬

Referring to the sample code above, which one of the following statements is correct?
class A { public: A() { if(x > 1) throw "x overflow"; else x++; } private: static int x; }; int A::x; Referring to the sample code above, which one of the following statements is correct? 1 The class can be instantiated without throwing an exception two times. 2 It cannot be determined how many time... 2012-05-07, 5681👍, 0💬

What Happens If the UPDATE Subquery Returns No Rows
What Happens If the UPDATE Subquery Returns No Rows? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you use a subquery to assign new values in the SET clause in an UPDATE statement, and the subquery returns no rows for an outer row, MySQL will provide a NULL value to the SE... 2007-05-11, 5681👍, 0💬

How To Write a Left Outer Join with the WHERE Clause
How To Write a Left Outer Join with the WHERE Clause? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you don't want to use the LEFT OUTER JOIN ... ON clause to write a left outer join, you can use a special criteria in the WHERE clause as "left_table.column = right_table.column(+)".... 2007-04-19, 5681👍, 0💬

How To Turn on Binary Logs
How To Turn on Binary Logs? - MySQL FAQs - Server Daemon mysqld Administration If you want MySQL to write binary logs to a file, you can use the "--log-bin=fileBaseName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option: >cd \mysql\bi... 2007-05-11, 5680👍, 0💬

How Many Types of Cursors Supported in PL/SQL
How Many Types of Cursors Supported in PL/SQL? - Oracle DBA FAQ - Working with Cursors in PL/SQL PL/SQL supports two types of cursors: The implicit cursor - A single default cursor that automatically connects to the last DML statement executed. Explicit cursors - User defined cursors with specific D... 2007-04-29, 5680👍, 0💬

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

What Is Consistency
What Is Consistency? Consistency : Assures users that the data they are changing or viewing is not changed until the are through with it. 2007-04-15, 5678👍, 0💬

Enabling notification for individual tables
Enabling notification for individual tables Once the necessary stored procedure and tables are created then we have to notify saying which table needs to be enabled for notifications. That can be achieved by two ways:- ã aspnet_regsql -et -E -d Northwind -t Products ã Exec spNet_SqlCacheRegisterT... 2007-10-23, 5677👍, 0💬

How To Import One Table Back from a Dump File
How To Import One Table Back from a Dump File? - Oracle DBA FAQ - Loading and Exporting Data If you only want to import one table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following tutorial exercise shows you how to import th... 2007-05-02, 5677👍, 0💬

What Is a UL Tag/Element
What Is a UL Tag/Element? - XHTML 1.0 Tutorials - Understanding Lists and List Items A "ul" element is block level element that can be used to define an un-ordered list, where items are displayed with leading bullets. Here are basic rules about "ul" elements: "ul" elements are block level elements. ... 2007-05-11, 5676👍, 0💬

How To View User Privileges
How To View User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges If a regular user wants to see his/her own granted privileges, he/she can use the "SHOW GRANTS" command. If the "root" user wants to see other user's granted privileges, he/she can use the "SHOW GRANTS FOR userN... 2007-05-10, 5676👍, 0💬

What Are the Restrictions on External Table Columns
What Are the Restrictions on External Table Columns? - Oracle DBA FAQ - Loading and Exporting Data When creating external table columns, you need to watch out some restrictions: "PRIMARY KEY" is not allowed. "NOT NULL" is not allowed. "DEFAULT value" is not allowed. 2007-04-30, 5676👍, 0💬

What are Daemon threads and how can a thread be created as
What are Daemon threads and how can a thread be created as Daemon? Daemon thread's run in background and stop automatically when nothing is running program. Example of a Daemon thread is "Garbage collector". Garbage collector runs until some .NET code is running or else its idle. You can make a thre... 2007-10-22, 5675👍, 0💬

<< < … 42 43 44 45 46 47 48 49 50 51 52 … > >>   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