General MySQL Oracle SQL Server

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

"sys.columns" - Getting a List of Columns in a Table in SQL Server
How To Get a List of Columns using the "sys.columns" View in SQL Server? If you have an existing table, but you don't remember what are the columns defined in the table, you can use the "sys.columns" system view to get a list of all columns of all tables in the current database. In order to a list o... 2016-11-17, 3101🔥, 0💬

Running "mysql" Commands from a Batch File in MySQL
How To Run "mysql" Commands from a Batch File in MySQL? If you have group of "mysql" commands that need to be executed repeatedly, you can put them into a file, and run them from the file in "mysql" batch mode. Here is a batch file, \temp\links.sql, contains following commands: USE test; INSERT INTO... 2018-02-08, 3100🔥, 0💬

What Is SQL Language
What Is SQL Language? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). During the 1970s, a group at IBM's San Jose research center developed a database system "System R" based upon Codd's model. Structured English Query Language ("SEQ... 2017-06-16, 3100🔥, 0💬

Memory Usage of 10g XE Server in Oracle
How Much Memory Your 10g XE Server Is Using in Oracle? Your 10g XE Server is using about 180MB of memory even there is no users on the server. The server memory usage is displayed on your server home page, if you log in as SYSTEM.   ⇒ Start 10g XE Server from Command Line in Oracle ⇐ Start 10g XE S... 2020-10-10, 3099🔥, 0💬

User Account and Schema: One-to-One Relation in Oracle
What Is the Relation of a User Account and a Schema in Oracle? User accounts and schemas have a one-to-one relation. When you create a user, you are also implicitly creating a schema for that user. A schema is a logical container for the database objects (such as tables, views, triggers, and so on) ... 2019-07-30, 3094🔥, 0💬

Show Server Status with "mysqladmin" in MySQL
How To Check Server Status with "mysqladmin" in MySQL? If you want to check the server status by with "mysqladmin", you can following this tutorial example: &gt;cd \mysql\bin &gt;mysqladmin -u root status Uptime: 223 Threads: 1 Questions: 1 Slow queries: 0 Opens: 12 Flush tables: 1 Open tabl... 2018-06-01, 3091🔥, 0💬

Retrieve the Count of Updated Rows in Oracle
How To Retrieve the Count of Updated Rows in Oracle? After running an UPDATE statement, the database server returns a count of updated rows. You can retrieve this count from a special predefined variable called SQL%ROWCOUT, as shown in the following tutorial: CREATE TABLE emp_temp AS SELECT * FROM e... 2018-09-13, 3088🔥, 0💬

Generating CREATE PROCEDURE Scripts on Existing Stored Procedures in SQL Server
How To Generate CREATE PROCEDURE Script on an Existing Stored Procedure in SQL Server Transact-SQL? If you want to know how an existing stored procedure was created, you can use SQL Server Management Studio to automatically generate a "CREATE PROCEDURE" script The following tutorial shows you how to... 2017-01-05, 3081🔥, 0💬

What Is Oracle Database 10g Express Edition in Oracle
What Is Oracle Database 10g Express Edition in Oracle? Based on Oracle Web site: Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that's free to develop, deploy, and distribute; fast to download;... 2020-05-15, 3080🔥, 0💬

Overflow Errors on Converting Big Values to NUMERIC in SQL Server
What Happens When Converting Big Values to NUMERIC Data Types in SQL Server Transact-SQL? If you are converting a numeric expression to a NUMERIC data type and the value is too big for the storage size, you will get an arithmetic overflow error as shown in the following examples: -- Overflow error o... 2017-03-22, 3076🔥, 0💬

EXECUTE - Executing Stored Procedures in SQL Server
How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure created previously, you can use the EXECUTE statement in the following formats: EXEC procedure_name; EXECUTE procedure_name; The key word EXEC is actually optional. So you can execute a stored proced... 2017-01-05, 3074🔥, 0💬

User_Name() - Database Level Security Principal of Your Session in SQL Server
What Is the Security Principal at the Database Level That Represents Your Session in SQL Server? Security principal identifies who you are when you interact with the SQL Server. What can do you at the database solely depends on the security principal that represents you. So it is very important to k... 2016-10-20, 3073🔥, 0💬

What Is Transport Network Substrate in Oracle
What Is Transport Network Substrate (TNS) in Oracle? TNS, Transport Network Substrate, is a foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol.   ⇒ What Is ODBC in Oracle ⇐ What Is SQL*Plus in Oracle ⇑ Oracle Database Basic Conc... 2025-09-30, 3072🔥, 1💬

Converting Binary Strings into Character Strings in SQL Server
Can Binary Strings Be Converted into Character Strings in SQL Server Transact-SQL? Binary strings and character strings are convertible. But there are several rules you need to remember: Binary strings can be converted implicitly to character strings by assignment operations. Binary strings can not ... 2017-02-28, 3071🔥, 0💬

Indexes for the PRIMARY KEY Column in Oracle
What Is an Index Associated with a Constraint in Oracle? An index associated with a constraint because this constraint is required to have an index. There are two types of constraints are required to have indexes: UNIQUE and PRIMARY KEY. When you defines a UNIQUE or PRIMARY KEY constraint in a table... 2019-05-01, 3070🔥, 0💬

Unicode Character Data Types in SQL Server Transact-SQL
What are Unicode character string data types supported in SQL Server Transact-SQL? Unicode character string data types are used to hold Unicode character strings. There are 3 Unicode character string data types supported in SQL Server Transact-SQL: 1. NCHAR (or NATIONAL CHAR, or NATIONAL CHARACTER) ... 2017-04-08, 3068🔥, 0💬

What Is a Connect Identifier in Oracle
What Is a Connect Identifier in Oracle? A "connect identifier" is an identification string of a single set of connection information to a specific target database instance on a specific Oracle server. Connect identifiers are defined and stored in a file called tnsnames.ora located in $ORACLE_HOME/ne... 2020-08-13, 3065🔥, 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, 3061🔥, 0💬

Assign Query Results to Variables in Oracle
How To Assign Query Results to Variables in Oracle? If you want to assign results from SELECT statements to variables, you can use the INTO clause, which an extension of SELECT statements for PL/SQL. The sample code below shows some good example on INTO clause: DECLARE total NUMBER; now DATE; fname ... 2018-09-24, 3060🔥, 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, 3060🔥, 0💬

Privilege to Create Tables in Oracle
What Privilege Is Needed for a User to Create Tables in Oracle? To be able to create tables in a user's own schema, the user needs to have the CREATE TABLE privilege, or the CREATE ANY TABLE privilege, which is more powerful, and allows the user to create tables in other user's schema. The following... 2019-06-29, 3050🔥, 0💬

What Is a Server Parameter File in Oracle
What Is a Server Parameter File in Oracle? A server parameter file is a binary file that acts as a repository for initialization parameters. The server parameter file can reside on the machine where the Oracle database server executes. Initialization parameters stored in a server parameter file are ... 2020-07-07, 3046🔥, 0💬

Connect to MySQL Server without Port Number in MySQL
How To Connect to a MySQL Server with Default Port Number in MySQL? If you want to connect a MySQL server with default port number, you can use the "mysql_connect($server)" function, where $server is the host name or IP address where the MySQL server is running. If successful, mysql_connect() will r... 2017-07-30, 3043🔥, 0💬

What Is NULL Value in Oracle
What Is NULL Value in Oracle? NULL is a special value representing "no value" in all data types. NULL can be used on in operations like other values. But most operations has special rules when NULL is involved. The tutorial exercise below shows you some examples: SET NULL 'NULL'; -- Make sure NULL i... 2019-12-02, 3042🔥, 0💬

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

General MySQL Oracle SQL Server