Oracle SQL & PL/SQL
Enter a key term, phrase, name or location to get a selection of only relevant news from all RSS channels.
Enter a domain's or RSS channel's URL to read their news in a convenient way and get a complete analytics on this RSS feed.
SQL Server Indexes best practices Below are some of the SQL Server Indexes best practices or points to keep in mind while creating SQL Server Indexes...
Multiple Choice Questions - Sparse Columns 1. Sparse columns make it possible to store columns more efficiently where a large percentage of the rows...
DATENAME Function Examples This DATENAME() function returns a character string that represents a part of a given date and time value. Lets see some of...
How to Check Indexes on a Table Lets create a table named Dummy and insert few rows in it. CREATE TABLE Dummy ( ID int, LastName varchar(255), FirstName...
Multiple Choice Questions - Contained Databases 1) A contained database is one that is isolated from other databases but may or may not be isolated from...
Subqueries in WHERE Clause - Examples Below are examples of subqueries in the WHERE clause of an SQL Server statement. CREATE TABLE teacher ( Id int...
Difference between GRANT, DENY & REVOKE Grant is used to specifically allow access to an object. Deny is used to specifically prevent access to...
Difference between isNull & COALESCE Here are 3 points of difference between isNULL & Coalesce. Also below you can have a look at the table to...
SQL Server - Interview Questions for Testers 1. What are the two authentication modes in SQL Server? Two authentication modes in SQL Server are: Windows...
SQL Server - COLLATE Examples Collate is used to display and store an international character set, based on the requirements. You can specify collation...
Multiple Choice Questions - SQL Joins - Set 7 1. Which of the below point(s) are true with respect to joins: A) Null values never join. B) Columns used...
Unfortunately Oracle SQL & PL/SQL has no news yet.
But you may check out related channels listed below.
Related channels
-
Oracle ERP Functional and Technical Guide
Oracle ERP Functioncal and Technical Materials is about to share my knowledge on Oracle Apps R12,ERP,Apps Functional and...
-
Database Recovery Software | Database Diasaster Recovery Solutions
Database recovery for SQL, MySQL, Oracle, Access, SharePoint & FileMaker
-
SQL Teachers
Sql teachers is about sharing my experience in sql server, transact sql, oracle, hadoop, big data.