<< < 5 6 7 8 9 10 11 12 13 14 15 > >>   Sort: Date

What Is Column in MySQL
What Is Column in MySQL? A column defines one piece of data stored in all rows of the table.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials
2017-07-15, 781👍, 0💬

Create an Array in PL/SQL in Oracle
How To Create an Array in PL/SQL in Oracle? If you want create an array data structure, you can use the collection type VARRAY. VARRAY stands for Variable Array. Here is a sample script on how to use VARRAY: SQL&gt; set serveroutput on; SQL&gt; DECLARE 2 TYPE list IS VARRAY(3) OF VARCHAR(16)...
2019-03-08, 780👍, 0💬

Show Storage Engines Supported in MySQL in MySQL
How To See Which Storage Engines Are Supported in Your MySQL Server in MySQL? If you want to know exactly which storage engines are supported in your MySQL server, you can run the "SHOW ENGINES" command as shown in the tutorial example below: mysql&gt; SHOW ENGINES; +------------+---------+-----. ..
2017-08-08, 780👍, 0💬

Query with an Inner Join in Oracle
How To Write a Query with an Inner Join in Oracle? If you want to query from two tables with an inner join, you can use the INNER JOIN ... ON clause in the FROM clause. The following query returns output with an inner join from two tables: employees and departments. The join condition is that the de...
2019-10-27, 778👍, 0💬

