.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

<< < … 66 67 68 69 70 71 72 73 74 75 76 … > >>   Sort: Date

What Happens to the Data Files If a Tablespace Is Dropped
What Happens to the Data Files If a Tablespace Is Dropped? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If a tablespace is dropped, what happens to its data files? By default, data files will remain in OS file system, even if the tablespace they are mapped is dropped. Of course, you... 2007-05-03, 5280👍, 0💬

Is Oracel SQL Developer written in Java
Is Oracel SQL Developer written in Java? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Oracel SQL Developer is written in Java. It requires JDK 1.5, which is already included in your download file. 2007-04-26, 5280👍, 0💬

What are the different types of joins? What is the difference between them
What are the different types of joins? What is the difference between them ? INNER JOIN Inner join shows matches only when they exist in both tables.Example, in the below SQL there are two tables Customers and Orders and the inner join in made on Customers Customerid and Orders Customerid.So this SQ... 2007-10-25, 5279👍, 0💬

What Is a Transaction
What Is a Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server introduces the transaction concept to allow users to group one or more SQL statements into a single transac... 2007-05-11, 5279👍, 0💬

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, 5279👍, 0💬

How To Download Oracle Database 10g XE
How To Download Oracle Database 10g XE? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If you want to download a copy of Oracle Database 10g Express Edition, visit http://www.oracle.com/technolo gy/software/products/database/ xe/.If you are using Windows systems, there are dow... 2007-04-23, 5279👍, 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, 5278👍, 0💬

How To Generate a Feed link Element
How To Generate a Feed link Element? - RSS FAQs - Atom Feed File Structure and Elements The &lt;link&gt; element is not a required sub-element of the &lt;feed&gt; element. But it is strongly recommended that you provide a link element with rel="self" for each of your feed documents. ... 2007-05-12, 5278👍, 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, 5277👍, 0💬

How To Write a Query with an Inner Join
How To Write a Query with an Inner Join? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you want to query from two tables with an inner join, you can use the INNER JOIN ... ON clause in the FROM clause. The following query returns output with an inner join from two tables: employees... 2007-04-19, 5277👍, 0💬

How do you upload a file in ASP.NET
How do you upload a file in ASP.NET ? use System.Web.HttpPostedFile class. 2007-10-24, 5276👍, 0💬

How To Create a Table Index
How To Create a Table Index? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you have a table with a lots of rows, and you know that one of the columns will be used often as a search criteria, you can add an index for that column to improve the search performance. To add an ind... 2007-05-11, 5276👍, 0💬

How To Use FETCH Statement in a Loop
How To Use FETCH Statement in a Loop? - 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 in a loop to retrieve data from the cursor more efficiently. But you need to remember to use an EXIT statement break the loop when th... 2007-04-29, 5276👍, 0💬

How To Define a Data Field as NOT NULL
How To Define a Data Field as NOT NULL? - Oracle DBA FAQ - Working with Database Objects in PL/SQL When defining a specific RECORD type, you can define a data field as NOT NULL to make sure variables with this RECORD type to always have values in this field. A field defined as NOT NULL must have a d... 2007-04-27, 5276👍, 0💬

Vector Class
What is the Vector class? The Vector class provides the capability to implement a growable array of objects 2007-03-03, 5276👍, 0💬

What Are User Privileges
What Are User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges MySQL offers many user privileges to control user accesses to different funtions and data objects. Here are some commonly used privileges: ALL - All privileges. CREATE - Allows the user to use CREATE TABLE commands... 2007-05-10, 5275👍, 0💬

How To Write a String to a File without a File Handle
How To Write a String to a File without a File Handle? - PHP Script Tips - Reading and Writing Files If you have a string, want to write it to a file, and you don't want to open the file with a file handle, you can use the file_put_contents(). It opens the specified file, writes the specified string... 2007-04-23, 5275👍, 0💬

How To Quote Text Values in SQL Statements
How To Quote Text Values in SQL Statements? - PHP Script Tips - Working with MySQL Database Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes (''). In SQL language syntax... 2007-04-19, 5275👍, 0💬

What Is the Implicit Cursor
What Is the Implicit Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL There is only one implicitly cursor in a session. The implicit cursor is the cursor automatically defined by PL/SQL for you. Whenever a SQL statement is executed, this cursor will be assigned to represent the execution of... 2007-04-29, 5274👍, 0💬

How To Create a Table To Store Files
How To Create a Table To Store Files? - PHP Script Tips - Uploading Files to Web Servers If you using MySQL database and want to store files in database, you need to create BLOB columns, which can holds up to 65,535 characters. Here is a sample script that creates a table with a BLOB column to be us... 2007-04-19, 5274👍, 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, 5274👍, 0💬

What are the ways in which client can create object on server in CAO model ?
.NET INTERVIEW QUESTIONS - What are the ways in which client can create object on server in CAO model ? There are two ways by which you can create Client objects on remoting server :- * Activator.CreateInstance(). * By Keyword “New”. 2009-08-18, 5273👍, 0💬

What Is SQL
What Is SQL? - Oracle DBA FAQ - Understanding SQL Basics SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation. 2007-04-24, 5272👍, 0💬

How To Install MySQL
How To Install MySQL? - MySQL FAQs - Downloading and Installing MySQL on Windows MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local computer very easily. Here is how you can do this: Go to http://dev.my... 2007-05-10, 5271👍, 0💬

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