.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

<< < 1 2 3 4 5 6 7 8 9 10 … > >>   Sort: Date

How To Run SQL*Plus Commands in SQL Developer
How To Run SQL*Plus Commands in SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Most of the time, you only run SQL statements in SQL Worksheet, the SQL statement area. But you can also run some SQL*Plus commands in SQL Worksheet. The example below shows you how to run the DECR... 2007-04-27, 5780👍, 0💬

How To Use "FOR" Statements
How To Use "FOR" Statements? - Oracle DBA FAQ - Understanding PL/SQL Language Basics If you have a block of codes to be executed repeatedly over a range of values, you can use the "FOR ... LOOP" statement. Here is a sample script on FOR statements: DECLARE total NUMBER := 0; BEGIN FOR i IN 1..10 LOO... 2007-04-29, 5778👍, 0💬

What Are the Arithmetic Operations
What Are the Arithmetic Operations? - Oracle DBA FAQ - Understanding PL/SQL Language Basics There are 4 basic arithmetic operations on numeric values as shown in the following sample script: PROCEDURE proc_arithmetic AS addition NUMBER; subtraction NUMBER; multiplication NUMBER; division NUMBER; BEG... 2007-04-30, 5774👍, 0💬

What Is Output Spooling in SQL*Plus
What Is Output Spooling in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool The output spooling a nice feature of the command-line SQL*Plus tool. If the spooling feature is turned on, SQL*Plus will send a carbon copy of the everything on your screen to a specified local... 2007-04-29, 5772👍, 0💬

How To Delete Multiple Rows from a Table
How To Delete Multiple Rows from a Table? - Oracle DBA FAQ - Understanding SQL DML Statements You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the fyi_links table... 2007-04-21, 5766👍, 0💬

How To Get a List of All Tables in the Database
How To Get a List of All Tables in the Database? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you don't like to use a SELECT statement to get a list of all tables in the current database, you can use the Reports view to do this as shown in the following tutorial example: Click menu Vie... 2007-04-27, 5755👍, 0💬

What Is Open Database Communication (ODBC)
What Is Open Database Communication (ODBC)? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle ... 2007-04-17, 5745👍, 0💬

What Is Transport Network Substrate (TNS)
What Is Transport Network Substrate (TNS)? - Oracle DBA FAQ - Oracle Basic Concepts TNS, Transport Network Substrate, is a foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol. 2007-04-22, 5742👍, 0💬

How To List All User Accounts
How To List All User Accounts? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges User accounts can be accessed through a system view called ALL_USERS. A simple SELECT statement can be used to get a list of all user accounts. Try the following script: >.\bin\sqlplus /nolog SQL> ... 2007-05-02, 5740👍, 0💬

How To Get a CREATE Statement for an Existing Table
How To Get a CREATE Statement for an Existing Table? - Oracle DBA FAQ - Introduction to Oracle SQL Developer You have an existing table and want to get a CREATE statement for that table, you can use the SQL tab in the object view. The following tutorial steps show you how to use SQL Developer to gen... 2007-04-27, 5738👍, 0💬

How To Use "IN" Parameter Properly
How To Use "IN" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Here are the rules about IN parameters: A formal IN parameter acts like constant. It can not be assigned with new values. An actual IN parameter can take a value or a variable. An actual IN param... 2007-04-25, 5736👍, 0💬

How To Login to the Server without an Instance
How To Login to the Server without an Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If your default instance is in trouble, and you can not use the normal login process to reach the server, you can use a special login to log into the server without any instance. He... 2007-04-24, 5735👍, 0💬

How To Create a New Table in Your Schema
How To Create a New Table in Your Schema? - Oracle DBA FAQ - Managing Oracle Database Tables If you want to create a new table in your own schema, you can log into the server with your account, and use the CREATE TABLE statement. The following script shows you how to create a table: >.\bin\sqlplus /... 2007-05-03, 5718👍, 0💬

How To Install Oracle ODBC Drivers
How To Install Oracle ODBC Drivers? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection Oracle offers different ODBC drivers for different versions of Oracle servers. When you install an Oracle server or a client tools on your Windows system, the appropriate ODBC driver will be ins... 2007-04-17, 5709👍, 0💬

What Is an External Table
What Is an External Table? - Oracle DBA FAQ - Loading and Exporting Data An external table is a table defined in the database with data stored outside the database. Data of an external table is stored in files on the operating systems. Accessing data of external tables are done through data access d... 2007-04-30, 5705👍, 0💬

What Is PL/SQL Language Case Sensitive
What Is PL/SQL Language Case Sensitive? - Oracle DBA FAQ - Understanding PL/SQL Language Basics PL/SQL language is not case sensitive: Reserved words are not case sensitive. For example: CASE and Case are identical. Variable names and other names are not case sensitive. For example: TOTAL_SALARY and... 2007-05-01, 5700👍, 0💬

How To Pass a Parameter to a Cursor
How To Pass a Parameter to a Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL When you define a cursor, you can set a formal parameter in the cursor. The formal parameter will be replaced by an actual parameter in the OPEN cursor statement. Here is a good example of a cursor with two parame... 2007-04-28, 5696👍, 0💬

How To Write Date and Time Interval Literals
How To Write Date and Time Interval Literals? - Oracle DBA FAQ - Understanding SQL Basics Date and time interval literals can coded as shown in the following samples: SELECT DATE '2002-10-03' + INTERVAL '123-2' YEAR(3) TO MONTH FROM DUAL -- 123 years and 2 months is added to 2002-10-03 03-DEC-25 SEL... 2007-04-23, 5692👍, 0💬

How To Find Out What Oracle ODBC Drivers Are Installed
How To Find Out What Oracle ODBC Drivers Are Installed? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection To find out what Oracle ODBC drivers are installed on your Windows system, you can use the ODBC manager to look at them: Go to Control Panel. Go to Administrative Tools. Run ... 2007-04-17, 5690👍, 0💬

What Are the Differences between BLOB and CLOB
What Are the Differences between BLOB and CLOB? - Oracle DBA FAQ - Understanding SQL Basics The main differences between BLOB and CLOB are: BLOB stores values as LOB (Large OBject) in bitstreams. CLOB stores values as LOB (Large OBject) in character steams. 2007-04-24, 5688👍, 0💬

How To Define Default Values for Formal Parameters
How To Define Default Values for Formal Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions If you have an IN parameter, you can make it as an optional parameter for the calling statement by defining the formal parameter with the DEFAULT clause. This gives you the freedo... 2007-04-21, 5685👍, 0💬

What Are the Execution Control Statements
What Are the Execution Control Statements? - Oracle DBA FAQ - Understanding PL/SQL Language Basics PL/SQL supports three groups of execution control statements: IF Statements - Conditionally executes a block of statements. CASE Statements - Selectively executes a block of statements. LOOP Statements... 2007-04-30, 5683👍, 0💬

How To Resolve Name Conflicts between Variables and Columns
How To Resolve Name Conflicts between Variables and Columns? - Oracle DBA FAQ - Working with Database Objects in PL/SQL The best way to resolve name conflicts is to avoid using column names for variables. 2007-04-27, 5682👍, 0💬

How To Concatenate Two Text Values
How To Concatenate Two Text Values? - Oracle DBA FAQ - Understanding SQL Basics There are two ways to concatenate two text values together: CONCAT() function. '||' operation. Here is some examples on how to use them: SELECT 'FYI' || 'Center' || '.com' FROM DUAL; FYICenter.com SELECT CONCAT('FYICente... 2007-04-23, 5682👍, 0💬

<< < 1 2 3 4 5 6 7 8 9 10 … > >>   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