UTL FILE With the UTL_FILE package, PL/SQL programs can read and write operating system text files. UTL_FILE provides a restricted version of operating system stream file I/O. UTL_FILE is a PL/SQL package that can be used to write to operating system...
RANGE partitioning. This type of partitioning assigns rows to partitions based on column values falling within a given range. CREATE TABLE employees ( id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30), hired DATE NOT NULL DEFAULT '1970-01-01', separated...
What is RDBMS? RDBMS stands for Relational Database Management System. It organizes data into related rows and columns. Features:- It stores data in tables. Tables have rows and column. These tables are created using SQL. And data from these tables are...
What is TRANSLATE Function in SQL? Replaces the Characters in a string with required set of characters. It Replaces one character at a time. It Translate character by character Example: SELECT ' TECHBLOG' STRING, TRANSLATE('TECHBLOG','TECH','SQL') TRANSLATE...
What is REPLACE Function in SQL? Replaces the Characters in a string with required set of characters. It Translate Pattern by Pattern. Example: SELECT ' TECHBLOG' STRING, REPLACE('TECHBLOG','TECH','SQL') REPLACE FROM DUAL; WHERE ENAME LIKE'%A%'; STRING...
Replace used for String where as Translate used for Character. Replace Replaces entire string at a time where as Translate Replaces character one-to-one basis Replace Function replaces single character with multiple characters where as Translate Function...
DENSE_RANK NTILE RANK ROW_NUMBER DENSE_RANK The DENSE_RANK Function is one of the SQL Server ranking function. This function will assign the rank number to each record present in a partition without skipping the rank numbers. SQL DENSE_RANK Function Syntax...
SQL SQL Server 2014 Create Database SELECT Statement WHERE Clause ALIAS Column ORDER BY Clause TOP Clause SELECT DISTINCT Statement SELECT INTO Statement INSERT INTO SELECT Statement GROUP BY Clause HAVING Clause BULK INSERT Statement SQL Query Builder...
How to recover a database from suspect mode ? Step 1: Open SQL Server Management Studio and connect to the SQL Server. Make sure that your current database is set to master Step 2: Clear the suspect mode of the database using sp_resetstatus DatabaseName....
