General MySQL Oracle SQL Server

<< < … 9 10 11 12 13 14 15 16 17 18 19 … > >>   ∑:1351  Sort:Date

Selecting Some Specific Columns from a Table in SQL Server
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly tell the query to return some specific columns, you can specify the column names in the SELECT clause. The following select statement returns only three columns, "id", "created" and "url" from the table... 2016-10-26, 2969🔥, 0💬

"DISABLE TRIGGER" - Disabling Triggers in SQL Server
How To Disable Triggers using "DISABLE TRIGGER" in SQL Server? If want to stop the execution of an existing trigger temporarily, you can use the "DISABLE TRIGGER" statement to disable it. The disabled trigger will be kept in the database. If you want to resume the execution of a disabled trigger, yo... 2016-10-24, 2969🔥, 0💬

Disk Space Needed for an Export Job in Oracle
How To Estimate Disk Space Needed for an Export Job in Oracle? If you just want to know how much disk space for the dump without actually exporting any data, you can use the ESTIMATE_ONLY=y parameter on the expdp command. The following tutorial exercise shows you how a system user wants to see the d... 2016-10-15, 2969🔥, 0💬

Statement Batch in SQL Server Transact-SQL
What is statement batch in SQL Server Transact-SQL? A statement batch is a group of one or more Transact-SQL statements sent at the same time from an application to SQL Server for execution. SQL Server compiles the statements of a batch into a single executable unit, called an execution plan. The st... 2017-05-29, 2962🔥, 0💬

Insert Multiple Rows with 1 INSERT Statement in Oracle
How To Insert Multiple Rows with One INSERT Statement in Oracle? If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the target table. The following tutorial exercise gives a good ex... 2020-01-29, 2958🔥, 0💬

What Is an Initialization Parameter File in Oracle
What Is an Initialization Parameter File in Oracle? An initialization parameter file is a text file that contains a list of initialization parameters. The file should be written in the client's default character set. Sample initialization parameter files are provided on the Oracle distribution mediu... 2020-07-07, 2956🔥, 0💬

Run SQL*Plus Commands in SQL Developer in Oracle
How To Run SQL*Plus Commands in SQL Developer in Oracle? Most of the time, you only run SQL statements in SQL Worksheet, the SQL statement area. But you can also run some SQL*Plus commands in SQL Worksheet. The example below shows you how to run the DECRIBE command in SQL Developer: Go to SQL Worksh... 2018-10-08, 2956🔥, 0💬

Decrementing a Date by 1 in MySQL
How To Decrement Dates by 1 in MySQL? If you have a date, and you want to decrement it by 1 day, you can use the DATE_SUB(date, INTERVAL 1 DAY) function. You can also use the date interval subtraction operation as "date - INTERVAL 1 DAY". The tutorial exercise below gives you some good examples: SEL... 2017-12-26, 2955🔥, 0💬

What Are Named Parameters in Oracle
What Are Named Parameters in Oracle? Named parameters are actual parameters specified not by position but by providing formal parameter names when calling the procedure or function. The main advantage of named parameters is that the caller don't have to remember the position of each parameter. But t... 2018-10-13, 2953🔥, 0💬

Built-in Internal User Accounts in Oracle
What Are Internal User Account in Oracle? An internal user account is a system predefined user account. Oracle 10g XE comes with a number of internal accounts: SYSTEM - This is the user account that you log in with to perform all administrative functions other than starting up and shutting down the ... 2019-07-21, 2952🔥, 0💬

Understanding SQL Language Basics for Oracle
Where to find answers to frequently asked questions on SQL Language Basics for Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Language Basics for Oracle. Clear answers are provided with tutorial exercises on data types, data literals,... 2020-05-29, 2944🔥, 0💬

Data Literals in SQL Server Transact-SQL
Where to find answers to frequently asked questions on data literals in Microsoft SQL Server Transact-SQL? I am new to Transact-SQL and SQL Server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team on data literals in Microsoft SQL Server Transact-SQL: Con... 2017-05-20, 2940🔥, 0💬

