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

What Is "mysqlcheck"
What Is "mysqlcheck"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqlcheck" is a command-line interface for administrators to check and repair tables. Here are some sample commands supported by "mysqlcheck": "mysqlcheck databaseName tableName" - Checks the specified table in the ...
2007-05-11, 5679👍, 0💬

Can you explain the star schema for OLAP
What are fact tables and dimension tables in OLAP ? The dimensions and measures are physically represented by a star schema. Dimension tables revolve around fact table. A fact table contains a column for each measure as well as a column for each dimension. Each dimension column has a foreign-key rel...
2007-10-25, 5678👍, 0💬

How can we implement observer pattern in .NET
How can we implement observer pattern in .NET? Observer patterns can be implemented using “Delegates” and “Events”. I leave this to the readers to implement one sample code for observer patterns.
2007-10-24, 5677👍, 0💬

What is the use of attribute
What is the use of attribute ? This attribute works like a compatibility option. As mentioned before ASP worked in STA model and ASP.NET works in MTA model, but what if your ASP.NET application is using a VB COM component. In order that VB COM runs properly in ASP.NET threading model we have to set ...
2007-10-24, 5675👍, 0💬

How Many Scalar Data Types Are Supported in PL/SQL
How Many Scalar Data Types Are Supported in PL/SQL? - Oracle DBA FAQ - Understanding PL/SQL Language Basics PL/SQL supports many scalar data types divided into 4 groups: Numeric Types: BINARY_DOUBLE, BINARY_FLOAT, BINARY_INTEGER, DEC, DECIMAL, DOUBLE PRECISION, FLOAT, INT, INTEGER, NATURAL, NATURALN...
2007-04-30, 5675👍, 0💬

How To Load Data from External Tables to Regular Tables
How To Load Data from External Tables to Regular Tables? - Oracle DBA FAQ - Loading and Exporting Data Once you have your data entered in a text file, and an external table defined to this text file, you can easily load data from this text file to a regular table. The following tutorial exercise sho...
2007-05-01, 5674👍, 0💬

How To Call a Stored Function
How To Call a Stored Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A stored function can be called as part of expression in any PL/SQL statement. One simplest way to call a stored function is to a dummy SELECT statement as shown in the following tutorial script using...
2007-04-26, 5672👍, 0💬

Which class does the remote object has to inherit
Which class does the remote object has to inherit ? All remote objects should inherit from System.MarshalbyRefObject.
2007-10-23, 5671👍, 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, 5671👍, 0💬

How To Experiment Dead Locks
How To Experiment Dead Locks? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to have some experience with dead locks, you can create two windows running two mysql transactions in two sessions at the REPEATABLE READ transaction isolation level. Then run some UPDATE statements a...
2007-05-09, 5671👍, 0💬

How To Set Different Text Fonts Inside Tables
How To Set Different Text Fonts Inside Tables? - CSS Tutorials - Introduction To CSS Basics If want to set the text font inside tables different than outside tables, you can use CSS definitions with contextual selectors. In the CSS example below, Both selectors "TABLE P" and "P" match those &lt;...
2007-05-11, 5667👍, 0💬

What Is a Subquery
What Is a Subquery? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries A subquery is a SELECT statement used as part of the selection criteria of the main SELECT statement. The subquery specified in the WHERE clause will be evaluated repeated on each row of the selection base table. The o...
2007-05-11, 5667👍, 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, 5667👍, 0💬

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

What are resource files and how do we generate resource files
What are resource files and how do we generate resource files? Resource files are files which contain program resources. Many programmers think resource files for only storing strings. But you can also store bitmaps, icons, fonts, wav files in to resource files. In order to generate resource file yo...
2007-11-01, 5666👍, 0💬

What are the different types of elementary process in FPA
What are the different types of elementary process in FPA? There are two types of elementary process Dynamic Elementary process Static Elementary process Dynamic elementary process moves data from internal application boundary to external application boundary or vice-versa. Examples of dynamic eleme...
2007-10-30, 5666👍, 0💬

What Is View
What Is View? - MySQL FAQs - Database Basics and Terminologies A view is a logical table defined by a query statement.
2007-05-10, 5666👍, 0💬

How To Turn on mysql Extension on the PHP Engine
How To Turn on mysql Extension on the PHP Engine? - MySQL FAQs - PHP Connections and Query Execution The "mysql" API extension is provided as "php_mysql.dll" for Windows system. Your PHP binary download package should have "php_mysql.dll" included. No need for another download. But you need to check...
2007-05-10, 5665👍, 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, 5664👍, 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, 5664👍, 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, 5663👍, 0💬

What Is a RSS Aggregator
What Is a RSS Aggregator? - RSS FAQs - Adding Your Feeds to RSS News Readers and Aggregators A RSS aggregator, also called RSS reader, is software application that allows you to subscribe to many RSS feeds from various sources and read them in one place. A RSS aggregator usually provides a big list ...
2007-05-12, 5663👍, 0💬

How To Use "OUT" Parameter Properly
How To Use "OUT" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Here are the rules about OUT parameters: A formal OUT parameter acts like an un-initialized variable. It must be assigned with new values before the end of the procedure or function. An actual O...
2007-04-21, 5663👍, 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, 5662👍, 0💬

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