.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

<< < … 64 65 66 67 68 69 70 71 72 73 74 … > >>   Sort: Date

What Is the Quickest Way to Export a Table to a Flat File
What Is the Quickest Way to Export a Table to a Flat File? - Oracle DBA FAQ - Loading and Exporting Data The quickest way to export a table to a flat file is probably to use the SQL*Plus SPOOL command. It allows you to record SELECT query result to a text file on the operating system. The following ... 2007-04-30, 5126👍, 0💬

What To Do If the StartBD.bat Failed to Start the XE Instance
What To Do If the StartBD.bat Failed to Start the XE Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If StartBD.bat failed to start the XE instance, you need to try to start the instance with other approaches to get detail error messages on why the instance can not b... 2007-04-24, 5126👍, 0💬

How To Connect the Oracle Server as SYSDBA
How To Connect the Oracle Server as SYSDBA? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 4. The best way to connect to the Oracle server as an administrator is to use SQL*Plus. You need to run SQL*Plus with /nolog option and use the CONNECT with blank user name, blank pass... 2007-04-23, 5126👍, 0💬

Using XML Files with SGML Tools
If XML is just a subset of SGML, can I use XML files directly with existing SGML tools? Yes, provided you use up-to-date SGML software which knows about the WebSGML Adaptations TC to ISO 8879 (the features needed to support XML, such as the variant form for EMPTY elements; some aspects of the SGML D... 2007-04-11, 5126👍, 0💬

What Is Oracle SQL Developer
What Is Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Oracle SQL Developer is a new, free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and ... 2007-04-26, 5125👍, 0💬

What To Do If the Binary SPFile Is Wrong for the Default Instance
What To Do If the Binary SPFile Is Wrong for the Default Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Let's say the SPFile for the default instance is a binary file, and some settings are wrong in the SPFile, like SGA setting is bellow 20MB, how do you change a se... 2007-04-25, 5125👍, 0💬

How To Create an Oracle Database
How To Create an Oracle Database? - Oracle DBA FAQ - Creating New Database Instance Manually There are two ways to create a new database: Use the Database Configuration Assistant (DBCA) to create a database interactively. Use the CREATE DATABASE statement to create a database manually. 2007-04-22, 5125👍, 0💬

How To Get All the Values Out of an Array
How To Get All the Values Out of an Array? - PHP Script Tips - PHP Built-in Functions for Arrays Function array_values() returns a new array that contains all the keys of a given array. Here is a PHP script on how to use array_values(): &lt;?php $mixed = array(); $mixed["Zero"] = "PHP"; $mixed[1... 2007-04-21, 5125👍, 0💬

What Are the Length Units Used in CSS
What Are the Length Units Used in CSS? - CSS Tutorials - Page Layout and Background Image Design To control your page width and page layout, you must understand the length units used in CSS. Here is a list of main length units: cm - One centimeter, absolute unit. em - The height of the current text ... 2007-05-11, 5124👍, 0💬

What Privilege Is Needed for a User to Query Tables in Another Schema
What Privilege Is Needed for a User to Query Tables in Another Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to run queries (SELECT statements) on tables of someone else's schema, he/she needs the SELECT ANY TABLE privilege. The following tutorial exercis... 2007-05-01, 5124👍, 0💬

What Are Data Types Limitations
What Are Data Types Limitations? Max. columns in a table is 255. Max. Char size is 255, Long is 64K and Number is 38 digits. Cannot Query on a long column. Char, Varchar2 Max. size is 2000 and default is 1 byte. Number(p,s) p is precision range 1 to 38, s is scale -84 to 127. Long Character data of ... 2007-04-15, 5124👍, 0💬

What does the EnableViewStateMac setting in an aspx page do?
What does the EnableViewStateMac setting in an aspx page do? Setting EnableViewStateMac=true is a security measure that allows ASP.NET to ensure that the viewstate for a page has not been tampered with. If on Postback, the ASP.NET framework detects that there has been a change in the value of viewst... 2008-09-23, 5123👍, 0💬

what is a service class
what is a service class? 2007-11-04, 5123👍, 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, 5123👍, 0💬

How To Retrieve Data from an Cursor to a RECORD
How To Retrieve Data from an Cursor to a RECORD? - Oracle DBA FAQ - Working with Cursors in PL/SQL If you have a cursor opened ready to use, you can also use the FETCH statement to retrieve data from the cursor into a RECORD variable as shown in the tutorial exercise below: CREATE OR REPLACE PROCEDU... 2007-04-29, 5123👍, 0💬

What is LOCK escalation
What is LOCK escalation? Lock escalation is the process of converting of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, SQL Serve... 2007-10-25, 5122👍, 0💬

How can we call methods in remoting Asynchronously
How can we call methods in remoting Asynchronously All previous examples are a synchronous method calls that means client has to wait until the method completes the process. By using Delegates we can make Asynchronous method calls. 2007-10-23, 5122👍, 0💬

How To Convert Character Strings to Numeric Values
How To Convert Character Strings to Numeric Values? - MySQL FAQs - Introduction to SQL Basics You can convert character strings to numeric values by using the CAST(string AS DECIMAL) or CAST(string AS SIGNED INTEGER) function as shown in the following examples: SELECT CAST('4123.45700' AS DECIMAL) F... 2007-05-11, 5122👍, 0💬

What Is TIMESTAMP
What Is TIMESTAMP? - MySQL FAQs - Introduction to SQL Date and Time Handling A TIMESTAMP data type allows you to record a date and time like DATETIME data type. But it has some interesting features when used on a table column: The first TIMESTAMP column in a table will be assigned with the current d... 2007-05-11, 5122👍, 0💬

What is Tracing in ASP.NET
What is Tracing in ASP.NET ? Tracing allows us to view how the code was executed in detail. 2007-10-24, 5120👍, 0💬

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? You can use Having Clause with the GROUP BY function in a query and WHERE Clause is applied to each row before they are part of the GROUP BY function in a query. 2007-10-25, 5119👍, 0💬

How do I send email message from ASP.NET
How do I send email message from ASP.NET ? ASP.NET provides two namespaces System.WEB.mailmessage classand System.Web.Mail.Smtpmail class. Just a small homework create a Asp.NET project. 2007-10-24, 5119👍, 0💬

What Is a ID Selector
What Is a ID Selector? - CSS Tutorials - Introduction To CSS Basics A ID selector selects all HTML tags that matches the id name defined in the tag attribute of id="id_name". ID selectors are specified with a leading hash like (#id_name). For example, the following CSS definition uses an ID selector... 2007-05-11, 5119👍, 0💬

What is a Database Schema
What is a Database Schema? - Oracle DBA FAQ - Oracle Basic Concepts A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with S... 2007-04-21, 5119👍, 0💬

<< < … 64 65 66 67 68 69 70 71 72 73 74 … > >>   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