.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

<< < … 8 9 10 11 12 13 14 15 16 17 18 … > >>   Sort: Date

What Is SQL
What Is SQL? - Oracle DBA FAQ - Understanding SQL Basics SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation. 2007-04-24, 5085👍, 0💬

How To Get a List of All User Accounts in the Database
How To Get a List of All User Accounts 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 user accounts in the current database, you can use the Reports view to do this as shown in the following tutorial example. ... 2007-04-27, 5084👍, 0💬

What Are the ANSI Data Types Supported in Oracle
What Are the ANSI Data Types Supported in Oracle? - Oracle DBA FAQ - Understanding SQL Basics The following ANSI data types are supported in Oracle: CHARACTER(n) / CHAR(n) CHARACTER VARYING(n) / CHAR VARYING(n) NATIONAL CHARACTER(n) / NATIONAL CHAR(n) / NCHAR(n) NATIONAL CHARACTER VARYING(n) / NATIO... 2007-04-24, 5084👍, 0💬

What Do You Think about Oracle SQL Developer
What Do You Think about Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer To conclude this introductory FAQ collection, you should think about Oracle SQL Developer in comparison with other client tools like SQL*Plus and Oracle Web interface. SQL Developer is definitely be... 2007-04-28, 5080👍, 0💬

How To Use Windows User to Connect to the Server
How To Use Windows User to Connect to the Server? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges During the installation process, 10g XE will create a special Windows user group called ORA_DBA, and put your Windows user into this group. Any Windows users in this group can be... 2007-05-02, 5079👍, 0💬

What Is PL/SQL
What Is PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL PL/SQL is a modern, block-structured programming language. It provides several features that make developing powerful database applications very convenient. For example, PL/SQL provides procedural constructs, such as loops and conditional sta... 2007-04-25, 5079👍, 0💬

How To Define a Specific RECORD Type
How To Define a Specific RECORD Type? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you want to define a specific RECORD type, you need to use the TYPE ... IS RECORD statement in the declaration part of any procedure or function. The following example script defines a RECORD type cal... 2007-04-27, 5078👍, 0💬

How To Write Date and Time Literals
How To Write Date and Time Literals? - Oracle DBA FAQ - Understanding SQL Basics Date and time literals can coded as shown in the following samples: SELECT DATE '2002-10-03' FROM DUAL -- ANSI date format 03-OCT-02 SELECT TIMESTAMP '1997-01-31 09:26:50.124' FROM DUAL 31-JAN-97 09.26.50.124000000 AM -... 2007-04-24, 5077👍, 0💬

