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

Binary String Data Types in SQL Server Transact-SQL
What are binary string data types supported in SQL Server Transact-SQL? Binary string data types are used to hold binary character strings. There are 3 binary string data types supported in SQL Server Transact-SQL: 1. BINARY - Used to hold binary strings of a fixed length, specified in the format of...
2017-04-04, 757👍, 0💬

Process Query Result in PL/SQL in Oracle
How To Process Query Result in PL/SQL in Oracle? You can run queries (SELECT statements) in a PL/SQL code blocks, and process the results a loop as shown in the following script example: SQL&gt; set serveroutput on; SQL&gt; BEGIN 2 FOR row IN 3 (SELECT * FROM employees WHERE manager_id = 101...
2019-03-08, 756👍, 0💬

What Is "mysqld" Command in MySQL
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background on your computer system. Invoking "mysqld" will start the MySQL server on your system. Terminating "mysqld" will shutdown the MySQL server. Here is a tutorial example of invoking "mysqld" with the "--...
2018-06-01, 756👍, 0💬

Truncating DATETIME Values to Dates without Time in SQL Server
How To Truncate DATETIME Values to Dates without Time in SQL Server Transact-SQL? Assuming that you have some date and time, DATETIME, values, and you want to work with dates only. You want to truncate them to dates without time, or with time of 00:00:00.000. Again, SQL Server offers no simple solut...
2017-02-08, 756👍, 0💬

Show All Tablespaces in the Current Database in Oracle
How To View Tablespaces in the Current Database in Oracle? If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example: SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; SELECT TABLESP...
2019-01-20, 755👍, 0💬

Unicode Character Data Types in SQL Server Transact-SQL
What are Unicode character string data types supported in SQL Server Transact-SQL? Unicode character string data types are used to hold Unicode character strings. There are 3 Unicode character string data types supported in SQL Server Transact-SQL: 1. NCHAR (or NATIONAL CHAR, or NATIONAL CHARACTER) ...
2017-04-08, 755👍, 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, 755👍, 0💬

Converting Numeric Data Types by Assignment Operations in SQL Server
How To Convert Numeric Expression Data Types by Assignment Operations in SQL Server Transact-SQL? An assignment operation is used to assign an expression to a variable, a column, or a parameter. If the data type of the expression does not match the data type of the receiving variable, column, or par...
2017-03-27, 754👍, 0💬

Sample Databases Are Provided by Microsoft in SQL Server
What Sample Scripts and Sample Databases Are Provided by Microsoft in SQL Server? In order to help you to learn SQL Server, Microsoft provides several free sample scripts and sample databases. SqlServerSamples.msi - 25,469 KB: Sample scripts. AdventureWorksDB.msi - 28,053 KB: Sample OLTP database: A...
2016-12-04, 754👍, 0💬

Ways to End the Current Transaction in Oracle
How To End the Current Transaction in Oracle? 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 transaction. Running any DDL statement will implicitly e...
2019-09-04, 753👍, 0💬

What Is a Directory Object in Oracle
What Is a Directory Object in Oracle? A directory object is a logical alias for a physical directory path name on the operating system. Directory objects can be created, dropped, and granted access permissions to different users. The following tutorial exercise shows you some good examples: &gt;...
2016-10-15, 752👍, 0💬

Define a Variable to Match Column Data Type in Oracle
How To Define a Variable to Match a Table Column Data Type in Oracle? 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 define those variables. The tutorial sample below s...
2018-08-14, 751👍, 0💬

Use SQL Statements in PL/SQL in Oracle
How To Use SQL Statements in PL/SQL in Oracle? SQL DML (Data Manipulation Language) statements can be included in PL/SQL code blocks directly without any changes. See the script below for examples: SQL&gt; CREATE TABLE tip (id NUMBER(5) PRIMARY KEY, 2 subject VARCHAR(80) NOT NULL, 3 description ...
2019-03-08, 750👍, 0💬

sys.sql_modules - Getting View Definitions Back in SQL Server
How To Get the Definition of a View Out of the SQL Server in SQL Server? If you want get the definition of an existing view back from the SQL Server, you can use the system view called sys.sql_modules, which stores defitions of views and procedures. The sys.sql_modules holds view definitions identif...
2016-11-05, 750👍, 0💬

Data Pump Import Utility in Oracle
What Is the Data Pump Import Utility in Oracle? 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 Data Pump Export utility. Import ca...
2016-10-15, 750👍, 0💬

Define a Sub Procedure in Oracle
How To Define a Sub Procedure in Oracle? A sub procedure is a named procedure defined and used inside another procedure or function. You need to define a sub procedure in the declaration part of the enclosing procedure or function. Sub procedure definition starts with the PROCEDURE key word. Here is...
2018-10-26, 749👍, 0💬

Installing MySQL Server in MySQL
How To Install MySQL Server in MySQL? MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local computer very easily. Here is how you can do this: Go to http://dev.mysql.com/downloads /mysql/5.0.html.Select th...
2018-06-12, 749👍, 0💬

Start a Specific Oracle Instance in Oracle
How To Start a Specific Oracle Instance in Oracle? A simple way to start a specific Oracle instance is to start the instance with the PFILE option as shown in the following example: &gt;.\bin\sqlplus /nolog SQL&gt; CONNECT / AS SYSDBA Connected. SQL&gt; STARTUP NOMOUNT PFILE=$ORACLE_HOME...
2018-05-08, 749👍, 0💬

DECLARE Statements in SQL Server Transact-SQL
How to declare a variable in SQL Server Transact-SQL? How to use the DECLARE statements? In Transact-SQL, you must use DECLARE statements to declare variables. Declaring a variable is to define the variable name and the variable data type. In Transact-SQL, you can: Declare a single variable in a sin...
2017-04-04, 749👍, 0💬

Show All Tables in Your Schema in Oracle
How To List All Tables in Your Schema in Oracle? If you log in with your Oracle account, and you want to get a list of all tables in your schema, you can get it through the USER_TABLES view with a SELECT statement, as shown in the following SQL script: SQL&gt; connect HR/fyicenter Connected. SQL...
2019-05-10, 748👍, 0💬

Add Another Datafile to a Tablespace in Oracle
How To Add Another Datafile to a Tablespace in Oracle? If you created a tablespace with a data file a month ago, now 80% of the data file is used, you should add another data file to the tablespace. This can be done by using the ALTER TABLESPACE ... ADD DATAFILE statement. See the following sample s...
2019-04-09, 748👍, 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, 748👍, 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, 748👍, 0💬

Types of PL/SQL Code Blocks in Oracle
What Are the Types 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 an anonymous b...
2018-10-30, 748👍, 0💬

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