<< < 43 44 45 46 47 48 49 50 51 52 53 > >>   Sort: Date

What Is NULL
What Is NULL? - Oracle DBA FAQ - Understanding SQL Basics NULL is a special value representing "no value" in all data types. NULL can be used on in operations like other values. But most opertations has special rules when NULL is involved. The tutorial exercise below shows you some examples: SET NUL...
2007-04-23, 5320👍, 0💬

How To Set Different Text Fonts Inside Tables
How To Set Different Text Fonts Inside Tables? - CSS Tutorials - Introduction To CSS Basics If want to set the text font inside tables different than outside tables, you can use CSS definitions with contextual selectors. In the CSS example below, Both selectors "TABLE P" and "P" match those &lt;...
2007-05-11, 5319👍, 0💬

How To Create Your Own Reports in SQL Developer
How To Create Your Own Reports in SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Oracle SQL Developer also lets you create your own reports. See the following steps on how to do this: Click menu View. Selects Reports from the menu. Open Reports. Right-click on User Defined Re...
2007-04-27, 5319👍, 0💬

How To Write a Left Outer Join with the WHERE Clause
How To Write a Left Outer Join with the WHERE Clause? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you don't want to use the LEFT OUTER JOIN ... ON clause to write a left outer join, you can use a special criteria in the WHERE clause as "left_table.column = right_table.column(+)"....
2007-04-19, 5319👍, 0💬

How To Experiment Dead Locks
How To Experiment Dead Locks? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to have some experience with dead locks, you can create two windows running two mysql transactions in two sessions at the REPEATABLE READ transaction isolation level. Then run some UPDATE statements a...
2007-05-09, 5318👍, 0💬

How To Float an Image to the Right Side
How To Float an Image to the Right Side? - XHTML 1.0 Tutorials - Understanding Inline Images and Image Maps If you want to float an image to the right side of the paragraph instead of inline within a text line, you have to use the CSS property "float" to do this. The "float" property takes two value...
2007-05-12, 5317👍, 0💬

What Are Transaction Isolation Levels
What Are Transaction Isolation Levels? - MySQL FAQs - Transaction Management: Commit or Rollback There are 4 transaction isolation levels defined by SQL-1992 standard: READ UNCOMMITTED - The SELECT statements in one transaction will read uncommitted data changes from transactions of all connected se...
2007-05-09, 5315👍, 0💬

How To Include Comments in SQL Statements
How To Include Comments in SQL Statements? - MySQL FAQs - Introduction to SQL Basics If you want to include comments in a SQL statement, you can first enter "--", then enter your comment until the end of the line. The tutorial exercise below shows you some good examples: SELECT 'Hello world!' FROM D...
2007-05-11, 5314👍, 0💬

How To Update a Table Row with a Record
How To Update a Table Row with a Record? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a RECORD variable with data fields matching a table structure, you can update a row in this table with this RECORD variable using the UPDATE ... SET ROW statement as shown in the sample sc...
2007-04-26, 5314👍, 0💬

How To Create a Procedure Interactively
How To Create a Procedure Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you want to create a stored procedure interactively, you can use the following steps: Open you connection name, like Local_XE. Right-click Procedures. Select Create PROCEDURE. The Create Procedure win...
2007-04-28, 5313👍, 0💬

What are resource files and how do we generate resource files
What are resource files and how do we generate resource files? Resource files are files which contain program resources. Many programmers think resource files for only storing strings. But you can also store bitmaps, icons, fonts, wav files in to resource files. In order to generate resource file yo...
2007-11-01, 5311👍, 0💬

How To Delete a User Account
How To Delete a User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to delete a user account, you can connect to the server as "root" and use the "DROP USER ..." command to delete a user account. The tutorial exercise below shows you a good example: >cd \mysql\bin >...
2007-05-10, 5311👍, 0💬

What Are the Impacts on Applications from Locks, Timeouts, and DeadLocks
What Are the Impacts on Applications from Locks, Timeouts, and DeadLocks? - MySQL FAQs - Transaction Management: Commit or Rollback If you are using transactions with REPEATABLE READ isolation level and transaction safe storage engines in your applications, data locks, lock timeouts, and dead lock d...
2007-05-08, 5311👍, 0💬

Sharing an HttpSession between JSP and EJB
Is it possible to share an HttpSession between a JSP and EJB? What happens when I change a value in the HttpSession from inside an EJB? You can pass the HttpSession as parameter to an EJB method, only if all objects in session are serializable. This has to be consider as "passed-by-value", that mean...
2007-04-03, 5311👍, 0💬

Including Static Files
How do I include static files within a JSP page? Static resources should always be included using the JSP include directive. This way, the inclusion is performed just once during the translation phase. Do note that you should always supply a relative URL for the file attribute. Although you can also...
2007-04-03, 5311👍, 0💬

What Is a Persistent Cookie
What Is a Persistent Cookie? - PHP Script Tips - Understanding and Managing Cookies A persistent cookie is a cookie which is stored in a cookie file permanently on the browser's computer. By default, cookies are created as temporary cookies which stored only in the browser's memory. When the browser...
2007-04-25, 5309👍, 0💬

What is Modeling and why UML ?
What are advantages of using UML? As the name suggest UNIFIED MODELING LANGUAGE. Modelling has been around for years, not only in software field but also in other trades like civil, mechanical etc. Example in civil engineering drawing the main architecture built of diagram is a model by itself. Mode...
2007-10-26, 5308👍, 0💬

How to use a checkbox in a datagrid
How can I track event in checkbox which is one of the columns of a datagrid ? Note: - This is normally asked when the interviewer want to see that have you really worked practically on a project. Following are the steps to be done :- 1. In ASPX page you have to add Itemtemplate tag in datagrid. &...
2007-10-24, 5308👍, 0💬

What Is "mysqladmin"
What Is "mysqladmin"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqladmin" is a command-line interface for administrators to perform server administration tasks. It support a number of commonly used commands like: "mysqladmin shutdown" - Shuts down the server. "mysqladmin ping" ...
2007-05-11, 5308👍, 0💬

Handling Run-Time Exceptions
How does JSP handle run-time exceptions? You can use the errorPage attribute of the page directive to have uncaught runtime exceptions automatically forwarded to an error processing page. For example: redirects the browser to the JSP page error.jsp if an uncaught exception is encountered during requ...
2007-04-03, 5308👍, 0💬

How To Rebuild an Index
How To Rebuild an Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you want to rebuild an index, you can use the "ALTER INDEX ... REBUILD statement as shown in the following SQL script: SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'EMPLOYEES'; INDEX_NAME T...
2007-04-27, 5306👍, 0💬

What Is a Join
What Is a Join? Join is the form of SELECT command that combines info from two or more tables. Types of Joins are Simple (Equijoin and Non-Equijoin), Outer and Self join. Equijoin returns rows from two or more tables joined together based upon a equality condition in the WHERE clause. Non-Equijoin r...
2007-04-15, 5306👍, 0💬

How to get the contents of an input box using JavaScript?
How to get the contents of an input box using JavaScript? Use the "value" property of the input box object. For example: var myValue = window.document.getElementById ("MyTextBox").value;
2008-08-12, 5305👍, 0💬

Can you explain the star schema for OLAP
What are fact tables and dimension tables in OLAP ? The dimensions and measures are physically represented by a star schema. Dimension tables revolve around fact table. A fact table contains a column for each measure as well as a column for each dimension. Each dimension column has a foreign-key rel...
2007-10-25, 5305👍, 0💬

<< < 43 44 45 46 47 48 49 50 51 52 53 > >>   Sort: Date