Concatenation Operator

By: Jesse Miller

Concatenation operator `II` manipulates character strings. The result of concatenating two character strings is another character string. If both character strings are of data type CHAR, the result has data type CHAR and is limited to 2000 characters. If either string is of data type VARCHAR2, the result has data type VARCHAR2 and is limited to 4000 characters. Trailing blanks in character strings are presented by concatenation, regardless of the strings data types.

To eliminate duplicate rows from the result, include distinct keyword immediately after the select keyword. Duplicate rows increase the memory size and remains as an additional burden for tables and sorting.

Describe command is used to know what columns are contained in a table. The describe command can be shortened to desc. It is a powerful tool for sorting columns.

ISQL*Plus is browser-based interface to SQL*Plus. ISQL*Plus enables the user to use a web browser to connect to Oracle9i and perform the same actions which a command line version of SQL*Plus would perform. ISQL *Plus uses a three tier architectural model compromising Client Tier (ISQL *Plus user interface, typically a web browser), Middle Tier (ISQL *Plus Server, Oracle Net, and Oracle HTTP Server), and Database Tier (Oracle9i). Any machine can be used which has the capability to connect to the Oracle HTTP Server. The following web browsers are supported Netscape Navigator 4.7 or later, and Microsoft Internet explorer 5.0 or later. Ensure that the browser is set to enable the usage of JavaScript and cookies.

The Oracle HTTP Server and the ISQL *Plus Server must be running on the middle tier before using or running ISQL *Plus. To run ISQL*Plus enter the uniform resource identifier (URL) of ISQL *Plus in the location field of the preferred web browser for connectivity which can support ISQL *Plus. Host domain is the URL for the Oracle HTTP Server which would be used for running ISQL *Plus.

The ISQL*Plus log in screen is displayed after connecting to the location. Each successful login is uniquely identified, so you can have multiple ISQL *Plus sessions running the same machine, or from multiple client machines.

A user should enter his Username, Password, and connection identifier. After entering the information you're preferred or the privilege level should be used to connect to Oracle9i. After entering the information press the login button and ISQL *Plus is displayed.

Quick Note: Taking the Nonsense out of looking for the right spyware remover

If you really want to take the work out of looking for that right Spyware Protection from a go to the Internet and get a or a Free
Download, In order to prevent your vital information from being ripped from your computer get your Remover Today.

When connecting with AS SYSDBA or AS SYSOPER privileges, the URL changes.

Computers
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 

» More on Computers