<< < 46 47 48 49 50 51 52 53 54 55 56 > >>   Sort: Date

How To Use "OUT" Parameter Properly
How To Use "OUT" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Here are the rules about OUT parameters: A formal OUT parameter acts like an un-initialized variable. It must be assigned with new values before the end of the procedure or function. An actual O...
2007-04-21, 5344👍, 0💬

Are Java and JavaScript the Same?
Are Java and JavaScript the Same? No. java and JavaScript are two different languages. Java is a powerful object - oriented programming language like C++ and C, whereas Javascript is a client-side scripting language.
2008-07-17, 5343👍, 0💬

What Are the System Predefined User Roles
What Are the System Predefined User Roles? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges Oracle 10g XE comes with 3 predefined roles: CONNECT - Enables a user to connect to the database. Grant this role to any user or application that needs database access. RESOURCE - Enabl...
2007-05-02, 5342👍, 0💬

How To Run SQL Statements with Oracle SQL Developer
How To Run SQL Statements with Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Once a connection is established with an Oracle server, you can enter any SQL statements in the SQL Statement area. Try yourself with the following steps: Go to the SQL Statement area Enter S...
2007-04-27, 5342👍, 0💬

Using XML with Non-Latin Characters
Can XML use non-Latin charac'ters? Yes. The XML Specification explicitly says XML uses ISO 10646, the international standard character repertoire which covers most known languages. Unicode is an identical repertoire, and the two standards track each other. The spec says (2.2): All XML processors mus...
2007-04-11, 5342👍, 0💬

How To Turn on mysql Extension on the PHP Engine
How To Turn on mysql Extension on the PHP Engine? - MySQL FAQs - PHP Connections and Query Execution The "mysql" API extension is provided as "php_mysql.dll" for Windows system. Your PHP binary download package should have "php_mysql.dll" included. No need for another download. But you need to check...
2007-05-10, 5341👍, 0💬

How To Convert Times to Characters
How To Convert Times to Characters? - Oracle DBA FAQ - Understanding SQL Basics You can convert dates to characters using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(SYSDATE, 'HH:MI:SS') FROM DUAL; 04:49:49 SELECT TO_CHAR(SYSDATE, 'HH24:MI:SS.FF') FROM DUAL; -- Error: S...
2007-04-23, 5339👍, 0💬

What is denormalization
What is denormalization ? Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance.The sacrifice to performance is that you increase redundancy in database.
2007-10-25, 5337👍, 0💬

How To Generate a Feed updated Element
How To Generate a Feed updated Element? - RSS FAQs - Atom Feed File Structure and Elements The &lt;update&gt; element is a required sub-element of the &lt;feed&gt; element. The Atom specification requires that you provide a data and a time of when this feed was updated. There is no p...
2007-05-12, 5337👍, 0💬

Can you compare ASP.NET sessions with classic ASP
Can you compare ASP.NET sessions with classic ASP? ASP.NET session caches per user session state. It basically uses gHttpSessionStateh class. Following are the limitations in classic ASP sessions :- ã ASP session state is dependent on IIS process very heavily. So if IIS restarts ASP session vari...
2007-10-23, 5336👍, 0💬

What Are the Background Style Properties
What Are the Background Style Properties? - CSS Tutorials - Page Layout and Background Image Design There are 5 style properties that you can use to control the background of a HTML block tag: background-color: Specifies the color of the background. It takes a color value or the keyword "transparent...
2007-05-11, 5335👍, 0💬

What Happens If You Use a Wrong Connect Identifier
What Happens If You Use a Wrong Connect Identifier? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Of course, you will get an error, if you use a wrong connect identifier. Here is an example of how SQL*Plus react to a wrong connect identifier: SQL> CONNECT fyi/retneciyf@WRONG; ...
2007-04-28, 5334👍, 0💬

How To Check the Server Version
How To Check the Server Version? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Oracle server sersion information is stored in a table called: PRODUCT_COMPONENT_VERSION. You can use a simple SELECT statement to view the version information like this: >.\bin\sqlplus Enter user...
2007-04-25, 5334👍, 0💬

What Is a Server-Side Image Map
What Is a Server-Side Image Map? - XHTML 1.0 Tutorials - Understanding Inline Images and Image Maps A server-side image map is an image inside a hyper link. The image must be defined with the "ismap" attribute in the "img" element. When a server-side image map is clicked in a browser window, the mou...
2007-05-12, 5333👍, 0💬

Can You Copy an Array
Can You Copy an Array? - PHP Script Tips - Understanding PHP Arrays and Their Basic Operations You can create a new array by copying an existing array using the assignment statement. Note that the new array is not a reference to the old array. If you want a reference variable pointing to the old arr...
2007-04-20, 5333👍, 0💬

What is difference between dataset and datareader
What is difference between dataset and datareader ? Following are some major differences between dataset and datareader ? DataReader provides forward-only and read-only access to data, while the DataSet object can hold more than one table (in other words more than one rowset) from the same data sour...
2007-10-24, 5332👍, 0💬

How To Sort the Query Output
How To Sort the Query Output? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you want the returning rows to be sorted, you can specify a sorting expression in the ORDER BY clause. The following select statement returns rows sorted by the values in the "manager_id" column: SQL> SELEC...
2007-04-20, 5330👍, 0💬

Which config file has all the supported channels/protocol
Which config file has all the supported channels/protocol ? Machine.config file has all the supported channels and formatter supported by .NET remoting.Machine.config file can be found at “C:\WINDOWS\Microsoft.NET\Fram ework\vXXXXX\CONFIG”path. Find element in the Machine.config file which has the c...
2007-10-23, 5329👍, 0💬

How Many Ways to Get the Current Time
How Many Ways to Get the Current Time? - MySQL FAQs - Introduction to SQL Date and Time Handling There are 8 ways to get the current time: SELECT NOW() FROM DUAL; 2006-07-01 10:02:41 SELECT CURRENT_TIME() FROM DUAL; 10:02:58 SELECT SYSDATE() FROM DUAL; 2006-07-01 10:03:21 mysql> SELECT CURRENT_TIMES...
2007-05-11, 5329👍, 0💬

How To Revoke CREATE SESSION Privilege from a User
How To Revoke CREATE SESSION Privilege from a User? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you take away the CREATE SESSION privilege from a user, you can use the REVOKE command as shown in the following example script: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fy...
2007-05-01, 5328👍, 0💬

What Are DDL Statements
What Are DDL Statements? - Oracle DBA FAQ - Understanding SQL DDL Statements DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are 3 primary DDL statements: CREATE - Creating a new database object. ALTER - Altering the definition of an ex...
2007-04-22, 5328👍, 0💬

Can you explain collation sequence in sql server
Can you explain collation sequence in sql server? First let’s define collation. Collation sequences are set of rules which determine how the data is sorted and compared. Sorting rules can be defined with options with case-sensitivity, accent marks, kana character types and character width. Case sens...
2007-11-02, 5327👍, 0💬

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

How Nested Block Elements Are Formatted
How Nested Block Elements Are Formatted? - CSS Tutorials - Understanding Multiple Element Formatting Rules If a block element is nested in another block element, the inner block, child block, will be formatted as the content box of the outer block, parent block. The HTML and CSS document below shows...
2007-05-11, 5326👍, 0💬

<< < 46 47 48 49 50 51 52 53 54 55 56 > >>   Sort: Date