1 2 3 4 5 6 > >>   Sort: Date

How To Export Your Connection Information to a File
How To Export Your Connection Information to a File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer SQL Developer allows you to export your connection information into an XML file. Here is how to do this: Right-click on Connections Select Export Connection... Enter File Name as: \temp\conne...
2016-07-11, 31516👍, 1💬

💬 2013-03-06 sulochana: Thank you.. It helped me

How To Increment Dates by 1
How To Increment Dates by 1? - Oracle DBA FAQ - Understanding SQL Basics If you have a date, and you want to increment it by 1. You can do this by adding the date with a date interval. You can also do this by adding the number 1 directly on the date. The tutorial example below shows you how to addin...
2016-07-06, 30869👍, 1💬

💬 2016-07-06 Julie: Good to know. Thanks.

💬 2010-10-11 Coleen: I have an Oracle table with a column (seq_num) that needs to populated with sequential nbrs based on a group. For example, I hav...

How To Empty Your Recycle Bin
How To Empty Your Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables If your recycle bin is full, or you just want to clean your recycle bin to get rid of all the dropped tables, you can empty it by using the PURGE statement in two formats: PURGE RECYCLEBIN - Removes all dropped tables ...
2007-05-04, 10347👍, 0💬

How Many Types of Tables Supported by Oracle
How Many Types of Tables Supported by Oracle? - Oracle DBA FAQ - Managing Oracle Database Tables Oracle supports 4 types of tables based on how data is organized in storage: Ordinary (heap-organized) table - This is the basic, general purpose type of table. Its data is stored as an unordered collect...
2016-11-18, 10282👍, 1💬

How To Assign Query Results to Variables
How To Assign Query Results to Variables? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you want to assign results from SELECT statements to variables, you can use the INTO clause, which an extension of SELECT statements for PL/SQL. The sample code below shows some good example on IN...
2007-04-27, 9511👍, 0💬

What Information Is Needed to Connect SQL*Plus an Oracle Server
What Information Is Needed to Connect SQL*Plus an Oracle Server? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want to connect your SQL*Plus session to an Oracle server, you need to know the following information about this server: The network hostname, or IP address, o...
2007-04-28, 9451👍, 0💬

How To Export Data to an XML File
How To Export Data to an XML File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you want to export data from a table to a file in XML format, you can use the following steps: Right-click the table name, EMPLOYEES, in the object tree view. Select Export. Select XML. The Export Data wind...
2007-04-27, 9103👍, 0💬

How To Enter a New Row into a Table Interactively
How To Enter a New Row into a Table Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you don't like to use the INSERT statement to enter a new row into a table, you can use the object view to enter it interactively. Follow the steps below to enter new row into table TIP: Dou...
2007-04-27, 8945👍, 0💬

How To Export Data to a CSV File
How To Export Data to a CSV File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you want to export data from a table to a file in CSV format, you can use the following steps: Right-click the table name, EMPLOYEES, in the object tree view. Select Export. Select CSV. The Export Data windo...
2007-04-27, 8774👍, 0💬

How To Call a Sub Procedure
How To Call a Sub Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions To call a sub procedure, just use the sub procedure name as a statement. Here is another example of calling a sub procedure: SQL> CREATE OR REPLACE PROCEDURE WELCOME AS 2 PROCEDURE WELCOME_PRINT(S CHAR)...
2007-04-25, 8076👍, 0💬

How To Check the Oracle TNS Settings
How To Check the Oracle TNS Settings? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection If you have installed an Oracle server or an Oracle client tool on your local system, the TNS is automatically installed with a simple configuration file, tnsnames.ora, to define Oracle connec...
2007-04-17, 8008👍, 0💬

How To View All Columns in an Existing Table
How To View All Columns in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you have an existing table and want to know how many columns are in the table and how they are defined, you can use the system view USER_TAB_COLUMNS as shown in the following tutorial exercise: SQL> C...
2007-05-03, 7976👍, 0💬

