<< < 1 2 3 4 5 6 7 8 9 10 11 > >>   ∑:1278  Sort:Date

Set Up SQL*Plus Output Format in Oracle
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus, you need to set up your SQL*Plus output formatting parameter properly. The following SQL*Plus commands shows you some examples: COLUMN id FORMAT 9999; COLUMN url FORMAT A24; COLUMN notes FORMAT A12;...
2020-01-29, 3066🔥, 0💬

What Is a Dynamic Performance View in Oracle
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are maintained by the database server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuously updated while a database is open an...
2020-10-26, 3061🔥, 1💬

💬 2019-10-16 Aninda: Best tutorial

What Is an Oracle Instance in Oracle
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes....
2020-11-11, 3022🔥, 0💬

Connect to Oracle Server as SYSDBA in Oracle
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the Oracle server as an administrator is to use SQL*Plus. You need to run SQL*Plus with /nolog option and use the CONNECT with blank user name, blank password and AS SYSDBA option. Here is a sample sessi...
2019-04-03, 2981🔥, 0💬

dba.FYIcenter.com Links
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutorials Transact-SQL Tutorials DBA Articles Site Map Other Resources: SQA (Software QA) Developer Resources DBA Resources Windows Tutorials Java JAR Files DLL Files File Extensions Security Certificates Re...
2023-12-07, 2974🔥, 0💬

What Is SQL*Plus in Oracle
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user interface.   ⇒ What Is Transport Net...
2020-05-29, 2949🔥, 2💬

💬 2020-05-29 FYIcenter.com: @Frank, Yes. SQL*Plus offers you query tools to connect to remote Oracle servers.

💬 2020-05-27 Frank Jam: What the usage for SQL*Plus? Query tools

BEGIN ... END Statement Blocks in SQL Server Transact-SQL
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into a statement block with BEGIN and END key words in Transact-SQL using these syntaxes BEGIN statement_1 statement_2 ... END Statement blocks are mainly used with logical conditions and control-of-flow ...
2017-01-11, 2933🔥, 0💬

Run SQL Commands in SQL*Plus in Oracle
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you need to enter the SQL command in one or more lines and terminated with (;). The tutorial exercise below shows a good example: SQL&gt; SELECT 'Welcome!' FROM DUAL; 'WELCOME -------- Welcome! SQL&g...
2020-08-03, 2916🔥, 1💬

💬 2020-08-03 chelseaclark: β-Arrestin recruitment is a ubiquitous mechanism of negative regulation of GPCR signaling, which has been demonstrated for almo...

"ALTER LOGIN" - Disabling a Login Name in SQL Server
How To Disable a Login Name in SQL Server? If you want temporarily disable a login name, you can use the "ALTER LOGIN" statement with a DISABLE keyword. If you want to enable it later on, you can use the ENABLE keyword. The tutorial exercise below shows how to disable and enable login name "Dba_Logi...
2016-10-19, 2896🔥, 0💬

ISNULL() - Replacing NULL Values in Expressions in SQL Server
How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned from previous tutorials, NULL values presented in expressions will cause the final results to be NULL. Sometimes, you want NULL values to be replaced with some default values, like 0, '', or 'NULL', s...
2017-02-03, 2890🔥, 0💬

Dispaly Part Time in Days, Hours and Minutes in MySQL
How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are displaying past times in days, hours and minutes. If you want to do this yourself, you can use the TIMEDIFF() SQL function. Note that the TIMEDIFF() function can only handle time range within 839 hou...
2017-06-23, 2874🔥, 0💬

Presenting a Past Time in Hours, Minutes and Seconds in MySQL
How To Present a Past Time in Hours, Minutes and Seconds in MySQL? If you want show an article was posted "n hours n minutes and n seconds ago", you can use the TIMEDIFF(NOW(), pastTime) function as shown in the following tutorial exercise: SELECT TIMEDIFF(NOW(), '2006-07-01 04:09:49') FROM DUAL; 06...
2017-12-26, 2871🔥, 0💬

Install Oracle Database 10g XE in Oracle
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, OracleXEUniv.exe, the install wizard starts. It will guide you to finish the installation process. You should take notes about: The SYSTEM password you selected: fyicenter. Database server port: 1521. Da...
2024-05-01, 2845🔥, 1💬

What Is Open Database Communication (ODBC) in Oracle
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle offers ODBC drivers to allow Windows applications to connect...
2016-10-15, 2828🔥, 0💬

Ways to Get the Current Time in MySQL
How Many Ways to Get the Current Time in MySQL? There are 8 ways to get the current time: SELECT NOW() FROM DUAL; 2006-07-01 10:02:41 SELECT CURRENT_TIME() FROM DUAL; 10:02:58 SELECT SYSDATE() FROM DUAL; 2006-07-01 10:03:21 mysql&gt; SELECT CURRENT_TIMESTAMP() FROM DUAL; 2006-07-01 10:04:03 SELE...
2018-03-13, 2823🔥, 0💬

Define External Table in a Text File in Oracle
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to create external tables. But you need to use ORGANIZATION EXTERNAL clause to specify the external file location and the data access driver. The tutorial exercise below shows you how to define an extern...
2016-10-19, 2820🔥, 1💬

💬 2016-10-19 Randy: Great example, Thanks!

Using INSERT, UPDATE and DELETE Statements in SQL Server
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Using INSERT, UPDATE and DELETE Statements in SQL Server. Clear answers are provided w...
2016-11-03, 2813🔥, 0💬

DROP_EXISTING - Recreating an Existing Index in SQL Server
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing index, you can use the "DROP INDEX" statement to drop the index first. Then use the "CREATE INDEX" statement to create it again with the new definition. But you can also combine those two statements ...
2016-11-08, 2809🔥, 0💬

What Is a Database Schema in Oracle
What Is a Database Schema in Oracle? A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with SQL and include: tables, views, ...
2020-11-22, 2799🔥, 0💬

Query Multiple Tables Jointly in MySQL
How To Query Multiple Tables Jointly in MySQL? If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join. Assuming that you have 3 tables in a forum system: "users" for user profile, "forums" for forums information, and ...
2017-06-23, 2791🔥, 0💬

sys.objects - Listing All User Defined Functions in SQL Server
How To List All User Defined Functions in the Current Database in SQL Server Transact-SQL? If you want to see a list of all user defined functions in your current database, you can use the system view, sys.objects as shown in this tutorial exercise: USE FyiCenterData; GO -- Number of Sundays in a gi...
2016-12-24, 2786🔥, 0💬

Introduction to Date and Time Handling in MySQL
Where to find answers to frequently asked questions on Introduction to Date and Time Handling in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Introduction to Date and Time Handling in MySQL. Clear answers are provided with tutorial exerc...
2021-08-04, 2776🔥, 2💬

💬 2021-03-13 Strain John: Hey, u gave us good information. It is easy to understand for everyone and also having good content. I appreciated your afforts ...

Understanding SQL Transaction Management in Oracle
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Transaction Management in Oracle. Clear answers are provided with tutorial exercises on starting and e...
2019-09-16, 2768🔥, 0💬

Missing .NET Framework 2.0 for SQL Server 2005 Express Edition in SQL Server
Why I am getting "The Microsoft .Net Framework 2.0 in not installed" message in SQL Server? When you try to install SQL Server 2005 Express Edition, you may get a Microsoft SQL Server 2005 Setup error box with this message: "The Microsoft .Net Framework 2.0 in not installed. Please install before ru...
2016-12-08, 2751🔥, 0💬

<< < 1 2 3 4 5 6 7 8 9 10 11 > >>   ∑:1278  Sort:Date