<< < 25 26 27 28 29 30 31 32 33 34 35 > >>   Sort: Date

What Is a RECORD in PL/SQL in Oracle
What Is a RECORD in PL/SQL in Oracle? RECORD is a composite data type in PL/SQL. It can have many fields representing data elements with different data types. Variables of RECORD type can be designed to hold data from database table rows. To use RECORD data type, you need to define a specific RECORD...
2018-09-13, 697👍, 0💬

Turn on Binary Logs in MySQL
How To Turn on Binary Logs in MySQL? If you want MySQL to write binary logs to a file, you can use the "--log-bin=fileBaseName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option: &gt;cd \mysql\bin &gt;mkdir \mysql\logs &gt...
2017-11-29, 697👍, 0💬

Entering Binary String Literals in SQL Server Transact-SQL
How To Enter Binary String Literals in SQL Server Transact-SQL? Binary string long values are normally generated by client applications by reading input channels, like image files. But sometimes, you may need to enter some short binary strings as literals. Binary string literals are entered as a str...
2017-04-22, 697👍, 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.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials
2016-10-16, 697👍, 0💬

Converting Character Strings to Numeric Values in MySQL
How To Convert Character Strings to Numeric Values in MySQL? You can convert character strings to numeric values by using the CAST(string AS DECIMAL) or CAST(string AS SIGNED INTEGER) function as shown in the following examples: SELECT CAST('4123.45700' AS DECIMAL) FROM DUAL; 4123.46 -- Very poor co...
2018-03-28, 696👍, 0💬

What Is an Expression in SQL Server
What Is an Expression in SQL Server Transact-SQL? An expression is a combination of identifiers, values, and operators that SQL Server 2005 can evaluate to obtain a numeric value. A simple expression could be a constant, a function, a column name, a variable, or a subquery without any operators. Com...
2017-04-01, 696👍, 0💬

Adding and Removing Days on Date and Time Values in SQL Server
How To Add or Remove Days on Date and Time Values in SQL Server Transact-SQL? SQL Server 2005 only support two operators on data and time values: + (Add): Adding days to a date and time value. - (Subtract): Removing days from a date and time value. Note that to add or subtract days on a date and tim...
2017-02-22, 696👍, 0💬

SCROLL - Creating Cursors for Backward Scrolling in SQL Server
How To Create a Scrollable Cursor with the SCROLL Option in SQL Server Transact-SQL? SQL Server offers two scrolling option on cursors: 1. FORWARD_ONLY - The cursor can only be scrolled forward with "FETCH NEXT" statements. In another word, you can only loop through the cursor from the first row to ...
2016-10-17, 696👍, 0💬

Fixing INSERT Command Denied Error in MySQL
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT command denied" error is that your user account does not have the INSERT privilege on the table or database. To resolve this error, you need to ask your MySQL DBA to grant you the right privilege. Your DBA ...
2017-10-08, 695👍, 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, 694👍, 0💬

Using Subqueries with the EXISTS Operator in MySQL
How To Use Subqueries with the EXISTS Operator in MySQL? A subquery can be used with the EXISTS operator as "EXISTS (subquery)", which returns true if the subquery returns one or more rows. The following statement is a good example of "EXISTS (subquery)". It returns rows from fyi_links table that th...
2017-09-17, 694👍, 0💬

Generating CREATE TABLE Script on Existing Tables in SQL Server
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an existing table was created, you can use SQL Server Management Studio to automatically generate a "CREATE TABLE" script The following tutorial shows you how to do this: 1. Run SQL Server Management Stud...
2016-11-17, 693👍, 0💬

Experiments of Data Locks in Oracle
How To Experiment a Data Lock in Oracle? If you want to have some experience with data locks, you can create two windows running two SQL*Plus sessions. In session 1, you can run a UPDATE statements to create a data lock. Before committing session 2, switch to session 2, and run a UPDATE statements o...
2019-08-08, 692👍, 0💬

Show All Columns of an Existing Table in MySQL
How To Get a List of Columns in an Existing Table in MySQL? If you have an existing table, but you don't remember what are the columns used in the table, you can use the "SHOW COLUMNS FROM tableName" command to get a list of all columns of the specified table. You can also use the "DESCRIBE tableNam...
2018-03-10, 692👍, 0💬

Using Cursors in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Using Cursors in SQL Server Transact-SQL? I want to loop through rows in a result set. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Using Cursors in SQL Server Transact-SQL. Clear explanati...
2016-10-17, 692👍, 0💬

Differences between NUMBER and BINARY_FLOAT in Oracle
What Are the Differences between NUMBER and BINARY_FLOAT in Oracle? The main differences between NUMBER and BINARY_FLOAT are: NUMBER stores values as fixed-point numbers using 1 to 22 bytes. BINARY_FLOAT stores values as single precision floating-point numbers.   ⇒Understanding SQL Language Basics f...
2020-04-25, 691👍, 0💬

Report View in SQL Developer in Oracle
What Is the Reports View in Oracle SQL Developer in Oracle? The Reports view lets you browse database information that organized by the server as special views. Information can be browsed include: Database parameters Storage information Session information Cursors Data objects User accounts Security...
2018-10-08, 691👍, 0💬

DML Commands Supported in MySQL
How Many SQL DML Commands Are Supported by "mysql" in MySQL? There are 4 SQL Data Manipulation Language (DML) commands that are supported by "mysql". They are listed below with short descriptions: "INSERT INTO tableName ..." - Inserts new data rows into the specified table. "DELETE FROM tableName .....
2018-02-08, 691👍, 0💬

Using Group Functions in the SELECT Clause in MySQL
How To Use Group Functions in the SELECT Clause in MySQL? If group functions are used in the SELECT clause, they will be used on the rows that meet the query selection criteria, the output of group functions will be returned as output of the query. The following select statement returns 3 values cal...
2018-01-06, 691👍, 0💬

Use Existing Column Values in SET Clause in Oracle
How To Use Existing Values in UPDATE Statements in Oracle? 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 columns in the expressions. The tutorial exercise bel...
2020-01-21, 690👍, 0💬

Define an Explicit Cursor in Oracle
How To Define an Explicit Cursor in Oracle? An explicit cursor must be defined in the declaration part of a procedure or function with the CURSOR ... IS statement as shown in the following sample script: DECLARE CURSOR c_list IS SELECT * FROM countries; CURSOR t_list IS SELECT * FROM employees WHERE...
2018-07-22, 690👍, 0💬

Use "IF" Statements with Multiple Conditions in Oracle
How To Use "IF" Statements on Multiple Conditions in Oracle? If you have multiple blocks of codes to be executed based on different conditions, you can use the "IF ... ELSIF" statement. Here is a sample script on IF statements: DECLARE day VARCHAR2; BEGIN day := 'SUNDAY'; IF day = 'THURSDAY' THEN DB...
2018-07-13, 690👍, 0💬

What Are User Privileges in MySQL
What Are User Privileges in MySQL? MySQL offers many user privileges to control user accesses to different functions and data objects. Here are some commonly used privileges: ALL - All privileges. CREATE - Allows the user to use CREATE TABLE commands. ALTER - Allows the user to use ALTER TABLE comma...
2017-12-09, 690👍, 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, 689👍, 0💬

<< < 25 26 27 28 29 30 31 32 33 34 35 > >>   Sort: Date