How To Define a Sub Function
How To Define a Sub Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A sub function is a function defined and used inside another procedure or function. You need to define a sub function in the declaration part of the enclosing procedure or function. Sub function defini...
2007-04-25, 7896👍, 0💬

Oracle PL/SQL Questions
1. What is normalization. 2. Difference between procedure and functions. 3. Oracle 9i Vs 10g. 4. how to improve the performance of a query. 5. %type vs %rowtype. 6. regression testing. 7. deleting the duplicate records without using rowid in oracle. 8. Row chaining. 9. types of cursors.
2021-02-10, 7807👍, 1💬

💬 2021-02-10 Karthik: Hi, I just read your articles and we decided that we need backlinks from you so please go through the link for our article. Than...

How To Use "IF" Statements on Multiple Conditions
How To Use "IF" Statements on Multiple Conditions? - Oracle DBA FAQ - Understanding PL/SQL Language Basics If you have multiple blocks of codes to be executed based on different conditions, you can use the "IF ... ELSIF" statement. Here is a sample script on IF statements: DECLARE day VARCHAR2; BEGI...
2007-04-29, 7770👍, 0💬

What is difference between ADPATCH and OPATCH ?
What is difference between ADPATCH and OPATCH ? # ADPATCH is utility to apply ORACLE application Patches whereas # OPATCH is utility to apply database patches
2011-12-29, 7741👍, 0💬

How To Select an Oracle System ID (SID)
How To Select an Oracle System ID (SID)? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 1. If you are planning to create a new database, you need to select an Oracle System ID (SID). This ID will be used to identify the new Oracle database and its Oracle instance. SID must b...
2007-04-22, 7710👍, 0💬

How To Run Stored Procedures in Debug Mode
How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If have an existing stored procedure and you want to debug it interactively, you can use the debug feature provided in SQL Developer. The following exercise shows you how to start the debug mode: Open...
2007-04-28, 7672👍, 0💬

How To Recover a Dropped Index
How To Recover a Dropped Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you have the recycle bin feature turned on, dropped indexes are stored in the recycle bin. But it seems to be command to restore a dropped index out of the recycle bin. FLASHBACK INDEX is not a valid statement. See t...
2007-05-02, 7643👍, 0💬

How To Create an Array in PL/SQL
How To Create an Array in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL If you want create an array data structure, you can use the collection type VARRAY. VARRAY stands for Variable Array. Here is a sample script on how to use VARRAY: SQL> set serveroutput on; SQL> DECLARE 2 TYPE list IS VARRAY...
2007-04-26, 7626👍, 0💬

How To Set Up Breakpoints in Debug Mode
How To Set Up Breakpoints in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer To debug a stored procedure, you need to set breakpoints at different statements in the code block, so that execution will be stopped at the statement marked with a breakpoint. When execution is stopped,...
2007-04-28, 7440👍, 0💬

Can Multiple Cursors Being Opened at the Same Time
Can Multiple Cursors Being Opened at the Same Time? - Oracle DBA FAQ - Working with Cursors in PL/SQL Yes, multiple cursors can be opened at the same time. See the following example: CREATE OR REPLACE PROCEDURE FYI_CENTER AS CURSOR emp_cur IS SELECT * FROM employees; emp_rec employees%ROWTYPE; CURSO...
2007-04-28, 7401👍, 0💬

How To Define a Data Source Name (DSN) in ODBC Manager
How To Define a Data Source Name (DSN) in ODBC Manager? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection DSN (Data Source Name) is an ODBC connection identifier for Windows applications. Here is how you can define a DSN on your Windows system: Go to Control Panel. Go to Administ...
2007-04-17, 7336👍, 0💬

What Is the Data Pump Import Utility
What Is the Data Pump Import Utility? - Oracle DBA FAQ - Loading and Exporting Data Oracle Data Pump Import utility is a standalone programs that allows you to import data objects from an Oracle dump file set into Oracle database. Oracle dump file set is written in a proprietary binary format by the...
2007-05-01, 7310👍, 0💬

1 2 3 4 5 6 > >>   Sort: Date