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

Export Data to an XML File in Oracle
How To Export Data to an XML File in Oracle? 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 window shows up. Click Format tab. Select Format a...
2019-01-12, 476👍, 0💬

Run Stored Procedures Interactively in Oracle
How To Run a Stored Procedure Interactively in Oracle? If have an existing stored procedure and you want to run it interactively, the tutorial steps listed below will help you out: Open you connection name, like Local_XE. Open Procedures. Right-click the procedure name: HELLO. Select Run. The Run PL...
2019-01-12, 418👍, 0💬

Create a Stored Procedure Interactively in Oracle
How To Create a Procedure Interactively in Oracle? If you want to create a stored procedure interactively, you can use the following steps: Open you connection name, like Local_XE. Right-click Procedures. Select Create PROCEDURE. The Create Procedure window shows up. Enter Name as: Hello Click OK. T...
2019-01-12, 365👍, 0💬

Assign Debug Privilege to a User in Oracle
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the session must be connected with a user who has debug privileges. The following script shows you how to assign debug privileges: Connect to the default database, XE, as SYSTEM. Run "GRANT debug any pro...
2019-01-12, 551👍, 0💬

Run Stored Procedures in Debug Mode in Oracle
How To Run Stored Procedures in Debug Mode in Oracle? 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 you connection name, like Local_XE. Open Proc...
2019-01-12, 457👍, 0💬

Create a Table in a Given Tablespace in Oracle
How To Create a Table in a Specific Tablespace in Oracle? After you have created a new tablespace, you can give it to your users for them to create tables in the new tablespace. To create a table in a specific tablespace, you need to use the TABLESPACE clause in the CREATE TABLE statement. Here is a...
2019-01-08, 583👍, 1💬

💬 2019-01-08 Bvm: Help :)

Bring a Tablespace Offline in Oracle
How To Bring a Tablespace Offline in Oracle? If you want to stop users using a tablespace, you can bring it offline using the ALTER TABLESPACE ... OFFLINE statement as shown in the following script: SQL> connect HR/fyicenter Connected. SQL> CREATE TABLESPACE my_space 2 DATAFILE '/temp/...
2019-01-01, 508👍, 0💬

Bring a Tablespace Online in Oracle
How To Bring a Tablespace Online in Oracle? If you have brought a tablespace offline, now you want to make it available to users again, you can use the ALTER TABLESPACE ... ONLINE statement as shown in the following script: SQL> connect HR/fyicenter SQL> CREATE TABLESPACE my_space 2 DA...
2019-01-01, 503👍, 0💬

Keep Data Files When Tablespace Dropped in Oracle
What Happens to Data Files If a Tablespace Is Dropped in Oracle? If a tablespace is dropped, what happens to its data files? By default, data files will remain in OS file system, even if the tablespace they are mapped is dropped. Of course, you delete the data files using OS commands, if they are no...
2019-01-01, 406👍, 0💬

Show Free Space in a Tablespace in Oracle
How To See Free Space of Each Tablespace in Oracle? One of the important DBA tasks is to watch the storage usage of all the tablespaces to make sure there are enough free space in each tablespace for database applications to function properly. Free space information can be monitored through the USER...
2019-01-01, 393👍, 0💬

dba.FYIcenter.com Links
Collections: DBA Jobs Interview Questions DBA Articles/a> Oracle Tutorials SQL Server Tutorials MySQL Tutorials Site Map Other Resources: Software QA Resources Developer Resources DBA Resources Windows Tutorials Java JAR Files DLL Files File Extensions Security Certificates Regular Expression Link D...
2019-01-01, 138👍, 0💬

Understanding PL/SQL Language Basics
Where to find answers to frequently asked questions on Understanding PL/SQL Language Basics? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Understanding PL/SQL Language Basics. It can also be used as learning tutorials on defining variables, ass...
2018-12-26, 531👍, 0💬

Enter Comments in PL/SQL in Oracle
How To Enter Comments in PL/SQL in Oracle? There are two ways to enter comments into PL/SQL codes: SQL Statement Style: Starts you comment any where in the line but prefixed with '--'. The comment ends at the end of the line. C Language Style: Starts you comment any where in the line with '/*' and e...
2018-12-26, 510👍, 0💬

Set Up Breakpoints in Debug Mode in Oracle
How To Set Up Breakpoints in Debug Mode in Oracle? 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, you can then investigate different variables ...
2018-12-26, 507👍, 0💬

What Do You Think about Oracle SQL Developer in Oracle
What Do You Think about Oracle SQL Developer in Oracle? 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 better than the other tools, more functionality,...
2018-12-26, 459👍, 0💬

PL/SQL Language Case Insensitive in Oracle
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words are not case sensitive. For example: CASE and Case are identical. Variable names and other names are not case sensitive. For example: TOTAL_SALARY and total_salary are identical. But values in string l...
2018-12-26, 451👍, 0💬

PL/SQL Anonymous Block in Oracle
What Is an Anonymous Block in Oracle? An anonymous block is a PL/SQL code block with no name. It consists of three parts: Declaration Part - Defining local variables and local procedures. Declaration part is optional. Execution Part - Defining execution logic with executable statements. Execution pa...
2018-11-29, 551👍, 0💬

PL/SQL Functions in Oracle
What Is a Function in Oracle? 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 required. Execution Part - Defining execution logic with execu...
2018-11-29, 545👍, 0💬

Different Types of PL/SQL Code Blocks in Oracle
What Are the Different Types of PL/SQL Code Blocks in Oracle? There are 3 types of PL/SQL code blocks: Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. Stored Program Unit - A block of codes with a name. It is similar to a...
2018-11-29, 518👍, 0💬

PL/SQL Named Program Unit in Oracle
What Is a Named Program Unit in Oracle? A named program unit is a PL/SQL code block with an name. It consists of three parts: Declaration Part - Defining the program unit name, calling parameters, local variables and local procedures. Declaration part is required. Execution Part - Defining execution...
2018-11-29, 517👍, 0💬

PL/SQL Procedure in Oracle
What Is a Procedure in Oracle? 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 Part - Defining execution logic with executable statements...
2018-11-29, 481👍, 0💬

Scalar Data Types Supported in PL/SQL in Oracle
How Many Scalar Data Types Are Supported in PL/SQL in Oracle? PL/SQL supports many scalar data types divided into 4 groups: Numeric Types: BINARY_DOUBLE, BINARY_FLOAT, BINARY_INTEGER, DEC, DECIMAL, DOUBLE PRECISION, FLOAT, INT, INTEGER, NATURAL, NATURALN, NUMBER, NUMERIC, PLS_INTEGER, POSITIVE, POSI...
2018-11-17, 539👍, 0💬

Convert Character Types to Numeric Types in Oracle
How To Convert Character Types to Numeric Types in Oracle? You can convert character types to numeric types in two ways: Explicitly by using TO_NUMBER() function. Implicitly by putting character data in a numeric operation. The sample script below shows you how to convert character types to numeric ...
2018-11-17, 500👍, 0💬

Categories of Data Types in PL/SQL in Oracle
How Many Categories of Data Types in Oracle? PL/SQL data types are grouped into 4 categories: Scalar Data Types: A scalar data type holds a single value. Composite Data Types: A composite data type has internal components, such as the elements of an array. LOB Data Types: A LOB data type holds a lob...
2018-11-17, 465👍, 0💬

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