.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   Sort: Date

How To Create a New Table
How To Create a New Table? - Oracle DBA FAQ - Understanding SQL DDL Statements 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 /nolog SQL> con... 2007-04-22, 5124👍, 0💬

How To Create a New View
How To Create a New View? - Oracle DBA FAQ - Understanding SQL DDL Statements You can create a new view based on one or more existing tables by using the CREATE VIEW statement as shown in the following script: CREATE VIEW employee_department AS SELECT e.employee_id, e.first_name, e.last_name, e.emai... 2007-04-22, 5114👍, 0💬

How To Insert a New Row into a Table
How To Insert a New Row into a Table? - Oracle DBA FAQ - Understanding SQL DML Statements To insert a new row into a table, you should use the INSERT INTO statement with values specified for all columns as shown in the following example: INSERT INTO fyi_links VALUES (101, 'http://dev.fyicenter.com',... 2007-04-21, 5113👍, 0💬

How To Use LIKE Conditions
How To Use LIKE Conditions? - Oracle DBA FAQ - Understanding SQL Basics LIKE condition is also called pattern patch. There 3 main rules on using LIKE condition: '_' is used in the pattern to match any one character. '%' is used in the pattern to match any zero or more characters. ESCAPE clause is us... 2007-04-23, 5090👍, 0💬

How To Drop an Existing Table
How To Drop an Existing Table? - Oracle DBA FAQ - Understanding SQL DDL Statements 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 ... 2007-04-22, 5003👍, 0💬

How To Drop an Existing View
How To Drop an Existing View? - Oracle DBA FAQ - Understanding SQL DDL Statements If you have an existing view, and you don't want it anymore, you can delete it by using the DROP VIEW statement as shown in the following script: DROP VIEW employee_department; View dropped. 2007-04-22, 4891👍, 0💬

How To Rename an Index
How To Rename an Index? - Oracle DBA FAQ - Understanding SQL DDL Statements 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 stu... 2007-04-22, 4836👍, 0💬

<< < 1 2 3   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