Collation - Character Code Page in SQL Server Transact-SQL
What Is a Collation in SQL Server Transact-SQL? A collation in Transact-SQL is a set of specifications defining a character set and its sorting rules. SQL Server support a large number of built-in collations. For example: Albanian_CI_AI_KS_WS - Albanian, case-insensitive (CI), accent-insensitive (AI... 2017-05-13, 2928🔥, 0💬

Improving the Trigger to Handle NULL Values in SQL Server
How To Improve the Trigger to Handle NULL Values in SQL Server? When a NULL value is concatenated with a string, the result will be a null value. So if you want the trigger to properly report NULL values, you need to enhance the trigger as shown in the following tutorial example: USE FyiCenterData; ... 2016-10-24, 2925🔥, 0💬

Perform a Full Database Export in Oracle
How To Do a Full Database Export in Oracle? If you are ready to do a full database export, you can use the FULL=y parameter on the expdp command, as shown in the following tutorial exercise: &gt;expdp SYSTEM/fyicenter FULL=y ESTIMATE_ONLY=y Starting "SYSTEM"."SYS_EXPORT_FULL_01": SYSTEM/**** FUL... 2016-10-15, 2925🔥, 0💬

Create an Initialization Parameter File in Oracle
How To Create an Initialization Parameter File in Oracle? This is Step 3. To run an Oracle database as an Oracle instance, you need to create an initialization parameter file, which contains a set of initialization parameters. The easiest way to create an initialization parameter file to copy from t... 2019-04-03, 2919🔥, 0💬

Transaction Commit When DDL Statement Executed in Oracle
What Happens to the Current Transaction If a DDL Statement Is Executed in Oracle? If a DDL statement is executed, the current transaction will be committed and ended. All the database changes made in the current transaction will become permanent. This is called an implicit commit by a DDL statement.... 2019-09-04, 2918🔥, 0💬

Help at the SQL Prompt in Oracle
How To Get Help at the SQL Prompt in Oracle? Once SQL*Plus is started, you will get a SQL prompt like this: SQL&gt;. This where you can enter commands for SQL*Plus to run. To get help information at the SQL prompt, you can use the HELP command as shown in the following tutorial example: SQL&... 2020-08-25, 2912🔥, 0💬

sys.triggers - Listing All Triggers in the Database in SQL Server
How To List All Triggers in the Database with sys.triggers in SQL Server? If you want to list all triggers defined in the current database, you can use the catalog view, sys.triggers, as shown in the following tutorial example: USE FyiCenterData; GO CREATE TRIGGER new_user ON fyi_users AFTER INSERT ... 2016-10-25, 2912🔥, 0💬

"mysql" Command Line Arguments in MySQL
What Are the "mysql" Command Line Arguments in MySQL? "mysql" supports only one optional command line argument, "database". But "mysql" allows the operating system to redirect input and output streams at the command line level. Here are some good examples: "mysql databaseName" - Starts "mysql" in in... 2018-04-28, 2911🔥, 0💬

Analyze Tables with "mysqlcheck" Command in MySQL
How To Analyze Tables with "mysqlcheck" in MySQL? If you want analyze tables with "mysqlcheck", you need to use the "--analyze" option. The following tutorial exercise shows you how to analyze all tables in "mysql" database: &gt;cd \mysql\bin &gt;mysqlcheck -u root --analyze mysql mysql.colu... 2018-02-28, 2904🔥, 0💬

UPDATE Using Data from Other Tables in MySQL
How To Use Values from Other Tables in UPDATE Statements in MySQL? If you want to update values in one table with values from another table, you can use a subquery as an expression in the SET clause. The subquery should return only one row for each row in the update table that matches the WHERE clau... 2018-01-13, 2904🔥, 0💬

"DROP USER" - Deleting a Database User in SQL Server
How To Delete an Existing Database User in SQL Server? If you don't want to keep a database user any more, you should delete the user by using the "DROP USER" statement. This tutorial exercise shows how to delete "Dba_User": -- Login with "sa" USE FyiCenterData; GO DROP USER Dba_User; GO -- List all... 2022-01-24, 2903🔥, 0💬

Creating Oracle PL/SQL Procedures and Functions
Where to find answers to frequently asked questions on Creating Oracle PL/SQL Procedures and Functions? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Creating Oracle PL/SQL Procedures and Functions. It can also be used as learning tutorials on c... 2018-01-27, 2903🔥, 0💬

<< < … 9 10 11 12 13 14 15 16 17 18 19 … > >>   ∑:1351  Sort:Date

General MySQL Oracle SQL Server