DotNetShoutout

Oracle

9
Shouts

Shout it

Day 74: ROW_NUMBER, RANK, DENSE_RANK, NTILE in Oracle

published 524 days, 2 hours, 31 minutes ago posted by

kinj312 527 days, 8 hours, 35 minutes ago

RowNumber() - Assigns sequential numbers to the records of a result-set or to the records within groups of a result-set Rank() - Returns the rank of each row within the partition of a result set. DenseRank() - Returns the rank of rows within the partition... (more)

category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Oracle

8
Shouts

Shout it

Day 73: Merge Statement in Oracle

published 526 days, 4 hours, 59 minutes ago posted by

dhara 528 days, 8 hours, 30 minutes ago

Purpose: It is a DML statement that is use for performing the Insert / Update or Delete statement to the target table based on the conditions supplied. It is introduce from Oracle 9i Let us see an example to understand this one First let us create a source... (more)

category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Oracle

7
Shouts

Shout it

Day 72: Synonym in Oracle

published 526 days, 4 hours, 59 minutes ago posted by

kinj312 529 days, 7 hours, 31 minutes ago

Purpose: It is an alternative name/alias assigned to the objects like views, sequences, stored procedures etc. Syntax Create [or Replace] [Public] Synonym [Schema .] SynonymName For [schema .] objectname [@ dblink]; It is an alias for the following... (more)

category: Data | clicked: 4 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Oracle

9
Shouts

Shout it

Day 71: Sequence in Oracle

published 529 days, 12 hours, 45 minutes ago posted by

kinj312 531 days, 9 hours, 21 minutes ago

Purpose: Generates auto number field in tables. Syntax CREATE SEQUENCE sequence_name MINVALUE value MAXVALUE value START WITH value INCREMENT BY value CACHE value; We can create a sequence as under SQL> CREATE SEQUENCE MySequence 2 MINVALUE 1 3 MAXVALUE... (more)

category: Data | clicked: 29 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Oracle

7
Shouts

Shout it

Day 70: Dual table in Oracle

published 529 days, 12 hours, 45 minutes ago posted by

kinj312 532 days, 6 hours, 40 minutes ago

Purpose: It is a dummy table in Oracle with one row and one Varchar2 column whose length is 1. It's structure looks as under SQL> Desc Dual; Name Null? Type ----------------------------------------- -------- ------------- DUMMY VARCHAR2(1) The... (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

tags: SQL Server, Oracle

6
Shouts

Shout it

Day 69: SOUNDEX function in Oracle

published 529 days, 12 hours, 45 minutes ago posted by

kinj312 534 days, 9 hours, 57 minutes ago

