Category: SQL


how to restore database in oracle


how to take backup in oracle


What is constraint in oracle Constraints apply specific rules to data, ensuring the data conforms to the requirements defined. Types of Constraint Primary Key Foreign Key Not Null Check Unique Default What is primary key constraint A primary key constraint combines Read more…


how to create view in oracle View is logical subset of data and it is use to restrict the data access to user. Syntax for creating a View CREATE or REPLACE view view_name AS SELECT data FROM table_name WHERE condition Read more…


order by in oracle The SQL ORDER BY clause is used for sorting data either in ascending or in descending order. By default oracle providing ascending order sorting Syntax >SELECT expressions FROM tables WHERE conditions ORDER BY expression [ASC | Read more…


like clause in oracle The LIKE operator is used to search for a specified pattern in a table. LIKE clause is similar to startsWith() or endsWith() method of java. Syntax > select * from stud where sname like ‘v%’; Here Read more…


or clause in oracle OR clause will return true if  any one of the statements are true.If both are false then it will return false. OR keyword is use to pass condition in oracle query. Syntax >select column_name from table_name Read more…


and clause in oracle AND clause will return true if both statements are true other wise it will return false. AND keyword is used along with where clause in oracle query. Syntax >select * from table_name where column_name =column-data and column_name = Read more…


what is where clause in oracle where clause is use to pass condition with our SQL queries. Suppose we want to retrieve only one record then we have to pass where clause along with select query. Where clause with select Read more…


How to retrieve unique records in oracle Using distinct keyword we can retrieve unique record from table in oracle.We have to pass column name along with distinct keyword. Syntax >select distinct column_name from table_name; Example >select distinct name from student;






Full-stack web and mobile app development company Contact Us : Skype: indore.webcoder Email: info@w3sparks.com Sales: +91 8085506229