<< < 6 7 8 9 10 11 12 13 14 15 16 > >>   Sort: Date

"sys.objects" - Listing All Objects in a Given Schema in SQL Server
How To List All Objects in a Given Schema in SQL Server? If you are wonder what objects are stored in a given schema as an object container, you can use view "sys.objects" to get a list of all objects in a schema. The tutorial exercise shows you how to list all objects in schema "fyi" and "dbo": -- ...
2016-10-22, 860👍, 0💬

Save Query Output to a Local File in Oracle
How To Save Query Output to a Local File in Oracle? Normally, when you run a SELECT statement in SQL*Plus, the output will be displayed on your screen. If you want the output to be saved to local file, you can use the "SPOOL fileName" command to specify a local file and start the spooling feature. W...
2020-07-15, 859👍, 0💬

Rename an Existing Table in Oracle
How To Rename an Existing Table in Oracle? If you don't like the name of an existing table, you change it by using the CREATE TABLE ... RENAME TO statement. Here is a sample script: SQL&gt; connect HR/fyicenter Connected. SQL&gt; CREATE TABLE emp_dept_10 2 AS SELECT * FROM employees WHERE de...
2019-06-01, 859👍, 0💬

Introduction to Oracle PL/SQL
Where to find answers to frequently asked questions about Oracle PL/SQL in general? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team about Oracle PL/SQL in general. This FAQ can also be used as learning tutorials on creating procedures, executing proc...
2019-03-27, 859👍, 0💬

ALTER TABLE - Add a New Column in Oracle
How To Add a New Column to an Existing Table in Oracle? If you have an existing table with existing data rows, and want to add a new column to that table, you can use the ALTER TABLE ... ADD statement to do this. Here is an example script: SQL&gt; connect HR/fyicenter Connected. SQL&gt; CREA...
2020-02-29, 857👍, 0💬

Date/Time Data Type Comparison in SQL Server Transact-SQL
What are differences between date and time data types in SQL Server Transact-SQL? I want to compare of date and time data types? Here is a comparison table of all date and time data types supported in SQL Server Transact-SQL: Data type Storage size Precision Default Format / (bytes) Value range ----...
2017-02-25, 857👍, 0💬

Example of Passing Parameters to Procedures in Oracle
How To Pass Parameters to Procedures in Oracle? Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this: SQL&gt; CREATE OR REPLACE PROC...
2019-03-08, 854👍, 0💬

What Is a Cursor in Oracle
What Is a Cursor in Oracle? A cursor looks like a variable, but it is not a variable. A cursor looks like a procedure, but it is not a procedure. A cursor is a cursor. It is a logical representation of a resource connects to a set of data rows related to a DML statement. A cursor is consists of: A D...
2018-02-01, 853👍, 0💬

Revoke CREATE SESSION Privilege in Oracle
How To Revoke CREATE SESSION Privilege from a User in Oracle? If you take away the CREATE SESSION privilege from a user, you can use the REVOKE command as shown in the following example script: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter SQL&gt; REVOKE CREATE SESSION FROM d...
2019-07-09, 850👍, 0💬