How To Convert Dates to Characters
How To Convert Dates 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, 'DD-MON-YYYY') FROM DUAL; -- SYSDATE returns the current date 07-MAY-2006 SELECT TO_CHAR(SYSDAT... 2007-04-23, 5075👍, 0💬

How To Start the Command-Line SQL*Plus
How To Start the Command-Line SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you Oracle server or client installed on your windows system, you can start the command-line SQL*Plus in two ways: 1. Click Start > All Programs > Oracle ... > Start SQL Command Line. The ... 2007-04-28, 5074👍, 0💬

What Is an Index Associated with a Constraint
What Is an Index Associated with a Constraint? - Oracle DBA FAQ - Managing Oracle Table Indexes An index associated with a constraint because this constraint is required to have an index. There are two types of constraints are required to have indexes: UNIQUE and PRIMARY KEY. When you defines a UNIQ... 2007-05-02, 5072👍, 0💬

How To Write a Query with an Inner Join
How To Write a Query with an Inner Join? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you want to query from two tables with an inner join, you can use the INNER JOIN ... ON clause in the FROM clause. The following query returns output with an inner join from two tables: employees... 2007-04-19, 5068👍, 0💬

What Is a Directory Object
What Is a Directory Object? - Oracle DBA FAQ - Loading and Exporting Data A directory object is a logical alias for a physical directory path name on the operating system. Directory objects can be created, dropped, and granted access permissions to different users. The following tutorial exercise sh... 2007-04-30, 5063👍, 0💬

How To Drop an Existing Table
How To Drop an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you want to delete an existing table and its data rows, you can use the DROP TABLE statement as shown in this script: SQL> connect HR/fyicenter Connected. SQL> CREATE TABLE emp_dept_10 2 AS SELECT * FROM employees W... 2007-05-03, 5059👍, 0💬

What Is a Subquery
What Is a Subquery? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements A subquery is a SELECT statement used as part of the selection criteria of the main SELECT statement. The subquery specified in the WHERE clause will be evaluated repeated on each row of the selection base table. The ou... 2007-04-19, 5057👍, 0💬

How To Get Help at the SQL Prompt
How To Get Help at the SQL Prompt? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Once SQL*Plus is started, you will get a SQL prompt like this: SQL&gt;. This where you can enter commands for SQL*Plus to run. To get help information at the SQL prompt, you can use the HELP c... 2007-04-28, 5056👍, 0💬

How To Create an Oracle Database Manually
How To Create an Oracle Database Manually? - Oracle DBA FAQ - Creating New Database Instance Manually Based on Oracle's Administrator Guide, there are 11 steps to create a database with the CREATE DATABASE statement: Step 1: Decide on Your Instance Identifier (SID) Step 2: Establish the Database Adm... 2007-04-22, 5056👍, 0💬

How To Shutdown Your 10g XE Server from Command Line
How To Shutdown Your 10g XE Server from Command Line? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition You can shutdown your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StopDB.bat. The ... 2007-04-24, 5053👍, 0💬

How To Write Text Literals
How To Write Text Literals? - Oracle DBA FAQ - Understanding SQL Basics There are several ways to write text literals as shown in the following samples: SELECT 'FYICenter.com' FROM DUAL -- The most common format FYICenter.com SELECT 'It''s Sunday!' FROM DUAL -- Single quote escaped It's Sunday! SELE... 2007-04-24, 5052👍, 0💬

Can Variables Be Used in SQL Statements
Can Variables Be Used in SQL Statements? - Oracle DBA FAQ - Working with Database Objects in PL/SQL Yes, you can use variables in SQL statements as part of any expressions. The tutorial script provides you some good examples: (Connect to XE with SQL*Plus) CREATE TABLE student (id NUMBER(5) PRIMARY K... 2007-04-28, 5050👍, 0💬

What Is the Implicit Cursor
What Is the Implicit Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL There is only one implicitly cursor in a session. The implicit cursor is the cursor automatically defined by PL/SQL for you. Whenever a SQL statement is executed, this cursor will be assigned to represent the execution of... 2007-04-29, 5049👍, 0💬

How To Start a Specific Oracle Instance
How To Start a Specific Oracle Instance? - Oracle DBA FAQ - Creating New Database Instance Manually A simple way to start a specific Oracle instance is to start the instance with the PFILE option as shown in the following example: >.\bin\sqlplus /nolog SQL> CONNECT / AS SYSDBA Connected. SQL> STARTU... 2007-04-23, 5048👍, 0💬

How To Rename an Index
How To Rename an Index? - Oracle DBA FAQ - Managing Oracle Table Indexes Let's say you have an existing index, and you don't like its name anymore for some reason, you can rename it with the ALTER INDEX ... RENAME TO statement. Here is an example script on how to rename an index: CREATE TABLE studen... 2007-05-02, 5047👍, 0💬

How To Grant CREATE SESSION Privilege to a User
How To Grant CREATE SESSION Privilege to a User? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want give a user the CREATE SESSION privilege, you can use the GRANT command. The following tutorial exercise shows you how to grant DEV the privilege to connect to the ser... 2007-05-02, 5047👍, 0💬

<< < … 8 9 10 11 12 13 14 15 16 17 18 … > >>   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