.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

<< < … 140 141 142 143 144 145 146 147 148 149 150 … > >>   Sort: Rank

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

How To Define a Data Field as NOT NULL
How To Define a Data Field as NOT NULL? - Oracle DBA FAQ - Working with Database Objects in PL/SQL When defining a specific RECORD type, you can define a data field as NOT NULL to make sure variables with this RECORD type to always have values in this field. A field defined as NOT NULL must have a d... 2007-04-27, 5246👍, 0💬

How To Define a RECORD Variable to Store a Table Row
How To Define a RECORD Variable to Store a Table Row? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a table, and want to define a RECORD variable to store all the data elements of a row from that table, you can use table_name%ROWTYPE to define the RECORD variable as shown in... 2007-04-27, 5088👍, 0💬

How To Assign a Table Row to a RECORD Variable
How To Assign a Table Row to a RECORD Variable? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a table, and want to assign a data row of that table to a RECORD variable, you need to define this RECORD variable to match the table column structure, then use the SELECT ... INTO ... 2007-04-27, 5358👍, 0💬

How To Run SQL Statements with Oracle SQL Developer
How To Run SQL Statements with Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Once a connection is established with an Oracle server, you can enter any SQL statements in the SQL Statement area. Try yourself with the following steps: Go to the SQL Statement area Enter S... 2007-04-27, 5486👍, 0💬

How To Insert a Record into a Table
How To Insert a Record into a Table? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a RECORD variable with data fields matching a table structure, you can insert a row to this table with this RECORD variable using the INSERT statement as shown in the example below: CREATE TAB... 2007-04-26, 5264👍, 0💬

How To Connect to a Remote Server
How To Connect to a Remote Server? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you have an Oracle server running remotely on a network, and you know all the access information needed, you can following steps to connect your Oracle SQL Developer: Start Oracle SQL Developer Right-click ... 2007-04-26, 5891👍, 0💬

How To Update a Table Row with a Record
How To Update a Table Row with a Record? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a RECORD variable with data fields matching a table structure, you can update a row in this table with this RECORD variable using the UPDATE ... SET ROW statement as shown in the sample sc... 2007-04-26, 5505👍, 0💬

How To Connect to a Local Oracle 10g XE Server
How To Connect to a Local Oracle 10g XE Server? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you have your Oracle 10g XE server running on your local machine, you can connect your Oracle SQL Developer to the server with the following steps: Start Oracle SQL Developer Right-click on Con... 2007-04-26, 5995👍, 0💬

Is Oracel SQL Developer written in Java
Is Oracel SQL Developer written in Java? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Oracel SQL Developer is written in Java. It requires JDK 1.5, which is already included in your download file. 2007-04-26, 5248👍, 0💬

How To Define a Variable to Match a Table Column Data Type
How To Define a Variable to Match a Table Column Data Type? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a table, and want to define some variables to have exactly the same data types as some columns in that table, you can use table_name.column_name%TYPE as data types to de... 2007-04-26, 5175👍, 0💬

How To Start Oracle SQL Developer
How To Start Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer To start Oracle SQL Developer, go to \sqldeveloper and click sqldeveloper.exe. The Oracle SQL Developer window shows up. Your copy of Oracle SQL Developer is running now. There will nothing under the Connectio... 2007-04-26, 5060👍, 0💬

What Is a Procedure
What Is a Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required. Execution... 2007-04-26, 5118👍, 0💬

What Is a Function
What Is a Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A function is a named program unit. It consists of three parts: Declaration Part - Defining the function name, calling parameters, return value type, local variables and local procedures. Declaration part is req... 2007-04-26, 4993👍, 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, 5183👍, 0💬

How To Define an Anonymous Procedure without Variables
How To Define an Anonymous Procedure without Variables? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Anonymous procedure is a procedure without any name. If you don't have any variables to declare, you can define an anonymous procedure by using the BEGIN keyword directly in S... 2007-04-26, 5100👍, 0💬

How To Download Oracle SQL Developer
How To Download Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you want to download a copy of Oracle SQL Developer, visit http://www.oracle.com/technolo gy/software/products/sql/.If you are using Windows systems, click the "Oracle SQL Developer for Windows" link. Th... 2007-04-26, 5115👍, 0💬

Java Bean Class with 100 Fields
How to write a bean class, when you have 100 fields and each have three sub fields. 2007-04-26, 5768👍, 0💬

How To Define an Anonymous Procedure with Variables
How To Define an Anonymous Procedure with Variables? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Anonymous procedure is a procedure without any name. If you have some variables to declare, you can define an anonymous procedure by using the DECLARE keyword in SQL*Plus as show... 2007-04-26, 5116👍, 0💬

What Operating Systems Are Supported by Oracle SQL Developer
What Operating Systems Are Supported by Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Oracle SQL Developer is available for three types of operating Systems: Windows Linux Mac OSX 2007-04-26, 4854👍, 0💬

What Is Oracle SQL Developer
What Is Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Oracle SQL Developer is a new, free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and ... 2007-04-26, 5256👍, 0💬

How To Create a Stored Procedure
How To Create a Stored Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A stored procedure is a procedure with a specified name and stored into the current database. If you want to create a stored procedure, you can use the CREATE PROCEDURE statement. The example scrip... 2007-04-26, 5363👍, 0💬

How To Define a Procedure inside Another Procedure
How To Define a Procedure inside Another Procedure? - Oracle DBA FAQ - Introduction to PL/SQL Define a procedure inside another procedure is supported by PL/SQL. The following tutorial script shows you an example: SQL> CREATE OR REPLACE PROCEDURE HR.DBA_WEEK AS 2 PROCEDURE DBA_TASK (day VARCHAR2) AS... 2007-04-26, 5339👍, 0💬

How To Execute a Stored Procedure
How To Execute a Stored Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions If you want to execute a stored procedure, you can use the EXECUTE statement. The example script below shows how to executes a stored procedure: SQL> set serveroutput on; SQL> CREATE PROCEDURE Gre... 2007-04-26, 5417👍, 0💬

<< < … 140 141 142 143 144 145 146 147 148 149 150 … > >>   Sort: Rank

.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