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

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, 973👍, 0💬

"DECLARE ... CURSOR" - Declaring Cursor Objects in SQL Server
How To Declare a Cursor with "DECLARE ... CURSOR" in SQL Server Transact-SQL? If you want to use a cursor to represent the result set of a query, you need to define a cursor name with a SELECT sub-statement using the "DECLARE ... CURSOR" statement using the following syntax format: DECLARE cursor_na...
2016-10-17, 970👍, 0💬

Create a Server Parameter File in Oracle
How To Create a Server Parameter File in Oracle? This is Step 5. The initialization parameter file is good to get an Oracle database instance started. But it is not ideal run an instance as production. You need to convert the initialization parameter file into a Server Parameter File (SPFile) using ...
2018-05-08, 958👍, 0💬

General Questions on Microsoft SQL Server Transact-SQL
Where to find answers to frequently asked questions in general areas of Microsoft SQL Server Transact-SQL? I am new to Transact-SQL. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team in general areas of Microsoft SQL Server Transact-SQL: What Is SQL Langua...
2017-06-16, 956👍, 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, 956👍, 0💬

What Is SQL*Loader in Oracle
What Is SQL*Loader in Oracle? SQL*Loader is a database tool that allows to load data from external files into database tables. SQL*Loader is available as part of the free Oracle 10g Expression Edition. It has some interesting features as: Can load data from multiple data files into multiple tables i...
2018-06-12, 952👍, 0💬

sys.sql_modules - Getting Trigger Definitions Back in SQL Server
How To Get the Definition of a Trigger Back in SQL Server? If you want get the definition of an existing trigger back from the SQL Server, you can use the catalog view called sys.sql_modules, which stores definitions of views, stored procedures, and triggers. The sys.sql_modules holds trigger defini...
2016-10-24, 952👍, 0💬

"ALTER TABLE ... DROP COLUMN" - Deleting Existing Columns in SQL Server
How To Delete an Existing Column in a Table with "ALTER TABLE ... DROP COLUMN" in SQL Server? If you have an existing column in a table and you do not need that column any more, you can delete it with "ALTER TABLE ... DROP COLUMN" statement. Here is a tutorial script to delete an existing column: AL...
2016-11-17, 942👍, 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, 938👍, 0💬

Assign Debug Privilege to a User in Oracle
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the session must be connected with a user who has debug privileges. The following script shows you how to assign debug privileges: Connect to the default database, XE, as SYSTEM. Run "GRANT debug any pro...
2019-01-12, 936👍, 0💬

Versions of SQL Server Transact-SQL
How do I tell what version of Transact-SQL my SQL Server is using? The Transact-SQL version is the same as the SQL Server. You can determine the SQL Server version using the following Transact-SQL statement: SELECT @@version ------------------------------ ------------------------------ ------------Mi...
2017-06-16, 933👍, 0💬

Drop a Stored Procedure in Oracle
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't want it any more, you can remove it from the database by using the DROP PROCEDURE statement as shown in the following script example: SQL&gt; CREATE PROCEDURE Greeting AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LI...
2018-11-11, 931👍, 0💬

Default Collation in SQL Server Transact-SQL
How To Find Out What Is the Default Collation in SQL Server Transact-SQL? The default collation of a database comes from the server if you are not using the COLLATE clause in the CREATE DATABASE statement. If you are not using the COLLATE clause for character string column, it will use the default c...
2017-05-13, 927👍, 0💬

Create a Stored Procedure in Oracle
How To Create a Stored Procedure in Oracle? A stored procedure is a procedure with a specified name and stored into the current database. If you want to create a stored procedure, you can use the CREATE PROCEDURE statement. The example script below creates a stored procedure: SQL&gt; CREATE PROC...
2018-11-11, 925👍, 0💬

"ALTER INDEX ... REBUILD" - Defragmenting Indexes in SQL Server
How To Rebuild Indexes with ALTER INDEX ... REBUILD in SQL Server? When an index is defragmented to a large percentage, like &gt; 30%, you can use the "ALTER INDEX ... REBUILD" statement to rebuild the index. Here is a tutorial exercise on rebuilding indexes: USE FyiCenterData; GO UPDATE fyi_lin...
2016-11-08, 925👍, 0💬

Change Transaction Isolation Level in MySQL
How To View and Change the Current Transaction Isolation Level in MySQL? If you want to view or change the current transaction isolation level, you can use the following commands: SELECT @@TX_ISOLATION FROM DUAL; -- Viewing the current transaction isolation level. SET TRANSACTION ISOLATION LEVEL lev...
2017-08-08, 924👍, 0💬

Pass Parameters to Procedures in Oracle
How To Pass Parameters to Procedures in Oracle? Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this: SQL&gt; CREATE OR REPLACE PROC...
2018-11-11, 923👍, 0💬

Verifying a User Name with SQLCMD Tool in SQL Server
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in a database is probably to use the SQLCMD tool. You can connect to the server, select the database, and check which user name is linked the current login name as shown below. Start a command window and...
2017-08-25, 920👍, 0💬

Date and Time Interval Literals in Oracle
How To Write Date and Time Interval Literals in Oracle? Date and time interval literals can coded as shown in the following samples: SELECT DATE '2002-10-03' + INTERVAL '123-2' YEAR(3) TO MONTH FROM DUAL -- 123 years and 2 months is added to 2002-10-03 03-DEC-25 SELECT DATE '2002-10-03' + INTERVAL '...
2020-03-25, 916👍, 0💬

"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, 913👍, 0💬

"sp_rename ... 'OBJECT'" - Renaming Existing Tables in SQL Server
How to rename an existing table with the "sp_rename" stored procedure in SQL Server? If you have an existing table and you want to change the table name, you can use the "sp_rename ... 'OBJECT'" stored procedure. "sp_rename" allows you to change names of COLUMN, DATABASE, INDEX, USERDATATYPE, and OB...
2016-11-15, 910👍, 0💬

Managing Oracle User Accounts, Schema and Privileges
Where to find answers to frequently asked questions on Managing Oracle User Accounts, Schema and Privileges? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle User Accounts, Schema and Privileges. Clear answers are provided with tuto...
2019-07-30, 909👍, 0💬

Name Query Output Columns in Oracle
How To Name Query Output Columns in Oracle? Each column in the query output has a default name. If you don't like the default name, you can specify a new name for any column in the query output by using the AS clause. The following statement shows you a good example: SQL&gt; SELECT department_id...
2019-09-27, 903👍, 2💬

💬 2019-09-19 Aninda mahadev: Good Tutorial!!!

Loading and Exporting Data in Oracle
Where to find answers to frequently asked questions on Loading and Exporting Data in Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Loading and Exporting Data in Oracle. Clear answers are provided with tutorial exercises on saving data as...
2018-06-27, 903👍, 0💬

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