Use DML Statements in PL/SQL in Oracle
Can DML Statements Be Used in PL/SQL in Oracle? 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 notation, as shown in the following sample code: (...
2018-10-13, 850👍, 0💬

Start and End of Statement in SQL Server Transact-SQL
How to start and end a statement in SQL Server Transact-SQL? Here are some simple rules about writing statements in SQL Server Transact-SQL: A Transact-SQL statement must be started with a pre-defined statement keyword. A Transact-SQL statement must be ended with a new line (/n) or a semicolon (;) c...
2017-05-29, 850👍, 0💬

Get System Date and Time in SQL Server Transact-SQL
How to get system date and time in SQL Server Transact-SQL? I want a list of functions for getting current system date and time. Here is a comparison of all functions that you can use to get the current date and time from the data base server system: Function Return type Precision ------------------...
2017-02-25, 850👍, 0💬

Use Multiple Columns in GROUP BY in Oracle
Can Multiple Columns Be Used in GROUP BY in Oracle? You can use multiple columns in the GROUP BY clause as shown in the following example. It returns how many employees are having the same salary in each department: SQL&gt; SELECT department_id, salary, count(*) 2 FROM employees GROUP BY departm...
2019-10-27, 849👍, 0💬

Create an Array in PL/SQL in Oracle
How To Create an Array in PL/SQL in Oracle? 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&gt; set serveroutput on; SQL&gt; DECLARE 2 TYPE list IS VARRAY(3) OF VARCHAR(16)...
2019-03-08, 849👍, 0💬

Working with Database Objects in Oracle PL/SQL
Where to find answers to frequently asked questions on Working with Database Objects in Oracle PL/SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Working with Database Objects in Oracle PL/SQL. Clear answers are provided with tutorial exercis...
2018-10-13, 849👍, 0💬

Starting mysqld to Support BDB Storage Engine in MySQL
How To Start mysqld to Support the BDB Storage Engine in MySQL? The default "mysqld" program does not support the BDB storage engine. If you want to use the BDB storage engine, you can start MySQL server with the "mysqld-max" program. The tutorial exercise below shows you how to start "mysqld-max" a...
2017-08-13, 849👍, 0💬

Transaction Isolation Levels in MySQL
What Are Transaction Isolation Levels in MySQL? There are 4 transaction isolation levels defined by SQL-1992 standard: READ UNCOMMITTED - The SELECT statements in one transaction will read uncommitted data changes from transactions of all connected sessions. In this level, "dirty read" could happen,...
2017-08-03, 849👍, 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&gt; connect HR/fyicenter SQL&gt; CREATE TABLESPACE my_space 2 DA...
2019-01-01, 848👍, 0💬

Execute a Stored Procedure in Oracle
How To Execute a Stored Procedure in Oracle? 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&gt; set serveroutput on; SQL&gt; CREATE PROCEDURE Greeting AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LINE('Welc...
2018-11-11, 848👍, 0💬

Load Data with SQL*Loader in Oracle
How To Load Data with SQL*Loader in Oracle? Let's say you have a table defined as: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL, birth_date DATE NOT NULL, social_number VARCHAR(80) UNIQUE NOT NULL); There is an input data file stored...
2016-11-27, 848👍, 0💬

Generate Query Output in HTML Format in Oracle
How To Generate Query Output in HTML Format in Oracle? If you want your query output to be generated in HTML format, you can use the "SET MARKUP HTML ON" to turn on the HTML feature. The following tutorial exercise gives you a good example: SQL&gt; connect HR/retneciyf SQL&gt; SET MARKUP HTM...
2020-07-15, 847👍, 0💬

Logical Operations in PL/SQL in Oracle
What Are the Logical Operations in Oracle? PL/SQL supports 3 logical operations as shown in the following sample script: PROCEDURE proc_comparison AS x BOOLEAN := TRUE; y BOOLEAN := FALSE; res BOOLEAN; BEGIN res = x AND y; res = x OR y; res = NOT x; -- more statements END;   ⇒Understanding PL/SQL La...
2018-08-06, 846👍, 0💬

Approximate Numeric Literals in SQL Server Transact-SQL
What are approximate numeric literals supported in SQL Server Transact-SQL? Approximate numeric literals in Transact-SQL are numbers written in scientific notation formats. Approximate numeric literals are used to provide values to approximate numeric variables or table columns like LOAT(24), DOUBLE...
2017-05-05, 846👍, 0💬

Load Data through External Tables in Oracle
How To Load Data through External Tables in Oracle? If you have data stored in external files, you can load it to database through an external table by the steps below: Create an external table with columns matching data fields in the external file. Create a regular table with the same columns. Run ...
2016-11-27, 845👍, 0💬

<< < 6 7 8 9 10 11 12 13 14 15 16 > >>   Sort: Date