Execute a Stored Procedure in Oracle
How To Execute a Stored Procedure in Oracle? If you want to execute a stored procedure, you can use the EXECUTE statement. The example script below shows how to executes a stored procedure: SQL&gt; set serveroutput on; SQL&gt; CREATE PROCEDURE Greeting AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LINE('Welc...
2018-11-11, 778👍, 0💬

Start and End of Statement in SQL Server Transact-SQL
How to start and end a statement in SQL Server Transact-SQL? Here are some simple rules about writing statements in SQL Server Transact-SQL: A Transact-SQL statement must be started with a pre-defined statement keyword. A Transact-SQL statement must be ended with a new line (/n) or a semicolon (;) c...
2017-05-29, 778👍, 0💬

Character Strings and Binary Strings in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Character Strings and Binary Strings in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Character Strings and Binary Strings in SQL Server Transact-SQL. Clear answers ...
2017-03-11, 778👍, 0💬

Introduction to Oracle PL/SQL
Where to find answers to frequently asked questions about Oracle PL/SQL in general? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team about Oracle PL/SQL in general. This FAQ can also be used as learning tutorials on creating procedures, executing proc...
2019-03-27, 777👍, 0💬

Formal Parameters and Actual Parameters in Oracle
What Is the Difference between Formal Parameters and Actual Parameters in Oracle? Formal parameter and actual parameter are two different terms related parameters used in the procedures and functions: A formal parameter is a term used to refer to a parameter defined in the procedure or function decl...
2018-03-18, 776👍, 0💬

Understanding PL/SQL Language Basics
Where to find answers to frequently asked questions on Understanding PL/SQL Language Basics? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Understanding PL/SQL Language Basics. It can also be used as learning tutorials on defining variables, ass...
2018-12-26, 775👍, 0💬

Differences of DECIMAL and FLOAT in SQL Server
What Are the Differences between DECIMAL and FLOAT in SQL Server Transact-SQL? DECIMAL and FLOAT are both used to store numerical values. But they have the following main differences: DECIMAL(p,s) stores values with the decimal point fixed at the position of s (scale) digits from the right. The tota...
2017-04-15, 775👍, 0💬

What Is a SQL*Loader Control File in Oracle
What Is a SQL*Loader Control File in Oracle? A SQL*Loader control file a text that defines how data files should be loaded into the database. It allows you to specify: Where is the input data file. The format of the input date file. The target table where the data should be loaded. How input data fi...
2016-11-27, 775👍, 0💬

Return Top 5 Rows in Oracle
How To Return Top 5 Rows in Oracle? If you want the query to return only the first 5 rows, you can use the pseudo column called ROWNUM in the WHERE clause. ROWNUM contains the row number of each returning row from the query. The following statement returns the first 5 rows from the employees table: ...
2019-09-16, 774👍, 0💬

Finding the Login Name Linked to a Given User Name in SQL Server
How To Find the Login Name Linked to a Given User Name in SQL Server? If you know a user name in a database and you want to find out which login name is linked this user name, you need to check the Security ID (SID) of the user name based on the following rules: Each login name is associated a uniqu...
2017-08-25, 774👍, 0💬

"FULL OUTER JOIN ... ON" - Writing Queries with Full Outer Joins in SQL Server
How To Write a Query with a Full Outer Join in SQL Server? If you want to query from two tables with a full outer join, you can use the FULL OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a full outer join from two tables: fyi_links and fyi_rates. The join condi...
2016-10-29, 774👍, 0💬

Database Table: Rows of Columns in Oracle
What Is a Database Table in Oracle? A database table is a basic unit of data logical storage in an Oracle database. Data is stored in rows and columns. You define a table with a table name, such as employees, and a set of columns. You give each column a column name, such as employee_id, last_name, a...
2019-06-01, 773👍, 0💬

Call a Stored Function in Oracle
How To Call a Stored Function in Oracle? A stored function can be called as part of expression in any PL/SQL statement. One simplest way to call a stored function is to a dummy SELECT statement as shown in the following tutorial script using SQL*Plus: SQL&gt; CREATE OR REPLACE FUNCTION GET_SITE ...
2018-10-26, 773👍, 0💬

Use DML Statements in PL/SQL in Oracle
Can DML Statements Be Used in PL/SQL in Oracle? Yes, you can run almost any DML statements in PL/SQL directly. To manipulate Oracle database data you can include INSERT, UPDATE, and DELETE statements, directly in PL/SQL programs, without any special notation, as shown in the following sample code: (...
2018-10-13, 773👍, 0💬

How do I call MySQL SP from oracle using HS link ?
How do I call MySQL Stored Procedure from oracle using HS link ? HS link is correct and I can get the tables data just by adding '@' at the end of the table name ,but I can't call the SP same way ! Help please.
2017-01-11, 773👍, 0💬

Approximate Numeric Literals in SQL Server Transact-SQL
What are approximate numeric literals supported in SQL Server Transact-SQL? Approximate numeric literals in Transact-SQL are numbers written in scientific notation formats. Approximate numeric literals are used to provide values to approximate numeric variables or table columns like LOAT(24), DOUBLE...
2017-05-05, 772👍, 0💬

Use Multiple Columns in GROUP BY in Oracle
Can Multiple Columns Be Used in GROUP BY in Oracle? You can use multiple columns in the GROUP BY clause as shown in the following example. It returns how many employees are having the same salary in each department: SQL&gt; SELECT department_id, salary, count(*) 2 FROM employees GROUP BY departm...
2019-10-27, 770👍, 0💬

What Is the Implicit Cursor in Oracle
What Is the Implicit Cursor in Oracle? There is only one implicitly cursor in a session. The implicit cursor is the cursor automatically defined by PL/SQL for you. Whenever a SQL statement is executed, this cursor will be assigned to represent the execution of this statement. This implicit cursor is...
2018-02-01, 767👍, 0💬

Define DSN with ODBC Manager in Oracle
How To Define a Data Source Name (DSN) in ODBC Manager in Oracle? DSN (Data Source Name) is an ODBC connection identifier for Windows applications. Here is how you can define a DSN on your Windows system: Go to Control Panel. Go to Administrative Tools. Run Data Sources (ODBC). Go to System DSN tab....
2016-10-15, 767👍, 0💬

Connect to Local 10g XE Server in Oracle
How To Connect to a Local Oracle 10g XE Server in Oracle? If you have your Oracle 10g XE server running on your local machine, you can connect your Oracle SQL Developer to the server with the following steps: Start Oracle SQL Developer Right-click on Connections Select New Database Connection Enter ...
2019-02-05, 765👍, 0💬

<< < 5 6 7 8 9 10 11 12 13 14 15 > >>   Sort: Date