General MySQL Oracle SQL Server

<< < … 21 22 23 24 25 26 27 28 29 30 31 … > >>   ∑:1363  Sort:Date

Define and Use Table Alias Names in Oracle
How To Define and Use Table Alias Names in Oracle? When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names as shown in the following select statement: SQL&gt; SELECT e.first_name, e.last_name, d.department_name FROM employees e ... 2019-10-27, 3385🔥, 0💬

What Is a Result Set Object in MySQL
What Is a Result Set Object in MySQL? A result set object is a logical representation of data rows returned by mysql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in the result set. Once you get a result set object, you can us... 2017-09-20, 3384🔥, 0💬

Revoking User Privileges in MySQL
How To Revoke User Privileges in MySQL? If your want remove some granted user privileges, you can use the "REVOKE privilegeName ..." command. You can only revoke privileges in the same way as they were granted. For example, you can not revoke a privilege on a specific database, if that privilege was... 2017-08-21, 3384🔥, 0💬

Understanding SQL DML Statements for Oracle
Where to find answers to frequently asked questions on SQL DML Statements for Oracle. I want insert and delete data in tables. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL DML Statements for Oracle. Clear answers are provided with tutorial ... 2020-02-07, 3383🔥, 0💬

Retrieve Data from a Cursor to a RECORD in Oracle
How To Retrieve Data from a Cursor to a RECORD in Oracle? If you have a cursor opened ready to use, you can also use the FETCH statement to retrieve data from the cursor into a RECORD variable as shown in the tutorial exercise below: CREATE OR REPLACE PROCEDURE FYI_CENTER AS CURSOR t_list IS SELECT ... 2018-07-22, 3383🔥, 0💬

What Is CSV in MySQL
What Is CSV in MySQL? CSV (Comma Separated Values) is a file format used to store database table contents, where one table row is stored as one line in the file, and each data field is separated with comma.   ⇒ What Is Transaction in MySQL ⇐ What Is BDB in MySQL ⇑ Database Basics and Terminologies ... 2016-10-16, 3381🔥, 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, 3380🔥, 0💬

Show All Indexes in Your Schema in Oracle
How To List All Indexes in Your Schema in Oracle? If you log in with your Oracle account, and you want to get a list of all indexes in your schema, you can get it through the USER_INDEXES view with a SELECT statement, as shown in the following SQL script: SELECT index_name, table_name, uniqueness FR... 2019-05-01, 3379🔥, 0💬

Define a Cursor Variable in Oracle
How To Define a Cursor Variable in Oracle? To define cursor variable, you must decide which REF CURSOR data type to use. There are 3 ways to select a REF CURSOR data type: Define your own specific REF CURSOR types using the TYPE ... RETURN statement. Define your own generic REF CURSOR type using the... 2018-07-18, 3379🔥, 0💬

"CREATE LOGIN" Statements - Creating a Login in SQL Server
How to create a login to access the database engine using "CREATE LOGIN" statements in SQL Server? This is the first 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 crea... 2016-12-02, 3378🔥, 0💬

What Is "mysqlimport" Command in MySQL
What Is "mysqlimport" in MySQL? "mysqlimport" - A command-line interface for administrators or end users to load data files into tables program tool to load data into tables. Here is a sample commands supported by "mysqlimport": "mysqlimport databaseName fileName" - Imports the data from the specifi... 2018-05-19, 3377🔥, 0💬

Incrementing a Date by 1 in MySQL
How To Increment Dates by 1 in MySQL? If you have a date, and you want to increment it by 1 day, you can use the DATE_ADD(date, INTERVAL 1 DAY) function. You can also use the date interval add operation as "date + INTERVAL 1 DAY". The tutorial exercise below gives you some good examples: SELECT DATE... 2017-12-26, 3374🔥, 0💬

Using ORDER BY with UNION Operators in SQL Server
How To Use ORDER BY with UNION Operators in SQL Server? If you need to sort the output from two queries grouped together with a UNION operator, you need to apply the ORDER BY clause at the group level, not at the subquery level. Note that SQL Server and MySQL react differently to the ORDER BY clause... 2016-10-26, 3374🔥, 0💬

Modes of Data Dump Export and Import in Oracle
What Are Data Pump Export and Import Modes in Oracle? Data Pump export and import modes are used to determine the type and portions of database to be exported and imported. Oracle 10g supports 5 export and import modes: Full: Exports and imports a full database. Use the FULL parameter to specify thi... 2016-10-15, 3373🔥, 0💬

Performing Comparison on Date and Time Values in SQL Server
How To Perform Comparison on Date and Time Values in SQL Server Transact-SQL? Comparison operations on date and time values can be performed in the same way as numeric values. The comparison rule is simple: a date and time value in the future has a greater value than a date and time value in the pas... 2017-01-21, 3371🔥, 0💬

Rebuild an Index in Oracle
How To Rebuild an Index in Oracle? If you want to rebuild an index, you can use the "ALTER INDEX ... REBUILD statement as shown in the following SQL script: SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'EMPLOYEES'; INDEX_NAME TABLE_NAME UNIQUENES -------------------... 2019-04-17, 3366🔥, 0💬

Deleting Multiple Rows from a Table in MySQL
How To Delete Multiple Rows from a Table in MySQL? You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the fyi_links table: mysql&gt; SELECT id, url, notes, coun... 2018-01-08, 3366🔥, 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, 3365🔥, 0💬

Introduction to Oracle SQL Developer
Where to find answers to frequently asked questions on Introduction to Oracle SQL Developer? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Introduction to Oracle SQL Developer: This FAQ can also be used as learning tutorials on SQL statement exe... 2019-02-18, 3363🔥, 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, 3363🔥, 0💬

Grant CREATE SESSION Privilege in Oracle
How To Grant CREATE SESSION Privilege to a User in Oracle? If you want give a user the CREATE SESSION privilege, you can use the GRANT command. The following tutorial exercise shows you how to grant DEV the privilege to connect to the server: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/f... 2019-07-09, 3362🔥, 0💬

Connect to MySQL Server with User Account in MySQL
How To Connect to MySQL Server with User Accounts in MySQL? If you want to connect a MySQL server with user account name and password, you need to call mysql_connect() with more parameters like this: $con = mysql_connect($server, $username, $password); If your MySQL server is provided by your Intern... 2017-11-25, 3362🔥, 0💬

Determining Data Types of View Columns in SQL Server
How Column Data Types Are Determined in a View in SQL Server? When you define a view, its columns are defined through a list of expressions in the underlying SELECT statement. Their data types will be determined implicitly by the expressions. For example, if the column expression is a column name of... 2016-11-03, 3362🔥, 0💬

Name Query Output Columns in Oracle
How To Name Query Output Columns in Oracle? Each column in the query output has a default name. If you don't like the default name, you can specify a new name for any column in the query output by using the AS clause. The following statement shows you a good example: SQL&gt; SELECT department_id... 2019-09-27, 3360🔥, 2💬

💬 2019-09-19 Aninda mahadev: Good Tutorial!!!

<< < … 21 22 23 24 25 26 27 28 29 30 31 … > >>   ∑:1363  Sort:Date

General MySQL Oracle SQL Server