<< < 85 86 87 88 89 90 91 92 93 94 95 > >>   Sort: Date

How To Drop an Index
How To Drop an Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you don't need an existing index any more, you should delete it with the DROP INDEX statement. Here is an example SQL script: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(8...
2007-05-02, 4913👍, 0💬

How Run SQL*Plus Commands That Are Stored in a Local File
How Run SQL*Plus Commands That Are Stored in a Local File? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you have a group of commands that you need to run them repeatedly every day, you can save those commands in a file (called SQL script file), and using the "@fileName" co...
2007-04-29, 4913👍, 0💬

How To Apply Filtering Criteria at Group Level
How To Apply Filtering Criteria at Group Level? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you want to return only specific groups from the query, you can apply filtering criteria at the group level by using the HAVING clause inside the GROUP BY clause. The following script give...
2007-04-20, 4913👍, 0💬

What are dimensions in OLAP
What are dimensions in OLAP ? Dimensions are the categories of data analysis. For example, in a revenue report by month by sales region, the two dimensions needed are time and sales region. Typical dimensions include product, time, and region.
2007-10-25, 4911👍, 0💬

XHTML Syntax
XHTML Syntax - XHTML 1.0 - Interview Questions What is the root element of an XHTML document? &lt;root&gt; &lt;xml&gt; &lt;html&gt; &lt;xhtml&gt; What is XHTML tag? What is XHTML element? What is XHTML attribute? How to close an XHTML element? What is an empty XHTML e...
2007-05-12, 4911👍, 0💬

What Is a MAP Tag/Element
What Is a MAP Tag/Element? - XHTML 1.0 Tutorials - Understanding Inline Images and Image Maps A "map" element is special inline element that you to define map entries to be used by image maps. Here are some basic rules on "map" elements: "map" elements are inline elements. "map" elements can not hav...
2007-05-12, 4910👍, 0💬

What Is an Oracle Tablespace
What Is an Oracle Tablespace? - Oracle DBA FAQ - Oracle Basic Concepts An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes. Each tablespace in an Oracle database consists of...
2007-04-16, 4910👍, 0💬

How To Rename an Existing Column in a Table
How To Rename an Existing Column in a Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you have an existing column in a table and you want to change the column name, you can use the "ALTER TABLE ... CHANGE" statement. This statement allows you to change the name of a colu...
2007-05-11, 4907👍, 0💬

What Are the Special Characters You Need to Escape in Single-Quoted Stings
What Are the Special Characters You Need to Escape in Single-Quoted Stings? - PHP Script Tips - Understanding String Literals and Operations There are two special characters you need to escape in a single-quote string: the single quote (') and the back slash (\). Here is a PHP script example of sing...
2007-04-20, 4907👍, 0💬

What Is the XHTML Element Content
What Is the XHTML Element Content? - XHTML Tutorials - Introduction To Element Content Syntax The content of an XHTML element is everything you entered between the opening tag and the closing tag of the element. Here are some good examples of XHTML element contents: &lt!-- An empty table cell --...
2007-05-12, 4906👍, 0💬

When working with shared data in threading how do you implement
When working with shared data in threading how do you implement synchronization ? There are certain situtations that you need to be careful with when using threads. If two threads (e.g. the main and any worker threads) try to access the same variable at the same time, you'll have a problem. This can...
2007-10-22, 4904👍, 0💬

What Is the Simplest Tool to Run Commands on Oracle Servers
What Is the Simplest Tool to Run Commands on Oracle Servers? - Oracle DBA FAQ - Loading and Exporting Data The simplest tool to connect to an Oracle server and run commands to manage data is SQL*Plus. It is an Oracle database client tool that works as a command-line user interface to the database se...
2007-04-30, 4904👍, 0💬

Is It More Secure to Use Cookies to Transfer Session IDs
Is It More Secure to Use Cookies to Transfer Session IDs? - PHP Script Tips - Understanding and Using Sessions Is it more secure to use cookies to transfer session IDs? The answer is yes, because attacking your Web site using URL parameters is much easier than using cookies. So if you are the system...
2007-04-17, 4904👍, 0💬

How To Shutdown MySQL Server
How To Shutdown MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows If you want to shutdown your MySQL server, you can run the "mysqladmin" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysqladmin shutdown
2007-05-10, 4901👍, 0💬

How To Create a Table Index
How To Create a Table Index? - Oracle DBA FAQ - Understanding SQL DDL Statements If you have a table with a lots of rows, and you know that one of the columns will be used often a search criteria, you can add an index for that column to in improve the search performance. To add an index, you can use...
2007-04-22, 4901👍, 0💬

How do you assign object properties?
How do you assign object properties? obj["age"] = 17 or obj.age = 17.
2008-10-28, 4900👍, 0💬

How To Look at the Current SQL*Plus System Settings
How To Look at the Current SQL*Plus System Settings? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want to see the current values of SQL*Plus system settings, you can use the SHOW command as shown in the following tutorial exercise: SQL> SHOW AUTOCOMMIT autocommit OFF S...
2007-04-29, 4900👍, 0💬

How To Start MySQL Server
How To Start MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows If you want to start the MySQL server, you can run the "mysqld" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysqld "mysqld" will run quietly without printing any message in you c...
2007-05-10, 4899👍, 0💬

How To Create a new Oracle Data File
How To Create a new Oracle Data File? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files There is no dedicated statement to create a data file. Data files are created as part of statements that manages other data structures, like tablespace and database.
2007-05-03, 4899👍, 0💬

What Is a Function
What Is a Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A function is a named program unit. It consists of three parts: Declaration Part - Defining the function name, calling parameters, return value type, local variables and local procedures. Declaration part is req...
2007-04-26, 4899👍, 0💬

How To Connect to the Server with User Account: SYS
How To Connect to the Server with User Account: SYS? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges SYS is a very special user account. It has been associated with the highest privilege call SYSDBA. Normally, you should not connect to the server with SYS. But if you want to ...
2007-05-02, 4897👍, 0💬

What Is Wrong with This HEAD Element
What Is Wrong with This HEAD Element? - XHTML 1.0 Tutorials - Document Structure and Head Level Tags If you have trouble passing the XHTML 1.0 validation on your head element, check the following common mistakes: Missing the title element. Not closing the meta element as &lt;meta ... &gt;. Y...
2007-05-12, 4896👍, 0💬

Applications That Can Nenefit from Using XML
Give a few examples of types of applications that can benefit from using XML. There are literally thousands of applications that can benefit from XML technologies. The point of this question is not to have the candidate rattle off a laundry list of projects that they have worked on, but, rather, to ...
2007-04-11, 4896👍, 0💬

What the way to stop a long running thread ?
.NET INTERVIEW QUESTIONS - What the way to stop a long running thread ? Thread.Abort() stops the thread execution at that moment itself.
2009-12-01, 4895👍, 0💬

<< < 85 86 87 88 89 90 91 92 93 94 95 > >>   Sort: Date