Purpose: It compares the field values that sounds like the supplied input word. Syntax: SOUNDEX(Value to compare) SQL> Select * From tblPlayers 2 Where Soundex(BELONGSTO) = Soundex('Lindia'); PLAYERID PLAYERFIRS PLAYERLAST BELONGSTO DOB FEEPERMATCH... (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

tags: SQL Server, Oracle

9
Shouts

Shout it

Day 66: NLSSORT in Oracle

published 535 days, 3 hours ago posted by

kinj312 537 days, 5 hours, 28 minutes ago

Purpose: Sorts characters by using string of bytes. It can be use both as a comparison and sorting parlance. Syntax: NLSSORT(SortColumn, NLSPARAM) Where, SortColumn => Column to sort NLSPARAM => It takes the form of NLS_SORT = sort where sort... (more)

category: Data | clicked: 5 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Oracle

7
Shouts

Shout it

Day 65: Insert into multiple tables from a single table in Oracle by using the INSERT ALL statement

published 535 days, 3 hours ago posted by

kinj312 538 days, 9 hours, 38 minutes ago

In Oracle, it is possible to split the record based on the columns and to insert them into multiple tables at the same time. Consider the below case where we have the tblEmployee as our base table SQL> Select * From tblEmployee; EMPID EMPNAME SALARY... (more)

category: Data | clicked: 4 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Oracle

5
Shouts

Shout it

Day 49: UserEnv function of Oracle

published 554 days, 10 hours, 45 minutes ago posted by

dhara 556 days, 11 hours, 3 minutes ago

Let Us Learn Oracle - Part 49 of N [ UserEnv Function of Oracle 10g ] Purpose: This function retrives information about current Oracle Session. Syntax: UserEnv(Parameter) Where, Parameter = > It is value return from the current Oracle Session Examp;le... (more)

category: Data | clicked: 7 | comment | | source: beyondrelational.com

tags: SQL Server, Oracle

6
Shouts

Shout it

Day 48: Bin_To_Num function of Oracle

published 554 days, 10 hours, 45 minutes ago posted by

dhara 557 days, 9 hours, 6 minutes ago

Let Us Learn Oracle - Part 48 of N [ BinToNum Function of Oracle 10g ] Purpose: This function converts a bit vector to it's corresponding numeric value Syntax: BinToNum(value1,value2,value3...,valueN) Where, value1,...valueN => are the bit... (more)

category: Data | clicked: 5 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Oracle

7
Shouts

Shout it

Day 44: First and Last function of Oracle

published 556 days, 14 hours, 58 minutes ago posted by

dhara 559 days, 7 hours, 22 minutes ago

Let Us Learn Oracle - Part 44 of N [ First and Last function of Oracle ] Purpose: Both of these acts as analytical and aggregate function. They atc on a set of rows that act as First or Last as per the given sorting specification. They accepts any numeric... (more)

category: Data | clicked: 4 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Oracle

6
Shouts

Shout it

Day 42: Percentile_Disc Function of Oracle

posted by

dhara 560 days, 7 hours, 58 minutes ago

Let Us Learn Oracle - Part 42 of N [ Percentile_Disc function of Oracle ] It acts both as Aggregate and analytic function. Purpose: An inverse distribution function which takes a percentile value and a sort specification and returns an element from the... (more)

category: Data | clicked: 3 | comment | | source: beyondrelational.com

| flag as spam

tags: SQL Server, Oracle

7
Shouts

Shout it

Day 18: Date functions in Oracle

published 574 days, 5 hours, 19 minutes ago posted by

dhara 581 days, 11 hours, 14 minutes ago

Let Us Learn Oracle - Part 18 of N [ Date functions in Oracle ] Source table: tblPlayers Oracle has a rich set of Date functions about which we will see under Get Current Date For getting current date we can use Sysdate or Current_Date SQL> Select... (more)

category: Data | clicked: 7 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Oracle

6
Shouts

Shout it

Day 16: Greatest and Least function in Oracle

published 577 days, 11 hours, 18 minutes ago posted by

dhara 583 days, 7 hours, 9 minutes ago

Let Us Learn Oracle - Part 16 of N [ Greatest and Least function in Oracle ] Source table: tblStudents Purpose: Finds the Greatest and the Least number from a range of numbers Example of Greatest function SQL> Select Greatest(10,20,4,56,234,999,12... (more)

category: Data | clicked: 3 | comment | | source: beyondrelational.com

tags: SQL Server, Oracle

6
Shouts

Shout it

Day 11: Width_Bucket function in Oracle

published 584 days, 20 hours, 41 minutes ago posted by

dhara 586 days, 9 hours, 57 minutes ago

Let Us Learn Oracle - Part 11 of N [ WidthBucket function in Oracle ] Source table: tblPlayers Syntax: WidthBucket(Expression, Minimum,Maximum,Number) Purpose: This function divides a given data set into buckets with an equal interval size. e.g. Marks... (more)

category: Data | clicked: 5 | 5 comments | | source: beyondrelational.com

tags: SQL Server, Oracle

6
Shouts

Shout it

Day 12: NVL function in Oracle

published 584 days, 20 hours, 41 minutes ago posted by

dhara 586 days, 9 hours, 59 minutes ago

Let Us Learn Oracle - Part 12 of N [ NVL function in Oracle ] Source table: tblPlayers Purpose: It substitute a value when a null value is encountered. Syntax: NVL( ColumnName, ReplaceValue ) Where, ColumnName => It is the column that is use for null... (more)

category: Data | clicked: 5 | 4 comments | | source: beyondrelational.com

tags: SQL Server, Oracle

11
Shouts

Shout it

Day 10: BitAnd function in Oracle

published 577 days, 11 hours, 18 minutes ago posted by

dhara 587 days, 9 hours, 47 minutes ago

Let Us Learn Oracle - Part 10 of N [ BitAnd function in Oracle ] Syntax: BitAnd(X,Y) Purpose: Computes bitwise logical AND operation of 'X' and 'Y' where 'X' and 'Y' are positive integers Example: SQL> Select BitAnd... (more)

category: Data | clicked: 29 | 13 comments | | source: beyondrelational.com

tags: SQL Server, Oracle

4
Shouts

Shout it

Day 7: CHR function in Oracle

published 584 days, 20 hours, 41 minutes ago posted by

dhara 591 days, 9 hours, 33 minutes ago

Let Us Learn Oracle - Part 7 of N [ CHR function in Oracle ] Source table: tblPlayers Purpose: Return the ASCII character of the number specified SQL> Select CHR(65) From Dual; C - A It does not return the ASCII of any character SQL> select chr... (more)

category: Data | clicked: 3 | 5 comments | | source: beyondrelational.com

tags: SQL Server, Oracle

5
Shouts

Shout it

Day 3: InitCap function in Oracle

published 591 days, 19 hours, 30 minutes ago posted by

dhara 594 days, 6 hours, 30 minutes ago

Let Us Learn Oracle - Part 3 of N [ InitCap function in Oracle ] Source table: tblPlayers Purpose: Capitalizes the first letter of the string Syntax : InitCap(Column Value) SQL> Select Initcap(Upper(BelongsTo)) InitCapExample From tblPlayers; INITCAPEXAMPLE... (more)

category: Data | clicked: 4 | 4 comments | | source: beyondrelational.com

tags: SQL Server, Oracle

2
Shouts

Shout it

New Versions of dotConnect ADO.NET Providers with Fluent Mapping Support in LinqConnect and Enhanced Entity Developer Are Available!

posted by

Sergii852 594 days, 8 hours, 42 minutes ago

New Versions of dotConnect ADO.NET Providers with Fluent Mapping Support in LinqConnect and Enhanced Entity Developer Are Available! Devart is glad to announce the release of the new versions of ADO.NET data providers, enhanced database connectivity solutions, built over the ADO.NET architecture, that support Entity Framework and LinqConnect ORM solutions. New versions of dotConnect data providers offer you new greatly improved Entity Developer 4.1, significantly enhanced Entity Framework support, and m... (more)

category: Web Dev | clicked: 5 | 1 comment | | source: www.devart.com

| flag as spam

tags: Code-first, database-first, ADO.NET ENTITY FRAMEWORK, PostgreSQL, Devart dotConnect, model-first, mysql, SQLite, Oracle, Linq To Entities, Devart, ORM

Welcome!

Oracle

Day 74: ROW_NUMBER, RANK, DENSE_RANK, NTILE in Oracle

Day 73: Merge Statement in Oracle

Day 72: Synonym in Oracle

Day 71: Sequence in Oracle

Day 70: Dual table in Oracle

Day 69: SOUNDEX function in Oracle

Day 66: NLSSORT in Oracle

Day 65: Insert into multiple tables from a single table in Oracle by using the INSERT ALL statement

Day 49: UserEnv function of Oracle

Day 48: Bin_To_Num function of Oracle

Day 44: First and Last function of Oracle

Day 42: Percentile_Disc Function of Oracle

Day 18: Date functions in Oracle

Day 16: Greatest and Least function in Oracle

Day 11: Width_Bucket function in Oracle

Day 12: NVL function in Oracle

Day 10: BitAnd function in Oracle

Day 7: CHR function in Oracle

Day 3: InitCap function in Oracle

New Versions of dotConnect ADO.NET Providers with Fluent Mapping Support in LinqConnect and Enhanced Entity Developer Are Available!

Open ID Login

Standard Login

Forgot Password?

Sign up