.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

<< < … 48 49 50 51 52 53 54 55 56 57 58 … > >>   Sort: Date

What Happens If the UPDATE Subquery Returns Multiple Rows
What Happens If the UPDATE Subquery Returns Multiple Rows? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If a subquery is used in a UPDATE statement, it must return exactly one row for each row in the update table that matches the WHERE clause. If it returns multiple rows, My... 2007-05-11, 5388👍, 0💬

How To Access MySQL Servers through Firewalls
How To Access MySQL Servers through Firewalls? - MySQL FAQs - PHP Connections and Query Execution If your MySQL server is provided by an Internet service company, connecting to the server from your local machine will not be so easy, because there are firewalls between your local machine and your MyS... 2007-05-10, 5388👍, 0💬

How To Get a List of All Background Sessions in the Database
How To Get a List of All Background Sessions in the Database? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you don't like to use a SELECT statement to get a list of all background sessions in the current database, you can use the Reports view to do this as shown in the following tutori... 2007-04-27, 5388👍, 0💬

How To Test the Session Garbage Collection Process
How To Test the Session Garbage Collection Process? - PHP Script Tips - Understanding and Using Sessions In order to test the session garbage collection process, you need to change the settings to expire session variables in 10 seconds and run the process on every request: session.gc_probability = 1... 2007-04-18, 5388👍, 0💬

What Are the General Rules on Data Consistency
What Are the General Rules on Data Consistency? - Oracle DBA FAQ - Understanding SQL Transaction Management All SQL statements always work with a snapshot of the database to provide data consistency. For READ WRITE transactions, the snapshot is taken when each statement starts. For READ ONLY transac... 2007-04-17, 5387👍, 0💬

How To Create a New View
How To Create a New View? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements You can create a new view based on one or more existing tables by using the "CREATE VIEW viewName AS selectStatement" statement as shown in the following script: mysql> CREATE TABLE comment (faqID INTEGER, m... 2007-05-11, 5386👍, 0💬

What Is the Best Way to Test the strpos() Return Value
What Is the Best Way to Test the strpos() Return Value? - PHP Script Tips - PHP Built-in Functions for Strings Because strpos() could two types of values, Integer and Boolean, you need to be careful about testing the return value. The best way is to use the "Identical(===)" operator. Do not use the ... 2007-04-21, 5386👍, 0💬

How To Move Uploaded Files To Permanent Directory
How To Move Uploaded Files To Permanent Directory? - PHP Script Tips - Uploading Files to Web Servers PHP stores uploaded files in a temporary directory with temporary file names. You must move uploaded files to a permanent directory, if you want to keep them permanently. PHP offers the move_uploade... 2007-04-19, 5386👍, 0💬

Two of your resources have conflicts between them how would you sort it out
You have people in your team who do not meet there deadlines or do not perform what are the actions you will take ? In such kind of question they want to see your delegation skills. The best answer to this question is a job of a project manager is managing projects and not problems of people, so I w... 2007-10-30, 5384👍, 0💬

What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema
What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to delete rows from tables of someone else's schema, he/she needs the DELETE ANY TABLE privilege. The following tutorial exercise gives... 2007-05-01, 5382👍, 0💬

How To Assign Values to Data Fields in RECORD Variables
How To Assign Values to Data Fields in RECORD Variables? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If a variable is a RECORD variable, you can assign values to its data fields by using fields names prefixed with variable name as "variable.field_name". Here is a sample script assigni... 2007-04-27, 5381👍, 0💬

Can the Query Output Be Sorted by Multiple Columns
Can the Query Output Be Sorted by Multiple Columns? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns employees' salaries sorted by department and salary value: SQL> SELEC... 2007-04-20, 5381👍, 0💬

What Is Oracle
What Is Oracle? - Oracle DBA FAQ - Oracle Basic Concepts Oracle is a company. Oracle is also a database server, which manages data in a very structured way. It allows users to store and retrieve related data in a multiuser environment so that many users can concurrently access the same data. All thi... 2007-04-21, 5380👍, 0💬

Why Do You Use JUnit to Test Your Code?
Why Do You Use JUnit to Test Your Code? This is a commonly asked question in a job interview. Your answer should have these points: I believe that writing more tests will make me more productive, not less productive. I believe that tests should be done as soon as possible at the code unit level. I b... 2008-01-03, 5379👍, 0💬

How To List All Tables in Your Schema
How To List All Tables in Your Schema? - Oracle DBA FAQ - Managing Oracle Database Tables If you log in with your Oracle account, and you want to get a list of all tables in your schema, you can get it through the USER_TABLES view with a SELECT statement, as shown in the following SQL script: SQL> c... 2007-05-04, 5379👍, 0💬

How To Rename a Column in an Existing Table
How To Rename a Column in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables Let's say you have an existing with an existing column, but you don't like the name of that column, can you rename that column name? The answer is yes. You can use the ALTER TABLE ... RENAME COLUMN statem... 2007-05-03, 5379👍, 0💬

What is ManualResetEvent and AutoResetEvent
What is ManualResetEvent and AutoResetEvent ? Threads that call one of the wait methods of a synchronization event must wait until another thread signals the event by calling the Set method. There are two synchronization event classes. Threads set the status of ManualResetEvent instances to signaled... 2007-10-22, 5378👍, 0💬

How To Create a Table Interactively
How To Create a Table Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you don't want to use SQL statements to create a new table, you use SQL Developer to create one interactively. Follow the steps below to create a new table called: TIP Right-click on the Tables in the obj... 2007-04-27, 5378👍, 0💬

What Is SGML
What is SGML? SGML is the Standard Generalized Markup Language (ISO 8879:1986), the international standard for defining descriptions of the structure of different types of electronic document. There is an SGML FAQ from David Megginson at http://math.albany.edu:8800/hm /sgml/cts-faq.htmlFAQ;and Robin... 2007-04-11, 5378👍, 0💬

Inner Class Declared inside a Method
Can an inner class declared inside of a method access local variables of this method? It's possible if these variables are final. 2007-03-03, 5378👍, 0💬

How To Execute a Stored Procedure
How To Execute a Stored Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions If you want to execute a stored procedure, you can use the EXECUTE statement. The example script below shows how to executes a stored procedure: SQL> set serveroutput on; SQL> CREATE PROCEDURE Gre... 2007-04-26, 5377👍, 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, 5377👍, 0💬

What Happens If Variable Names Collide with Table/Column Names
What Happens If Variable Names Collide with Table/Column Names? - Oracle DBA FAQ - Working with Database Objects in PL/SQL When a variable name collides with a column name, PL/SQL will use it as the variable if it is used where variable is allowed; It will be used as the column, if it is used where ... 2007-04-28, 5376👍, 0💬

What Is Rollback
What Is Rollback? Rollback causes work in the current transaction to be undone. 2007-04-15, 5376👍, 0💬

<< < … 48 49 50 51 52 53 54 55 56 57 58 … > >>   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