.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

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

Can You Drop an Index Associated with a Unique or Primary Key Constraint
Can You Drop an Index Associated with a Unique or Primary Key Constraint? - Oracle DBA FAQ - Managing Oracle Table Indexes You can not delete the index associated with a unique or primary key constraint. If you try, you will get an error like this: ORA-02429: cannot drop index used for enforcement o... 2007-05-02, 5137👍, 0💬

What Privilege Is Needed for a User to Connect to Oracle Server
What Privilege Is Needed for a User to Connect to Oracle Server? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges Oracle deny connection to users who has no CREATE SESSION privilege. Try the following tutorial exercise, you will find out how Oracle denies connection: >.\bin\sq... 2007-05-02, 5137👍, 0💬

How To Generate a Character from an ASCII Value
How To Generate a Character from an ASCII Value? - PHP Script Tips - PHP Built-in Functions for Strings If you want to generate characters from ASCII values, you can use the chr() function. chr() takes the ASCII value in decimal format and returns the character represented by the ASCII value. chr() ... 2007-04-21, 5137👍, 0💬

What are different types of JIT
What are different types of JIT ? Note :- This question can only be asked when the interviewer does not know what he wants. It was asked to me in one of interview and for 15 minutes he was roaming around the same question in order to get answer from me (requirement was for a simple database project)... 2007-10-22, 5136👍, 0💬

What Are the Non-Standard SQL Commands Supported by "mysql"
What Are the Non-Standard SQL Commands Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql There are many non-standard SQL commands that are supported by "mysql". Here is short list of some commonly used commands: "SHOW infoName" - Shows basic information of based on the speci... 2007-05-10, 5136👍, 0💬

What Is the Icon for Atom Syndication
What Is the Icon for Atom Syndication? - RSS FAQs - Atom Feed Introduction and File Generation The Web browser and Website syndication industry has adopted a standard icon to identify syndicated content as shown below: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2007-05-12, 5135👍, 0💬

What Is "mysqld"
What Is "mysqld"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqld" is MySQL server daemon program which runs quietly in background on your computer system. Invoking "mysqld" will start the MySQL server on your system. Terminating "mysqld" will shutdown the MySQL server. Here is ... 2007-05-11, 5135👍, 0💬

Using XSL in Generating HTML Pages from Relational Databases
Describe the role that XSL can play when dynamically generating HTML pages from a relational database Even if candidates have never participated in a project involving this type of architecture, they should recognize it as one of the common uses of XML. Querying a database and then formatting the re... 2007-04-11, 5135👍, 0💬

What Are the "mysqld" Command Line Options
What Are the "mysqld" Command Line Options? - MySQL FAQs - Server Daemon mysqld Administration "mysqld" offers a big list of command line options. Here are some commonly used options: "--help" - Displays a short help message on how to use "mysqld". "--verbose --help" - Displays a long help messages ... 2007-05-11, 5134👍, 0💬

How To Show All Tables with "mysql"
How To Show All Tables with "mysql"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to see all the tables in a database, you run the non-SQL command "SHOW TABLES" at the "mysql" prompt. See the following tutorial exercise for example: >cd \mysql\bin >mysql -u root test Welc... 2007-05-11, 5134👍, 0💬

What Is Locking
What Is Locking? Locking are mechanisms intended to prevent destructive interaction between users accessing data. Locks are used to achieve. 2007-04-15, 5134👍, 0💬

Processing HTML Form Date
Can a JSP page process HTML FORM data? Yes. However, unlike servlets, you are not required to implement HTTP-protocol specific methods like doGet() or doPost() within your JSP page. You can obtain the data for the FORM input elements via the request implicit object within a scriptlet or expression a... 2007-04-03, 5134👍, 0💬

How To Write Numeric Literals
How To Write Numeric Literals? - Oracle DBA FAQ - Understanding SQL Basics Numeric literals can coded as shown in the following samples: SELECT 255 FROM DUAL -- An integer 255 SELECT -6.34 FROM DUAL -- A regular number -6.34 SELECT 2.14F FROM DUAL -- A single-precision floating point 2.14 SELECT -0.... 2007-04-24, 5133👍, 0💬

When to Use SELECT INTO Statements
When to Use SELECT INTO Statements? The SELECT INTO Statement is most often used to create backup copies of tables or for archiving records. SELECT column_name(s) INTO newtable [IN externaldatabase] FROM source SELECT column_name(s) INTO newtable [IN externaldatabase] FROM source WHERE column_name o... 2007-04-15, 5133👍, 0💬

How to determine the state of a checkbox using JavaScript?
How to determine the state of a checkbox using JavaScript? Use the "checked" property of the checkbox object. For example: var checkedP = window.document.getElementById ("myCheckBox").checked; 2008-08-19, 5132👍, 0💬

What Happens If File Name is Missing in a URL
What Happens If File Name is Missing in a URL? - XHTML 1.0 Tutorials - Understanding Hyper Links and URLs If the file name part is missing in a URL, the one of the following two rules will be used. 1. If a URL has no file name, but a path name is given, the browser will let the hosting computer to s... 2007-05-12, 5132👍, 0💬

What Are DDL Statements
What are the most important DDL statements in SQL? CREATE TABLE - creates a new database table ALTER TABLE - alters (changes) a database table DROP TABLE - deletes a database table CREATE INDEX - creates an index (search key) DROP INDEX - deletes an index 2007-04-15, 5131👍, 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, 5130👍, 0💬

How To Use "mysql" to Run SQL Statements
How To Use "mysql" to Run SQL Statements? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to run SQL statement to your server with "mysql", you need to start "mysql" and enter your SQL statement at the "mysql" prompt. Here is a good tutorial exercise that shows you how to ru... 2007-05-11, 5130👍, 0💬

How To Uploaded Files to a Table
How To Uploaded Files to a Table? - PHP Script Tips - Uploading Files to Web Servers To store uploaded files to MySQL database, you can use the normal SELECT statement as shown in the modified processing_uploaded_files.php listed below: &lt;?php $con = mysql_connect("localhost", "", ""); mysql_s... 2007-04-19, 5130👍, 0💬

How To Connect to MySQL Server on a Different Port
How To Connect to MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration If your MySQL server is listening on port number different than 3306, you need to specify "--port=portNumber" option to any client program that needs to connect to the server. The tutorial exercise... 2007-05-11, 5129👍, 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, 5129👍, 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, 5129👍, 0💬

How To Extract a Unit Value from a Date and Time
How To Extract a Unit Value from a Date and Time? - MySQL FAQs - Introduction to SQL Date and Time Handling If you want to extract a specific date or time unit value out of a date or a time, you can use the EXTRACT(unit FROM expression) function. The tutorial exercise below gives you some good examp... 2007-05-11, 5128👍, 0💬

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