General MySQL Oracle SQL Server

<< < … 23 24 25 26 27 28 29 30 31 32 33 … > >>   ∑:1357  Sort:Date

Commonly Used MSSQL Functions in PHP
What Are Commonly Used MSSQL Functions in PHP? If you look at the PHP 5 manual, you will see a group of functions listed under the Microsoft SQL Server Functions section. The commonly used functions are: mssql_connect � Open MS SQL server connection mssql_close � Close MS SQL Server connection mssql... 2024-04-07, 2687🔥, 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, 2687🔥, 0💬

Downloading and Installing PHP on Windows
How To Download and Install PHP on Windows? PHP is one of the most popular languages to develop dynamic Web pages. It supports all major database servers, including: MySQL, MS SQL Server, Oracle, mSQL, Sybase, etc. If you are developing a Web application that uses PHP and needs to access MS SQL Serv... 2024-04-29, 2684🔥, 0💬

Understanding SQL SELECT Query Statements in Oracle
Where to find answers to frequently asked questions on SQL SELECT Query Statements in Oracle? I want to query data from tables. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL SELECT Query Statements in Oracle. Clear answers are provided with ... 2020-01-04, 2684🔥, 0💬

Relations between a Tablespace and Data Files in Oracle
How a Tablespace Is Related to Data Files in Oracle? Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.   ⇒ Relation between Database and Tablespaces in Oracle ⇐ Oracle ... 2019-01-20, 2684🔥, 0💬

Use NULL as Conditions in Oracle
How To Use NULL as Conditions in Oracle? If you want to compare values against NULL as conditions, you should use the "IS NULL" or "IS NOT NULL" operator. Do not use "=" or "&lt;&gt;" against NULL. The sample script below shows you some good examples: SELECT 'A' IS NULL FROM DUAL; -- Error: ... 2019-12-02, 2683🔥, 0💬

Date and Time Intervals in MySQL
What Are Date and Time Intervals in MySQL? A date and time interval is special value to be used to increment or decrement a date or a time at a given date or time unit. A data and time interval should be expression in the format of "INTERVAL expression unit", where "unit" and "expression" should fol... 2017-12-26, 2682🔥, 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, 2682🔥, 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, 2681🔥, 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, 2680🔥, 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, 2680🔥, 0💬

File Formats Supported on Export Data in Oracle
How Many File Formats Are Supported to Export Data in Oracle? Oracle SQL Developer can allow to export table data into files in the following formats: TXT - Tab delimited fields file format. CSV - Comma Separated Values (CSV) file format. LOADER - File format used by SQL*Loader. XML - XML file forma... 2019-01-26, 2679🔥, 0💬

"CREATE USER" Statements - Creating a User in SQL Server
How to create a user to access a database using "CREATE USER" statements in SQL Server? This is the second tutorial of a quick lesson on creating login and configure users for databases with Transact-SQL statements. Granting a user access to a database involves three steps. First, you create a login... 2016-11-27, 2678🔥, 0💬

Privilege to Insert Rows in Another Schema in Oracle
What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema in Oracle? For a user to insert rows into tables of someone else's schema, he/she needs the INSERT ANY TABLE privilege. The following tutorial exercise gives you a good example of granting "dev" to insert rows in "hr" sch... 2019-06-11, 2675🔥, 0💬

What Is "mysqldump" Command in MySQL
What Is "mysqldump" in MySQL? "mysqldump" - A command-line interface for administrators or end users to export data from the server to files. Here are some sample commands supported by "mysqldump": "mysqldump databaseName tableName" - Dumps the specified table in the specified database. "mysqldump d... 2018-05-19, 2675🔥, 0💬

Show Installed Oracle ODBC Drivers in Oracle
How To Find Out What Oracle ODBC Drivers Are Installed in Oracle? To find out what Oracle ODBC drivers are installed on your Windows system, you can use the ODBC manager to look at them: Go to Control Panel. Go to Administrative Tools. Run Data Sources (ODBC). Go to System DSN tab. Click the Add but... 2016-10-15, 2674🔥, 0💬

What Is PL/SQL in Oracle
What Is PL/SQL in Oracle? PL/SQL is a modern, block-structured programming language. It provides several features that make developing powerful database applications very convenient. For example, PL/SQL provides procedural constructs, such as loops and conditional statements, that are not available ... 2018-10-30, 2673🔥, 0💬

DEFAULT - Using Column Default Values in INSERT Statements in SQL Server
How To Use Column Default Values in INSERT Statements in SQL Server? If a column is defined with a default value in a table, you can use the key word DEFAULT in the INSERT statement to take the default value for that column. The following tutorial exercise gives a good example: INSERT INTO fyi_links... 2016-11-03, 2673🔥, 0💬

Configuring ODBC DSN with Different Port Numbers
How To Configure ODBC DSN with Different Port Numbers? If your SQL Server is not using the default port number, like 1269, you need to set the port number to the correct value during the ODBC DSN creation process, as show in this tutorial: 1. Start ODBC Data Source Administrator and click System DSN... 2024-07-25, 2672🔥, 0💬

Oracle SQL Developer Written in Java in Oracle
Is Oracel SQL Developer written in Java in Oracle? Oracel SQL Developer is written in Java. It requires JDK 1.5, which is already included in your download file.   ⇒ Connect to Local 10g XE Server in Oracle ⇐ Start Oracle SQL Developer in Oracle ⇑ Introduction to Oracle SQL Developer ⇑⇑ Oracle Dat... 2019-02-05, 2672🔥, 0💬

Oracle SQL Developer Written in Java in Oracle
Is Oracel SQL Developer written in Java in Oracle? Oracel SQL Developer is written in Java. It requires JDK 1.5, which is already included in your download file.   ⇒ Connect to Local 10g XE Server in Oracle ⇐ Start Oracle SQL Developer in Oracle ⇑ Introduction to Oracle SQL Developer ⇑⇑ Oracle Dat... 2019-02-05, 2672🔥, 0💬

Compilation Error in a Statement Batch in SQL Server
What happens to a Transact-SQL statement batch if there is a compilation error? If a Transact-SQL statement batch has multiple statements, and one of them has compilation error, none of the statements in the batch will be executed. The tutorial exercise below gives you some good examples: SELECT get... 2017-05-29, 2671🔥, 0💬

List of Data Types in SQL Server Transact-SQL
How many data types supported in SQL Server Transact-SQL? I want a list of all data types. Here is a list of all Transact-SQL data types divided into 6 categories: 1. Exact Number - Used to hold numeric values truncated to a specific precision and scale. BIGINT - Used to hold big integers. INT (or I... 2017-04-22, 2671🔥, 0💬

Establish Administrator Authentication to the Server in Oracle
How To Establish Administrator Authentication to the Server in Oracle? This is Step 2. There are two ways to establish administrator authentication to a new database. Use a password file. Use operating system (OS) authentication. Using OS authentication is easier on Windows system. If you used your ... 2019-04-03, 2670🔥, 0💬

<< < … 23 24 25 26 27 28 29 30 31 32 33 … > >>   ∑:1357  Sort:Date

General MySQL Oracle SQL Server