.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

<< < … 14 15 16 17 18 19 20 21 22 23 24 > >>   Sort: Date

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

What Is a Recycle Bin
What Is a Recycle Bin? - Oracle DBA FAQ - Oracle Basic Concepts Recycle bin is a logical storage to hold the tables that have been dropped from the database, in case it was dropped in error. Tables in recycle bin can be recovered back into database by the Flashback Drop action. Oracle database recyc... 2007-04-22, 4910👍, 0💬

How To End the Current Transaction
How To End the Current Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management There are several ways the current transaction can be ended: Running the COMMIT statement will explicitly end the current transaction. Running the ROLLBACK statement will explicitly end the current transa... 2007-04-18, 4909👍, 0💬

What Is an Oracle Instance
What Is an Oracle Instance? - Oracle DBA FAQ - Oracle Basic Concepts Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and start... 2007-04-21, 4905👍, 0💬

What Operating Systems Are Supported by Oracle Database 10g XE
What Operating Systems Are Supported by Oracle Database 10g XE? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Oracle Database 10g Express Edition is available for two types of operating Systems: Linux x86 - Debian, Mandriva, Novell, Red Hat and Ubuntu Microsoft Windows 2007-04-23, 4902👍, 0💬

How To Use SQL*Plus Built-in Timers
How To Use SQL*Plus Built-in Timers? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you don't have a stopwatch/timer and want to measure elapsed periods of time, you can SQL*Plus Built-in Timers with the following commands: TIMING - Displays number of timers. TIMING START [n... 2007-04-29, 4892👍, 0💬

What Is a Table Index
What Is a Table Index? - Oracle DBA FAQ - Managing Oracle Table Indexes Index is an optional structure associated with a table that allow SQL statements to execute more quickly against a table. Just as the index in this manual helps you locate information faster than if there were no index, an Oracl... 2007-05-02, 4872👍, 0💬

What Are Group Functions
What Are Group Functions? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements Group functions are functions applied to a group of rows. Examples of group functions are: COUNT(*) - Returns the number of rows in the group. MIN(exp) - Returns the minimum value of the expression evaluated on ea... 2007-04-20, 4860👍, 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, 4845👍, 0💬

Can DML Statements Be Used in PL/SQL
Can DML Statements Be Used in PL/SQL? - Oracle DBA FAQ - Working with Database Objects in PL/SQL Yes, you can run almost any DML statements in PL/SQL directly. To manipulate Oracle database data you can include INSERT, UPDATE, and DELETE statements, directly in PL/SQL programs, without any special n... 2007-04-28, 4835👍, 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, 4828👍, 0💬

What is difference between SUBSTR and INSTR?
What is difference between SUBSTR and INSTR? INSTR function search string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence. SUBSTR function return a portion of string, beginning at character position, substring_le... 2011-12-19, 4813👍, 0💬

How To Start Your 10g XE Server
How To Start Your 10g XE Server? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Go to the Start menu, select All Programs, Oracle Database 10g Express Edition, and Start Database. 2007-04-24, 4793👍, 0💬

Why doesn't my messages show on the screen?
Why doesn't my messages show on the screen? Regardless of whether you call the MESSAGE() built-in with ACKNOWLEDGE, NO_ACKNOWLEDGE, or with no mode specification at all, your message may or may not be displayed. This is because messages are displayed asynchronously. To display messages immediately, ... 2011-04-19, 4778👍, 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, 4777👍, 0💬

What Is an Oracle Database
What Is an Oracle Database? - Oracle DBA FAQ - Oracle Basic Concepts An Oracle database is a collection of data treated as a big unit in the database server. 2007-04-21, 4764👍, 0💬

What Is an Oracle Data File
What Is an Oracle Data File? - Oracle DBA FAQ - Oracle Basic Concepts An Oracle data file is a big unit of physical storage in the OS file system. One or many Oracle data files are organized together to provide physical storage to a single Oracle tablespace. 2007-04-22, 4756👍, 0💬

How to compile JSP in Oracle Applications ?
How to compile JSP in Oracle Applications ? You can use ojspCompile.pl perl script shipped with Oracle Applications to compile JSP files. This script is under $JTF_TOP/admin/scripts. Sample compilation method is perl ojspCompile.pl --compile --quiet 2011-12-28, 4531👍, 0💬

What is .lgi files ?
What is .lgi files ? lgi files are created with patching along with .log files . .lgi files are informative log files containing information related to patch. You can check .lgi files to see what activities patch has done. Usually informative logs. 2011-11-07, 4350👍, 0💬

Can you use both ADPATCH and OPATCH in application ?
Can you use both ADPATCH and OPATCH in application ? Yes you have to use both in application , for application patches you will use ADPATCH UTILITY and for applying database patch in application you will use opatch UTILITY. 2011-12-29, 4183👍, 0💬

What is Web Listener ?
What is Web Listener ? Web Listener is Web Server listener which is listening for web Services(HTTP) request. This listener is started by adapcctl.sh and defined by directive (Listen, Port) in httpd.conf for Web Server. When you initially type request like http://becomeappsdba.blogspot. com:80to acc... 2011-12-27, 4049👍, 0💬

How to compile Invalid Objects in database ?
How to compile Invalid Objects in database ? You can use adadmin utility to compile or you can use utlrp.sql script shipped with Oracle Database to compile Invalid Database Objects. 2011-12-28, 4030👍, 0💬

What is difference between COMPILE_ALL=SPECIAL and COMPILE=ALL while compiling Forms ?
What is difference between COMPILE_ALL=SPECIAL and COMPILE=ALL while compiling Forms ? Both the options will compile all the PL/SQL in the resultant .FMX, .PLX, or .MMX file but COMPILE_ALL=YES also changes the cached version in the source .FMB, .PLL, or .MMB file. This confuses version control and ... 2011-11-17, 4026👍, 0💬

How does one compile MS Help files?
How does one compile MS Help files? The Microsoft Help Compiler does not ship with Designer/2000 or Developer/2000, but you can download it from here: * Where to Get Compilers and Other Files? Note: Designer/2000 includes a Help Generator that can generate source files for the Help Compiler. 2011-05-03, 3949👍, 0💬

<< < … 14 15 16 17 18 19 20 21 22 23 24 > >>   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