<< < 159 160 161 162 163 164 165 166 167 168 169 > >>   Sort: Rank

What Are Character Functions
What Are Character Functions? Character Functions are INITCAP, UPPER, LOWER, SUBSTR and LENGTH. Additional functions are GREATEST and LEAST.
2007-04-15, 4733👍, 0💬

What Are Date Functions
What Are Date Functions? Date Functions are ADD_MONTHS, LAST_DAY, NEXT_DAY, MONTHS_BETWEEN and SYSDATE.
2007-04-15, 4782👍, 0💬

What Is NVL
What Is NVL? NVL is a function lets you substitute a value when a null value is encountered.
2007-04-15, 4674👍, 0💬

What Is SQL*Plus
What Is SQL*Plus? SQL*Plus is an Oracle command line utility used for executing SQL and PL/SQL commands. The GUI version is called SQL Worksheet.
2007-04-15, 4793👍, 0💬

What Is SQL
What Is SQL? Structured Query Language (SQL) is the most popular computer language used to create, retrieve, update and delete data from relational database management systems. SQL has been standardized by both ANSI and ISO.
2007-04-15, 4808👍, 0💬

How To Return a Reference from a Function
How To Return a Reference from a Function? - PHP Script Tips - Creating Your Own Functions To return a reference from a function, you need to: Add the reference operator "&" when defining the function. Add the reference operator "&" when invoking the function. Here is a PHP script on how to ...
2007-04-14, 4697👍, 0💬

What Is session_register()
What Is session_register()? - PHP Script Tips - Understanding and Using Sessions session_register() is old function that registers global variables into the current session. You should stop using session_register() and use array $_SESSION to save values into the current session now.
2007-04-14, 5278👍, 0💬

How To Loop through an Array without Using "foreach"
How To Loop through an Array without Using "foreach"? - PHP Script Tips - PHP Built-in Functions for Arrays PHP offers the following functions to allow you loop through an array without using the "foreach" statement: reset($array) - Moves the array internal pointer to the first value of the array an...
2007-04-14, 4796👍, 0💬

What Types of Data Can Be Used as Array Keys
What Types of Data Can Be Used as Array Keys? - PHP Script Tips - Understanding PHP Arrays and Their Basic Operations Two types of data can be used as array keys: string and integer. When a string is used as a key and the string represent an integer, PHP will convert the string into a integer and us...
2007-04-14, 4627👍, 0💬

How To Get the ID Column Auto-Incremented
How To Get the ID Column Auto-Incremented? - PHP Script Tips - Working with MySQL Database Many tables require an ID column to assign a unique ID number for each row in the table. For example, if you have a table to hold forum member profiles, you need an ID number to identify each member. To allow ...
2007-04-14, 5110👍, 0💬

How To Delete an Existing Rows in a Table
How To Delete an Existing Rows in a Table? - PHP Script Tips - Working with MySQL Database If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row: &lt;?php include "mysql_connection.php"; $sq...
2007-04-14, 4709👍, 0💬

Using XML with Non-Latin Characters
Can XML use non-Latin charac'ters? Yes. The XML Specification explicitly says XML uses ISO 10646, the international standard character repertoire which covers most known languages. Unicode is an identical repertoire, and the two standards track each other. The spec says (2.2): All XML processors mus...
2007-04-11, 4928👍, 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, 4766👍, 0💬

Is there an XML version of HTML
Is there an XML version of HTML? Yes. The W3C recommends using XHTML which is a reformulation of HTML 4 in XML 1.0. This specification defines HTML as an XML application, and provides three DTDs corresponding to the ones defined by HTML 4.* (Strict, Transitional, and Frameset). The semantics of the ...
2007-04-11, 4726👍, 0💬

How can I make my existing HTML files work in XML
How can I make my existing HTML files work in XML? Either convert them to conform to some new document type (with or without a DTD or Schema) and write a stylesheet to go with them; or edit them to conform to XHTML. It is necessary to convert existing HTML files because XML does not permit end-tag m...
2007-04-11, 4762👍, 0💬

Which parts of an XML document are case-sensitive
Which parts of an XML document are case-sensitive? All of it, both markup and text. This is significantly different from HTML and most other SGML applications. It was done to allow markup in non-Latin-alphabet languages, and to obviate problems with case-folding in writing systems which are caseless...
2007-04-11, 4628👍, 0💬

How does XML handle white-space in my documents
How does XML handle white-space in my documents? All white-space, including linebreaks, TAB characters, and normal spaces, even between structural elements where no text can ever appear, is passed by the parser unchanged to the application (browser, formatter, viewer, converter, etc), identifying th...
2007-04-11, 4780👍, 0💬

What does an XML document actually look like
What does an XML document actually look like? The basic structure of XML is similar to other applications of SGML, including HTML. The basic components can be seen in the following examples. An XML document starts with a Prolog of the required the XML declaration &lt;?xml version="1.0" encoding=...
2007-04-11, 5331👍, 0💬

Do I have to know HTML or SGML before I learn XML
Do I have to know HTML or SGML before I learn XML? No. Although it's useful because a lot of XML terminology and practice derives from two decades' experience of SGML. Be aware that "knowing HTML" is not the same as "understanding SGML". Although HTML was written as an SGML application, browsers ign...
2007-04-11, 4824👍, 0💬

Does XML Replace HTML
Does XML replace HTML? No. XML itself does not replace HTML. Instead, it provides an alternative which allows you to define your own set of markup elements. HTML is expected to remain in common use for some time to come, and the current version of HTML is in XML syntax. XML is designed to make the w...
2007-04-11, 5017👍, 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, 4820👍, 0💬

Building Search Engines for Large Volumes of XML Data
How would you build a search engine for large volumes of XML data? The way candidates answer this question may provide insight into their view of XML data. For those who view XML primarily as a way to denote structure for text files, a common answer is to build a full-text search and handle the data...
2007-04-11, 4768👍, 0💬

Creating External References in DTD
When constructing an XML DTD, how do you create an external entity reference in an attribute value? Every interview session should have at least one trick question. Although possible when using SGML, XML DTDs don't support defining external entity references in attribute values. It's more important ...
2007-04-11, 4813👍, 0💬

Extract a specific attribute from an element using XSLT
Using XSLT, how would you extract a specific attribute from an element in an XML document? Successful candidates should recognize this as one of the most basic applications of XSLT. If they are not able to construct a reply similar to the example below, they should at least be able to identify the c...
2007-04-11, 4872👍, 0💬

<< < 159 160 161 162 163 164 165 166 167 168 169 > >>   Sort: Rank