.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

<< < … 58 59 60 61 62 63 64 65 66 67 68 … > >>   Sort: Date

How To Use Existing Values in UPDATE Statements
How To Use Existing Values in UPDATE Statements? - Oracle DBA FAQ - Understanding SQL DML Statements If a row matches the WHERE clause in a UPDATE statement, existing values in this row can be used in expressions to provide new values in the SET clause. Existing values are represented by columns in ... 2007-04-21, 5189👍, 0💬

How To List All Indexes in Your Schema
How To List All Indexes in Your Schema? - Oracle DBA FAQ - Managing Oracle Table Indexes If you log in with your Oracle account, and you want to get a list of all indexes in your schema, you can get it through the USER_INDEXES view with a SELECT statement, as shown in the following SQL script: SELEC... 2007-05-02, 5188👍, 0💬

How To Use an Explicit Cursor without OPEN Statements
How To Use an Explicit Cursor without OPEN Statements? - Oracle DBA FAQ - Working with Cursors in PL/SQL If you want to open a cursor and loop through its data rows in quick way, you can use the FOR ... IN ... LOOP statement in the same way as the implicit cursor. The following tutorial exercise giv... 2007-04-29, 5188👍, 0💬

What class allows you to read objects directly from a stream?
What class allows you to read objects directly from a stream? The ObjectInputStream class supports the reading of objects from input streams. 2012-07-31, 5187👍, 0💬

How To Update Values on Multiple Rows
How To Update Values on Multiple Rows? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If the WHERE clause in an UPDATE matches multiple rows, the SET clause will be applied to all matched rows. This rule allows you to update values on multiple rows in a single UPDATE statement... 2007-05-11, 5187👍, 0💬

What Is a Database Table
What Is a Database Table? - Oracle DBA FAQ - Managing Oracle Database Tables A database table is a basic unit of data logical storage in an Oracle database. Data is stored in rows and columns. You define a table with a table name, such as employees, and a set of columns. You give each column a colum... 2007-05-03, 5187👍, 0💬

How To Define a Cursor Variable
How To Define a Cursor Variable? - Oracle DBA FAQ - Working with Cursors in PL/SQL To define cursor variable, you must decide which REF CURSOR data type to use. There are 3 ways to select a REF CURSOR data type: Define your own specific REF CURSOR types using the TYPE ... RETURN statement. Define yo... 2007-04-28, 5187👍, 0💬

How To Do a Full Database Export
How To Do a Full Database Export? - Oracle DBA FAQ - Loading and Exporting Data If you are ready to do a full database export, you can use the FULL=y parameter on the expdp command, as shown in the following tutorial exercise: >expdp SYSTEM/fyicenter FULL=y ESTIMATE_ONLY=y Starting "SYSTEM"."SYS_EXP... 2007-05-01, 5184👍, 0💬

What Is a Cursor
What Is a Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL A cursor looks like a variable, but it is not a variable. A cursor looks like a procedure, but it is not a procedure. A cursor is a cursor. It is a logical representation of a resource connects to a set of data rows related to a DML... 2007-04-29, 5184👍, 0💬

How To Call a Stored Function with Parameters
How To Call a Stored Function with Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions You can define a function that takes parameters, provide values to those parameters when calling the function. Here is a good example of a function with a parameter: SQL> CREATE OR REP... 2007-04-25, 5183👍, 0💬

How about 2+5+8?
How about 2+5+"8"? Since 2 and 5 are integers, this is number arithmetic, since 8 is a string, it’s concatenation, so 78 is the result. 2008-09-16, 5180👍, 0💬

What is the difference between Server.Transfer and response.Redirect
What is the difference between Server.Transfer and response.Redirect ? Following are the major differences between them:- ? Response.Redirect sends message to the browser saying it to move to some different page, while server.transfer does not send any message to the browser but rather redirects the... 2007-10-24, 5179👍, 0💬

