General MySQL Oracle SQL Server

<< < … 28 29 30 31 32 33 34 35 36 37 38 … > >>   ∑:1363  Sort:Date

Read Consistency Support in MySQL in MySQL
How Does MySQL Handle Read Consistency in MySQL? Read consistency is a concept that describes how consistent the output will be on two subsequent read operations. A read operation is usually a stand alone SELECT statement or a SELECT subquery in a parent statement. A database server can support up t... 2017-08-03, 2981🔥, 0💬

SGA Setting Is Too Low in Oracle
What Happens If You Set the SGA Too Low in Oracle? Let's you made a mistake and changed to SGA to 16MB from the SYSTEM admin home page. When you run the batch file StartDB.bat, it will return a message saying server stated. However, if you try to connect to your server home page: http://localhost:80... 2020-09-30, 2980🔥, 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, 2980🔥, 0💬

Turn On and Off Recycle Bin for the Instance in Oracle
How To Turn On or Off Recycle Bin for the Instance in Oracle? You can turn on or off the recycle bin feature for an instance in the instance parameter file with "recyclebin=on/off". You can also turn on or off the recycle bin feature on the running instance with a SQL*Plus command, if you log in as ... 2019-05-14, 2980🔥, 0💬

Order of Columns in the SET Clause in MySQL
Is the Order of Columns in the SET Clause Important in MySQL? Yes. The order of columns in the SET clause of the UPDATE statement is important. There is a BIG DIFFERENCE between MySQL and Oracle on update columns with previous values: Oracle provides you the existing values from the database on colu... 2018-01-13, 2980🔥, 0💬

Oracle Tablespace - Unit of Logical Storage in Oracle
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes.   ⇒ Oracle Data File - Unit of Physical Storage in Oracle ⇐ Managing Oracle Tab... 2019-04-17, 2979🔥, 0💬

Entering Binary Numbers in MySQL
How To Enter Binary Numbers in SQL Statements in MySQL? If you want to enter character strings or numeric values as binary numbers, you can quote binary numbers with single quotes and a prefix of (B), or just prefix binary numbers with (0b). Binary numbers will be automatically converted into charac... 2018-03-31, 2979🔥, 0💬

Deleting an Existing Database in MySQL
How To Drop an Existing Database in MySQL? If want to drop an existing database from the MySQL server, you can use the DROP DATABASE statement. Here is a good example of dropping an existing database: $con = mysql_connect('localhost:8888' ,'dev', 'iyf'); $sql = 'DROP DATABASE fyi'; if (mysql_query($... 2017-10-23, 2978🔥, 0💬

"ALTER LOGIN" - Changing a Login Name in SQL Server
How To Change a Login Name in SQL Server? If you want to change a login name, you can use the "ALTER LOGIN" statement as shown in this tutorial example: -- Login with "sa" -- Change login name ALTER LOGIN Fyi_Login WITH NAME = Dba_Login; GO -- View login names SELECT name, sid, type, type_desc FROM ... 2016-10-19, 2978🔥, 0💬

Insert a New Row into a Table in Oracle
How To Insert a New Row into a Table in Oracle? To insert a new row into a table, you should use the INSERT INTO statement with values specified for all columns as shown in the following example: INSERT INTO fyi_links VALUES (101, 'http://dev.fyicenter.com', NULL, 0, '30-Apr-2006'); 1 row created. S... 2020-01-29, 2975🔥, 0💬

What Are NULL Values in SQL Server
What Are NULL Values in SQL Server Transact-SQL? A NULL value is a special value that represents an unknown value. SQL Server supports NULL values with the following features: All data types used for table columns support NULL values. In another word, NULL values can be stored in database tables. In... 2017-02-05, 2975🔥, 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, 2974🔥, 0💬

Use IN Conditions in Oracle
How To Use IN Conditions in Oracle? An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE. Some examples are given in the script below: SELECT CASE WHEN 3 IN (1,2,3,5) THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE S... 2020-03-15, 2973🔥, 0💬

Data File for InnoDB Storage Engine in MySQL
Where Table Data Is Stored by the InnoDB Storage Engine in MySQL? By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, InnoDB storage engine will create 3 files to store and manage all tables that use the InnoDB storage engine: ib... 2017-08-13, 2973🔥, 0💬

Using Subqueries with the IN Operator in MySQL
How To Use Subqueries with the IN Operator in MySQL? A subquery can be used with the IN operator as "expression IN (subquery)". The subquery should return a single column with one or more rows to form a list of values to be used by the IN operation. The following tutorial exercise shows you how to u... 2017-09-17, 2972🔥, 0💬

Adding a New User Account in MySQL
How To Add a New User Account in MySQL? If you want to add a new user account, you can connect to the server as "root" and use the "CREATE USER ..." command. The command syntax for create a new user account with a specified user name and password is: CREATE USER userName IDENTIFIED BY 'passwordStrin... 2017-09-08, 2970🔥, 0💬

Use Existing Column Values in the SET Clause in MySQL
How To Use Existing Column Values in the SET Clause in MySQL? If a row matches the WHERE clause in a UPDATE statement, existing values in this row can be used in expressions to provide new values in the SET clause. Existing values are represented by column names in the expressions. The tutorial exer... 2018-01-13, 2968🔥, 0💬

Deleting an Existing Row from a Table in MySQL
How To Delete an Existing Row from a Table in MySQL? If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: mysql&gt; INSERT INTO fyi_links (url, id) VALUES ('www.myspace.com', 301);... 2018-01-08, 2967🔥, 0💬

Database in Use When Dropping a Database in SQL Server
Why I am getting this error when dropping a database in SQL Server? If you are trying to drop a database that is in use, you will get an error message like this: 'Cannot drop database "FyiCenterData" because it is currently in use.' Before dropping a database, you must stop all client sessions using... 2016-11-24, 2967🔥, 0💬

What Is a User Account in Oracle
What Is a User Account in Oracle? A user account is identified by a user name and defines the user's attributes, including the following: Password for database authentication Privileges and roles Default tablespace for database objects Default temporary tablespace for query processing work space   ⇒... 2020-07-07, 2965🔥, 0💬

Using User Defined Functions in Expressions in SQL Server
How To Use User Defined Functions in Expressions in SQL Server Transact-SQL? An user defined function must return a value, which can be used in any expression as long as the return value data type matches the expression. To execute a user defined function and use its return value in an expression, y... 2016-12-24, 2965🔥, 0💬

Installing SQL Server 2005 Express Edition in SQL Server
How to install SQL Server 2005 Express Edition in SQL Server? Once you have downloaded SQL Server 2005 Express Edition, you should follow this tutorial to install it on your system: 1. Double click SQLEXPR.EXE. The setup window shows up. 2. Click Next to let the setup program to unpack all files fro... 2016-12-08, 2964🔥, 0💬

Show Execution Path Reports in Oracle
How To Get Execution Path Reports on Query Statements in Oracle? If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON EXPLAIN" command to turn on execution path reports on query statements. The tutorial exercise bellow shows you a good example: SQL&gt; CONN... 2020-06-08, 2961🔥, 0💬

What are Date and Time Data Types in MySQL
What Are Date and Time Data Types in MySQL? MySQL supports the following date and time data types: DATE - A date in the range of '1000-01-01' and '9999-12-31'. Default DATE format is "YYYY-MM-DD". DATETIME - A date with the time of day in the range of '1000-01-01 00:00:00' and '9999-12-31 23:59:59'.... 2018-03-24, 2961🔥, 0💬

<< < … 28 29 30 31 32 33 34 35 36 37 38 … > >>   ∑:1363  Sort:Date

General MySQL Oracle SQL Server