Oracle ALTER TABLE MODIFY

ALTER TABLE MODIFY

Hello friends, In this article we are going to discus, how to use ALTER TABLE MODIFY column. Using this command we can modify table structure if required after table creation. ALTER TABLE MODIFY In this practical we are using following table which is have three columns. SQL> desc ocptech; Name Null? Type ———— —— ———- … Read more Oracle ALTER TABLE MODIFY

Share

SQL Character Function

CHARACTER FUNCTION

Character Functions Hello friends in this article we are going to discuss how to use sql character function. These functions accept only Character type values and return in character and number both. You must read about What is Merge in SQL? CONCAT CONCAT function joins two or more values together & using minimum two parameters … Read more SQL Character Function

Share

Using Column Aliases

Using Column Aliases

When you run a query for displaying the result of a query, a column aliases is useful rename that columns with calculations, so you can change easily column header using a column aliases. Always define a column alias after the column name, by default column alias header appear in uppercase, if you use space or … Read more Using Column Aliases

Share

Using SQL Select Statements

sql select statements

How to use SQL select statements? In this article we are going to learn how to use SQL select statements to retrieve data from tables or views. In database, data stored in tables format and if you want to check that data then you should know how to use Oracle SQL statements. Click here to … Read more Using SQL Select Statements

Share

How to Create an External user using Create user statement

create external user

Create external user using create user command in SQL To create external user and his authentication are managed by external services like as network service or operating system services. The user who is authenticate by the OS (operating system) can access the Database without any password. The external users are classic default and regular database … Read more How to Create an External user using Create user statement

Share

How to use Row Limiting Clause

Row limiting clause

Row Limiting Clause Row limiting clause is introduced in oracle 12c R1. Using the row_limiting_clause to limit the number of rows that are returned by a query. using this clause to implement Top-N reporting. You can specify the percentage of rows or number of rows to return with the FETCH FIRST keyword. You can use … Read more How to use Row Limiting Clause

Share

How to create SEQUENCE step by step

how to create sequence

In this article we are going to learn how to create and use SEQUENCE. What is SEQUENCE? SEQUENCE is an oracle shareable object which is generate numeric values and it can be unique. you can use this value into primary key and unique values. Let see how to create SEQUENCE and how to use sequence … Read more How to create SEQUENCE step by step

Share

Merge Command

merge command

What is Merge in SQL? Merge Command was introduce in ORACLE 9i, the ability to conditionally update or insert into a database table. merge statement avoid separate updates, increases the performance and ease of use and is useful in data warehouse applications. How to use merge command in SQL? Create two tables and insert few records in first table … Read more Merge Command

Share

TYPE OF JOINS

TYPE OF JOINS

What is Joins? The type of Joins are using to extract data from multiple tables with single query. Type of Joins? There are two type of Joins. Oracle Joins SQL Joins Invalid Join Cross Join Equi Join Natural Join Non-Equi Join Using Clause Outer (+) Join On Clause Self Join Left Outer Join Right Outer … Read more TYPE OF JOINS

Share
Share