.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

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, 5308👍, 0💬

How To Create an Oracle Database
How To Create an Oracle Database? - Oracle DBA FAQ - Creating New Database Instance Manually There are two ways to create a new database: Use the Database Configuration Assistant (DBCA) to create a database interactively. Use the CREATE DATABASE statement to create a database manually. 2007-04-22, 5307👍, 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, 5307👍, 0💬

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, 5306👍, 0💬

What Are Internal User Account
What Are Internal User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges An internal user account is a system predefined user account. Oracle 10g XE comes with a number of internal accounts: SYSTEM - This is the user account that you log in with to perform all administ... 2007-05-02, 5305👍, 0💬

How To Create a New User Account
How To Create a New User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want to create a new user account, you can log in as SYSTEM and use the CREATE USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connecte... 2007-05-02, 5301👍, 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, 5301👍, 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, 5300👍, 0💬

What is a Database Schema
What is a Database Schema? - Oracle DBA FAQ - Oracle Basic Concepts A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with S... 2007-04-21, 5297👍, 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, 5295👍, 0💬

How To Create a Stored Program Unit
How To Create a Stored Program Unit? - Oracle DBA FAQ - Introduction to PL/SQL If you want to create a stored program unit, you can use the CREATE PROCEDURE or FUNTION statement. The example script below creates a stored program unit: SQL> set serveroutput on; SQL> CREATE PROCEDURE Hello AS 2 BEGIN ... 2007-04-25, 5293👍, 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, 5291👍, 0💬

What Is a READ ONLY Transaction
What Is a READ ONLY Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management A READ ONLY transaction is a transaction in which the read consistency is set at the transaction level. In a READ ONLY transaction, a logical snapshot of the database is created at the beginning of the trans... 2007-04-17, 5291👍, 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, 5290👍, 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, 5288👍, 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, 5286👍, 0💬

How To Define an Explicit Cursor
How To Define an Explicit Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL An explicit cursor must be defined in the declaration part of a procedure or function with the CURSOR ... IS statement as shown in the following sample script: DECLARE CURSOR c_list IS SELECT * FROM countries; CURSOR... 2007-04-29, 5281👍, 0💬

How To Delete a Column in an Existing Table
How To Delete a Column in an Existing Table? - Oracle DBA FAQ - Understanding SQL DDL Statements If you have an existing column in a table and you need that column any more, you can delete it with ALTER TABLE ... DROP COLUMN statement. Here is an example SQL script: SQL> CREATE TABLE emp_dept_90 2 A... 2007-04-22, 5281👍, 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, 5281👍, 0💬

What Happens to the Current Transaction If the Session Is Ended
What Happens to the Current Transaction If the Session Is Ended? - Oracle DBA FAQ - Understanding SQL Transaction Management If a session is ended, the current transaction in that session will be committed and ended. All the database changes made in the current transaction will become permanent. Thi... 2007-04-18, 5278👍, 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, 5276👍, 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, 5276👍, 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, 5274👍, 0💬

How To Install Oracle SQL Developer
How To Install Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Once you have sqldeveloper-v1.0.0.zip downloaded, extract the zip file into the root directory: \. When the extraction is done, the installation is completed. Your copy of Oracle SQL Developer is installed i... 2007-04-26, 5273👍, 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