General MySQL Oracle SQL Server

<< < … 18 19 20 21 22 23 24 25 26 27 28 … > >>   ∑:1363  Sort:Date

Instance Settings Stored in SPFile in Oracle
Where Are the Settings Stored for Each Instance in Oracle? Settings for each instance are stored in a file called Server Parameter File (SPFile). Oracle supports two types of parameter files, Text type, and Binary type. parameter files should be located in $ORACLE_HOME\database directory. A paramete... 2020-09-15, 3241🔥, 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, 3241🔥, 0💬

What Is "mysql" Command in MySQL
What Is "mysql" in MySQL? "mysql" is a command-line interface for end users to manage user data objects. You can use "mysql" to run any standard SQL statements against the server. For example, you use the following SQL statements to manage tables and table rows: "CREATE TABLE links (name VARCHAR(80)... 2018-05-19, 3241🔥, 0💬

Start an Oracle Instance in Oracle
How To Start an Oracle Instance in Oracle? This is Step 6. Now you are ready to start the new Oracle Instance without any database. This instance will be used to create a database. Starting an instance without database can be done by using STARTUP NOMOUNT statement as shown below: &gt;.\bin\sqlp... 2018-05-08, 3241🔥, 0💬

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, 3239🔥, 0💬

Text Literals in Oracle
How To Write Text Literals in Oracle? There are several ways to write text literals as shown in the following samples: SELECT 'FYICenter.com' FROM DUAL -- The most common format FYICenter.com SELECT 'It''s Sunday!' FROM DUAL -- Single quote escaped It's Sunday! SELECT N'Allo, C''est moi.' FROM DUAL ... 2020-04-14, 3238🔥, 0💬

SELECT Query Statements with GROUP BY in MySQL
Where to find answers to frequently asked questions on SELECT Query Statements with GROUP BY in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team SELECT Query Statements with GROUP BY in MySQL. Clear answers are provided with tutorial exercises ... 2017-11-05, 3238🔥, 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, 3236🔥, 0💬

Using Stored Procedures in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Using Stored Procedures in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Using Stored Procedures in SQL Server Transact-SQL. Clear answers are provided with tutorial... 2017-01-11, 3235🔥, 0💬

Tools to Manage MySQL Server in MySQL
What Tools Available for Managing MySQL Server in MySQL? MySQL comes with the following programs as administration tools for you to manage your MySQL server: mysqld - MySQL server daemon. You can use "mysqld" to start your MySQL server. mysqladmin - A command-line interface for administrators to per... 2018-06-01, 3234🔥, 0💬

Select Some Rows from a Table in Oracle
How To Select Some Rows from a Table in Oracle? If you don't want select all rows from a table, you can specify a WHERE clause to tell the query to return only the rows that meets the condition defined in the WHERE clause. The following select statement only returns rows that has department name sta... 2019-12-19, 3232🔥, 0💬

What Is "mysqladmin" Command in MySQL
What Is "mysqladmin" in MySQL? "mysqladmin" is a command-line interface for administrators to perform server administration tasks. It support a number of commonly used commands like: "mysqladmin shutdown" - Shuts down the server. "mysqladmin ping" - Checks if the server is alive or not. "mysqladmin ... 2018-06-01, 3232🔥, 0💬

"mysql" - Command Line End User Interface in MySQL
What Is the Command Line End User Interface - mysql in MySQL? "mysql", official name is "MySQL monitor", is a command-line interface for end users to manage user data objects. "mysql" has the following main features: "mysql" is command line interface. It is not a Graphical User Interface (GUI). "mys... 2018-04-28, 3231🔥, 0💬

What Is a Function 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-01-27, 3231🔥, 0💬

What Are DML Statements in Oracle
What Are DML Statements in Oracle? DML (Data Manipulation Language) statements are statements to change data values in database tables. The are 3 primary DML statements: INSERT - Inserting new rows into database tables. UPDATE - Updating existing rows in database tables . DELETE - Deleting existing ... 2020-02-07, 3228🔥, 0💬

Default Schema of Your Login Session in SQL Server
What Is the Default Schema of Your Login Session in SQL Server? When you login to a SQL Server and select a database to use, SQL Server will assign your login session a default schema. The schema name can be omitted when you refer to objects in the default schema. Here is what you should remember ab... 2016-10-22, 3228🔥, 0💬

Create a New Table in Oracle
How To Create a New Table in Oracle? If you want to create a new table in your own schema, you can log into the server with your account, and use the CREATE TABLE statement. The following script shows you how to create a table: &gt;.\bin\sqlplus /nolog SQL&gt; connect HR/fyicenter Connected.... 2020-02-29, 3227🔥, 0💬

Create Your Own Reports in SQL Developer in Oracle
How To Create Your Own Reports in SQL Developer in Oracle? Oracle SQL Developer also lets you create your own reports. See the following steps on how to do this: Click menu View. Selects Reports from the menu. Open Reports. Right-click on User Defined Reports. Select Add Report. Enter Name as: My Te... 2019-01-26, 3227🔥, 0💬

Passing Expressions to Function Parameters in SQL Server
Can You Pass Expressions to Function Parameters in SQL Server Transact-SQL? Can you pass expressions to stored procedure parameters? The answer is yes. When executing functions, input values can be written as expressions. But the resulting value data type must match the parameter. The tutorial exerc... 2016-12-18, 3227🔥, 0💬

Show CREATE TABLE Statements of Existing Tables in MySQL
How To See the CREATE TABLE Statement of an Existing Table in MySQL? If you want to know how an existing table was created, you can use the "SHOW CREATE TABLE" command to get a copy of the "CREATE TABLE" statement back on an existing table. The following tutorial script shows you a good example: mys... 2018-03-04, 3225🔥, 0💬

Accessing MySQL Server through Firewalls in MySQL
How To Access MySQL Servers through Firewalls in MySQL? If your MySQL server is provided by an Internet service company, connecting to the server from your local machine will not be so easy, because there are firewalls between your local machine and your MySQL server as shown below: Firewalls to MyS... 2017-11-25, 3223🔥, 0💬

Verify Oracle TNS Settings in Oracle
How To Verify Oracle TNS Settings in Oracle? 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 connect identifiers. For example, if you have Oracle XE server instal... 2016-10-15, 3221🔥, 0💬

What Is TIMESTAMP Data Type in MySQL
What Is TIMESTAMP Data Type in MySQL? A TIMESTAMP data type allows you to record a date and time like DATETIME data type. But it has some interesting features when used on a table column: The first TIMESTAMP column in a table will be assigned with the current date and time, if it is not listed in an... 2018-03-13, 3220🔥, 0💬

Passing Values to Stored Procedure Parameters in SQL Server
How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedure is created with parameters, you need pass values to those parameters when calling the stored procedure with one of two formats listed below: -- Passing values only EXEC procedure_name value_1, valu... 2016-12-28, 3219🔥, 0💬

<< < … 18 19 20 21 22 23 24 25 26 27 28 … > >>   ∑:1363  Sort:Date

General MySQL Oracle SQL Server