What To Do If DBA Lost the SYSTEM Password
What To Do If DBA Lost the SYSTEM Password? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If the DBA lost the password of the SYSTEM user account, he/she can go to the Oracle server machine, and run SQL*Plus on server locally with the operating system authentication method to ... 2007-04-28, 5178👍, 0💬

How To Test Persistent Cookies
How To Test Persistent Cookies? - PHP Script Tips - Understanding and Managing Cookies If you want to test persistent cookies, you can copy the following PHP script, setting_persistent_cookies.php ,to your Web server: &lt;?php setcookie("LoginName","FYICent er");setcookie("PreferredColor","Bl ue"... 2007-04-25, 5178👍, 0💬

How To Remove a Cookie
How To Remove a Cookie? - PHP Script Tips - Understanding and Managing Cookies Once a cookie is sent from the server to the browser, there is no direct way for the server to ask the browser to remove the cookie. But you can use the setcookie() function to send the same cookie to browser with a negat... 2007-04-24, 5178👍, 0💬

How To Remove the New Line Character from the End of a Text Line
How To Remove the New Line Character from the End of a Text Line? - PHP Script Tips - PHP Built-in Functions for Strings If you are using fgets() to read a line from a text file, you may want to use the chop() function to remove the new line character from the end of the line as shown in this PHP sc... 2007-04-22, 5178👍, 0💬

What Is Browser Resolution
What Is Browser Resolution? - CSS Tutorials - Page Layout and Background Image Design Browser resolution is measure by how many graphical points (pixels) per inch on a Web browser window. Logically, browser resolution should be identical to the screen resolution, for example, FireFox. But there is a... 2007-05-11, 5177👍, 0💬

How To Close a Session Properly
How To Close a Session Properly? - PHP Script Tips - Understanding and Using Sessions Let's say you site requires users to login. When a logged in user clicks the logout button, you need to close the session associated with this user properly in 3 steps: Remove all session values with $_SESSION = ar... 2007-04-17, 5177👍, 0💬

How To Use "startup" Command to Start Default Instance
How To Use "startup" Command to Start Default Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If you logged in to the server as a SYSDBA, you start the default instance with the "startup" command. Here is how to start the default instance in SQL*Plus in SYSDBA mode: ... 2007-04-24, 5176👍, 0💬

What is Asynchronous One-Way Calls
What is Asynchronous One-Way Calls ? One-way calls are a different from asynchronous calls from execution angle that the .NET Framework does not guarantee their execution. In addition, the methods used in this kind of call cannot have return values or out parameters. One-way calls are defined by usi... 2007-10-23, 5175👍, 0💬

What Is NULL in PL/SQL
What Is NULL in PL/SQL? - Oracle DBA FAQ - Understanding PL/SQL Language Basics NULL is a reserved key word and it stands for two things in PL/SQL: NULL is an executable statement, and means doing nothing. NULL is a data balue, and means no value. The following sample script shows you examples of us... 2007-04-29, 5175👍, 0💬

What Are DML Statements
What Are DML Statements? - Oracle DBA FAQ - Understanding SQL DML Statements DML (Data Manipulation Language) statements are statements to change data values in database tables. The are 3 primary DML statements: INSERT - Inserting new rows into database tables. UPDATE - Updating existing rows in dat... 2007-04-22, 5175👍, 0💬

Do I have to know HTML or SGML before I learn XML
Do I have to know HTML or SGML before I learn XML? No. Although it's useful because a lot of XML terminology and practice derives from two decades' experience of SGML. Be aware that "knowing HTML" is not the same as "understanding SGML". Although HTML was written as an SGML application, browsers ign... 2007-04-11, 5175👍, 0💬

What is WSDL
What is WSDL? Web Service Description Language (WSDL)is a W3C specification which defines XML grammar for describing Web Services.XML grammar describes details such as:- ã Where we can find the Web Service (its URI)? ã What are the methods and properties that service supports? ã Data type suppo... 2007-10-23, 5174👍, 0💬

<< < … 58 59 60 61 62 63 64 65 66 67 68 … > >>   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