.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

<< < … 75 76 77 78 79 80 81 82 83 84 85 … > >>   Sort: Date

How To Connect a SQL*Plus Session to an Oracle Server
How To Connect a SQL*Plus Session to an Oracle Server? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool In order to connect a SQL*Plus session to an Oracle server, you need to: 1. Obtain the connection information from the Oracle server DBA. 2. Define a new "connect identifier" c... 2007-04-28, 5126👍, 0💬

How To Return an Array from a Function
How To Return an Array from a Function? - PHP Script Tips - Creating Your Own Functions You can return an array variable like a normal variable using the return statement. No special syntax needed. Here is a PHP script on how to return an array from a function: &lt;?php function powerBall() { $a... 2007-04-24, 5126👍, 0💬

What is a prompt box?
What is a prompt box? A prompt box allows the user to enter input by providing a text box. 2008-09-03, 5125👍, 0💬

Can we change the order in a select query with a specified collation sequence
Can we change the order in a select query with a specified collation sequence? Yes we can specify a collate sequence in the order by clause. That will change the sort according to the collation defined in the order by claused. ORDER BY { order_by_expression [ COLLATE collation_name ] [ ASC | DESC ] ... 2007-11-02, 5125👍, 0💬

How To Get Extra Space between Paragraphs
How To Get Extra Space between Paragraphs? - XHTML 1.0 Tutorials - Body Tag and Block Level Tags By default, browsers will give a predefined white space between two paragraphs. But if you want some extra white space between two paragraphs, you can enter an extra paragraph with a &amp;nbsp; entit... 2007-05-12, 5123👍, 0💬

What Are the Types PL/SQL Code Blocks
What Are the Types PL/SQL Code Blocks? - Oracle DBA FAQ - Introduction to PL/SQL There are 3 types of PL/SQL code blocks: Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. Stored Program Unit - A block of codes with a name.... 2007-04-25, 5123👍, 0💬

How To Retrieve the Session ID of the Current Session
How To Retrieve the Session ID of the Current Session? - PHP Script Tips - Understanding and Using Sessions Normally, you don't need to know the session ID of the current session. But if you are interested to know the session ID created by the PHP engine, there are two ways to get it: Calling sessio... 2007-04-18, 5123👍, 0💬

That Is a Correlated Subquery
That Is a Correlated Subquery? Correlated Subquery is a subquery that is evaluated once for each row processed by the parent statement. Parent statement can be Select, Update or Delete. Use Correlated Subquery to answer multipart questions whose answer depends on the value in each row processed by p... 2007-04-15, 5122👍, 0💬

How To Define a Variable to Match a Table Column Data Type
How To Define a Variable to Match a Table Column Data Type? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a table, and want to define some variables to have exactly the same data types as some columns in that table, you can use table_name.column_name%TYPE as data types to de... 2007-04-26, 5121👍, 0💬

How Remove Data Files befor opening a Database
How Remove Data Files befor opening a Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files Let's say you have a corrupted data file or lost a data file. Oracle can mount the database. But it will not open the database. What you can do is to set the bad data file as offline befor o... 2007-05-02, 5120👍, 0💬

How To Add a New Column to an Existing Table with a Default Value
How To Add a New Column to an Existing Table with a Default Value? - Oracle DBA FAQ - Managing Oracle Database Tables If you want to add a new column to an existing table, and insert a default value in this column on all existing data rows, you can use the ALTER TABLE ... ADD statement with the DEFA... 2007-05-03, 5119👍, 0💬

How To Experiment a Data Lock
How To Experiment a Data Lock? - Oracle DBA FAQ - Understanding SQL Transaction Management If you want to have some experience with data locks, you can create two windows runing two SQL*Plus sessions. In session 1, you can run a UPDATE statements to create a data lock. Before committing session 2, s... 2007-04-17, 5119👍, 0💬

What Is "mysql"
What Is "mysql"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysql" is a command-line interface for end users to manage user data objects. You can use "mysql" to run any standard SQL statements against the server. For example, you use the following SQL statements to manage tables a... 2007-05-11, 5118👍, 0💬

What Is an Oracle Tablespace
What Is an Oracle Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes. 2007-05-04, 5118👍, 0💬

How To Rollback the Current Transaction
How To Rollback the Current Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management If you have used some DML statements updated some data objects, you find a problem with those updates, and you don't want those updates to be permanently recorded in the database, you can use the ROL... 2007-04-18, 5118👍, 0💬

What is "this" keyword?
What is "this" keyword? It refers to the current object. 2008-11-04, 5117👍, 0💬

How To Invoke the Original Export Import Utilities
How To Invoke the Original Export Import Utilities? - Oracle DBA FAQ - Loading and Exporting Data If you really want to run the original export import utilities, you can still go to "bin" directory of the Oracle server path and run the "exp" or "imp" command. The tutorial exercise below tells you ho... 2007-05-02, 5117👍, 0💬

How To Export Several Tables Together
How To Export Several Tables Together? - Oracle DBA FAQ - Loading and Exporting Data If you don't want to export the entire schema and only want to export several tables only, you can use the "expdp" command with the "TABLES" parameter as shown in the following tutorial exercise: >cd \oraclexe\app\o... 2007-05-01, 5117👍, 0💬

How To Include CSS Inside a HTML Tag
How To Include CSS Inside a HTML Tag? - CSS Tutorials - Introduction To CSS Basics If you want to include CSS inside a HTML tag, you can use the STYLE attribute as &lt;TAG STYLE="css_definition" ...>. Of course, the CSS definition will only apply to this instance of this tag. The following tutor... 2007-05-11, 5116👍, 0💬

Where Table Data Is Stored by the MyISAM Storage Engine
Where Table Data Is Stored by the MyISAM Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, each database will have its own subdirectory to store table data.... 2007-05-10, 5116👍, 0💬

What is differece between echo and printf in php
What is differece between echo and printf in php PHP Echo Vs Print Diagram <?php print "Hello World! "; echo "Hello World! "; // The above outputs the text "Hello World!" on two separate lines. // Notice they are identical in output! print ("Hello World! "); echo ("Hello World! "); // The above a... 2011-08-01, 5115👍, 0💬

How Cookies Are Transported from Servers to Browsers
How Cookies Are Transported from Servers to Browsers? - PHP Script Tips - Understanding and Managing Cookies Cookies are transported from a Web server to a Web browser in the header area of the HTTP response message. Each cookie will be included in a separate "Set-Cookie:" header line in the followi... 2007-04-24, 5115👍, 0💬

How To Select an Exiting Database
How To Select an Exiting Database? - PHP Script Tips - Working with MySQL Database The first thing after you have created a connection object to the MySQL server is to select the database where your tables are locate, by using the mysql_select_db() function. If your MySQL server is offered by your W... 2007-04-18, 5115👍, 0💬

Are Atom Feed Files XML Documents
Are Atom Feed Files XML Documents? - RSS FAQs - Atom Feed File Structure and Elements Yes. Atom feed files are XML (eXtensible Markup Language) documents. Atom feed files must be well-formed XML documents, respecting the following XML rules. The first line must be the "xml" processing instruction wi... 2007-05-12, 5114👍, 0💬

<< < … 75 76 77 78 79 80 81 82 83 84 85 … > >>   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