<< < 76 77 78 79 80 81 82 83 84 85 86 > >>   Sort: Date

How To Establish Administrator Authentication to the Server
How To Establish Administrator Authentication to the Server? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 2. There are two ways to establish administrator authentication to a new database. Use a password file. Use operating system (OS) authentication. Using OS authenticati...
2007-04-22, 5015👍, 0💬

How To Convert Characters to Dates
How To Convert Characters to Dates? - Oracle DBA FAQ - Understanding SQL Basics You can convert dates to characters using the TO_DATE() function as shown in the following examples: SELECT TO_DATE('07-MAY-2006', 'DD-MON-YYYY') FROM DUAL; 07-MAY-06 SELECT TO_DATE('2006/05/07 ', 'YYYY/MM/DD') FROM DUAL...
2007-04-23, 5014👍, 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, 5014👍, 0💬

What Are String Data Types
What Are String Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL supports the following string data types: CHAR(n) same as CHARACTER(n) - Fixed width and " " padded characters strings. Default character set is ASCII. NCHAR(n) same as NATIONAL CHARACTER(n) - Fixed width and " " padded char...
2007-05-11, 5013👍, 0💬

What Is the Command Line End User Interface - mysql
What Is the Command Line End User Interface - mysql? - MySQL FAQs - Command-Line End User Interface mysql "mysql", official name is "MySQL monitor", is a command-line interface for end users to manage user data objects. "mysql" has the following main features: "mysql" is command line interface. It i...
2007-05-10, 5013👍, 0💬

How Many SQL DDL Commands Are Supported by "mysql"
How Many SQL DDL Commands Are Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql There are 4 SQL Data Definition Language (DDL) commands that are supported by "mysql". They are listed below with short descriptions: "CREATE dataObjectType dataObjectName" - Creates new database...
2007-05-08, 5013👍, 0💬

What's Wrong with "while ($c=fgetc($f)) {}"
What's Wrong with "while ($c=fgetc($f)) {}"? - PHP Script Tips - Reading and Writing Files If you are using "while ($c=fgetc($f)) {}" to loop through each character in a file, the loop may end in the middle of the file when there is a "0" character, because PHP treats "0" as Boolean false. To proper...
2007-04-22, 5013👍, 0💬

How To Retrieve the Session ID of the Current Session
How To Retrieve the Session ID of the Current Session? - PHP Script Tips - Understanding and Using Sessions Normally, you don't need to know the session ID of the current session. But if you are interested to know the session ID created by the PHP engine, there are two ways to get it: Calling sessio...
2007-04-18, 5013👍, 0💬

How To Create a Testing Table
How To Create a Testing Table? - Oracle DBA FAQ - Understanding SQL DML Statements If you want to practice DML statements, you should create a testing table as shown in the script below: CREATE TABLE fyi_links (id NUMBER(4) PRIMARY KEY, url VARCHAR2(80) NOT NULL, notes VARCHAR2(1024), counts NUMBER,...
2007-04-22, 5012👍, 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, 5012👍, 0💬

Who Is Responsible for XML
Who is responsible for XML? XML is a project of the World Wide Web Consortium (W3C), and the development of the specification is supervised by an XML Working Group. A Special Interest Group of co-opted contributors and experts from various fields contributed comments and reviews by email. XML is a p...
2007-04-11, 5012👍, 0💬

How To Filter Out Duplications in the Returning Rows
How To Filter Out Duplications in the Returning Rows? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If there are duplications in the returning rows, and you want to remove the duplications, you can use the keyword DISTINCT in the SELECT clause. The DISTINCT applies to the combination of a...
2007-05-11, 5011👍, 0💬

How To Create a New Table
How To Create a New Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you want to create a new table, you can use the "CREATE TABLE" statement. The following tutorial script shows you how to create a table called "tip": mysql> CREATE TABLE tip (id INTEGER PRIMARY KEY, subj...
2007-05-11, 5010👍, 0💬

What Is a Procedure
What Is a Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required. Execution...
2007-04-26, 5010👍, 0💬

How To Define an Anonymous Procedure with Variables
How To Define an Anonymous Procedure with Variables? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Anonymous procedure is a procedure without any name. If you have some variables to declare, you can define an anonymous procedure by using the DECLARE keyword in SQL*Plus as show...
2007-04-26, 5010👍, 0💬

How To Convert Numbers to Characters
How To Convert Numbers to Characters? - Oracle DBA FAQ - Understanding SQL Basics You can convert numeric values to characters by using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(4123.4570) FROM DUAL 123.457 SELECT TO_CHAR(4123.457, '$9,999,999.99') FROM DUAL $4,123.46...
2007-04-23, 5010👍, 0💬

What Web sites do you feel use JavaScript most effectively
What Web sites do you feel use JavaScript most effectively (i.e., best-in-class examples)? The worst? The best sites are the ones that use JavaScript so transparently, that I'm not aware that there is any scripting on the page. The worst sites are those that try to impress me with how much scripting...
2008-09-09, 5009👍, 0💬

What is ViewState
What is ViewState ? Viewstate is a built-in structure for automatically retaining values amongst the multiple requests for the same page. The viewstate is internally maintained as a hidden field on the page but is hashed, providing greater security than developer-implemented hidden fields do.
2007-10-23, 5009👍, 0💬

What is a Smallest Valid XHTML Dodument
What is a Smallest Valid XHTML Dodument? - XHTML 1.0 Tutorials - Document Structure and Head Level Tags If you are interested to see the smallest, but valid, XHTML document, check this one: &lt;?xml version="1.0" ?&gt; &lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://w...
2007-05-12, 5009👍, 0💬

Are Atom Feed Files XML Documents
Are Atom Feed Files XML Documents? - RSS FAQs - Atom Feed File Structure and Elements Yes. Atom feed files are XML (eXtensible Markup Language) documents. Atom feed files must be well-formed XML documents, respecting the following XML rules. The first line must be the "xml" processing instruction wi...
2007-05-12, 5009👍, 0💬

How To Invoke the Original Export Import Utilities
How To Invoke the Original Export Import Utilities? - Oracle DBA FAQ - Loading and Exporting Data If you really want to run the original export import utilities, you can still go to "bin" directory of the Oracle server path and run the "exp" or "imp" command. The tutorial exercise below tells you ho...
2007-05-02, 5009👍, 0💬

What is concept of Boxing and Unboxing
What is concept of Boxing and Unboxing ? Boxing permits any value type to be implicitly converted to type object or to any interface type implemented by value type. Boxing is a process in which object instances are created and copy values in to that instance. Unboxing is vice versa of boxing operati...
2007-10-22, 5008👍, 0💬

How Remove Data Files befor opening a Database
How Remove Data Files befor opening a Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files Let's say you have a corrupted data file or lost a data file. Oracle can mount the database. But it will not open the database. What you can do is to set the bad data file as offline befor o...
2007-05-02, 5008👍, 0💬

What Are the XHTML Elements Defined with Mixed Contents
What Are the XHTML Elements Defined with Mixed Contents? - XHTML Tutorials - Introduction To Element Content Syntax The following XHTML elements are defined to use the mixed content model: &lt;p&gt; - Element to insert a paragraph. &lt;pre&gt; - Element to insert a pre-formatted text...
2007-05-12, 5007👍, 0💬

<< < 76 77 78 79 80 81 82 83 84 85 86 > >>   Sort: Date