• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql

sql

Concatenate Strings Using || Operator in Oracle SQL PLSQL

November 23, 2012 by techhoneyadmin

The || operator in Oracle SQL / PLSQL can be used to concatenate multiple strings to form a single string. Syntax for the using the || operator in Oracle SQL / PLSQL is: SELECT string_1 || string_2 || string_3 || . . . || string_N FROM table_name; string_1, strring_2 . . string_N are the strings […]

Filed Under: sql Tagged With: CONCAT || Operator in oracle plsql, CONCAT || Operator in oracle sql, CONCATWITHPLSQL, how to use CONCAT || Operator in oracle database query, how to use CONCAT || Operator in oracle plsql, how to use CONCAT || Operator in oracle sql, syntax and example of CONCAT || Operator in oracle database query, syntax and example of CONCAT || Operator in oracle plsql, syntax and example of CONCAT || Operator in oracle sql, using CONCAT || Operator in oracle database query, using CONCAT || Operator in oracle plsql, using CONCAT || Operator in oracle sql

CUBE in Oracle SQL – PLSQL

November 19, 2012 by techhoneyadmin

The CUBE in Oracle SQL / PLSQL is an extension for the GROUP BY clause. Syntax for CUBE in Oracle SQL / PLSQL is: SELECT column(s), AGGREGATE_FUNCTION(s), FROM table_name GROUP BY CUBE column(s) [ORDER BY column(s)]; Example: Using CUBE in Oracle SQL / PLSQL Query Suppose we have a table named ‘employee’ as shown below: […]

Filed Under: sql Tagged With: Cube in oracle plsql, Cube in oracle sql, CUBEPLSQL, how to use Cube in oracle database query, how to use Cube in oracle plsql, how to use Cube in oracle sql, syntax and example of Cube in oracle database query, syntax and example of Cube in oracle plsql, syntax and example of Cube in oracle sql, using Cube in oracle database query, using Cube in oracle plsql, using Cube in oracle sql

PARTITION BY Keyword in Oracle SQL – PLSQL

November 7, 2012 by techhoneyadmin

In simple terms the PARTITION BY keyword in Oracle SQL / PLSQL is used to partition or segregate the records based on groups Syntax for the PARTITION BY keyword in Oracle SQL / PLSQL is: SELECT columns ,aggregate_function OVER (PARTITION BY column(s)) FROM table_name; Example 1: Using PARTITION BY keyword Suppose we have a table […]

Filed Under: sql Tagged With: how to use partition_by keyword in oracle database query, how to use partition_by keyword in oracle plsql, how to use partition_by keyword in oracle sql, PARTITIONBYPLSQL, partition_by keyword in oracle plsql, partition_by keyword in oracle sql, syntax and example of partition_by keyword in oracle database query, syntax and example of partition_by keyword in oracle plsql, syntax and example of partition_by keyword in oracle sql, using partition_by keyword in oracle database query, using partition_by keyword in oracle plsql, using partition_by keyword in oracle sql

ROWNUM Pseudo Column in Oracle SQL – PLSQL

November 7, 2012 by techhoneyadmin

The ROWNUM is a pseudo column in Oracle SQL / PLSQL which returns a row’s position in the fetched result set. ROWNUM is evaluated AFTER records are SELECTED from the data-base and BEFORE execution of the ORDER BY clause. Syntax for the ROWNUM function in Oracle SQL / PLSQL is: SELECT column(s) FROM table_name WHERE […]

Filed Under: sql Tagged With: how to use rownum pseudo column in oracle database query, how to use rownum pseudo column in oracle plsql, how to use rownum pseudo column in oracle sql, rownum pseudo column in oracle plsql, rownum pseudo column in oracle sql, ROWNUMPLSQL, syntax and example of rownum pseudo column in oracle database query, syntax and example of rownum pseudo column in oracle plsql, syntax and example of rownum pseudo column in oracle sql, using rownum pseudo column in oracle database query, using rownum pseudo column in oracle plsql, using rownum pseudo column in oracle sql

INDEX in Oracle SQL – PLSQL

November 1, 2012 by techhoneyadmin

In Oracle SQL /PLSQL an INDEX is basically a performance tuning method which allows us to retrieve or fetch the desired records faster. An INDEX will create an entry for each value that is stored in the indexed columns. Syntax for creating an INDEX in Oracle SQL / PLSQL is: CREATE [UNIQUE] INDEX index_name ON […]

Filed Under: sql Tagged With: how to use indexes in oracle database query, how to use indexes in oracle plsql, how to use indexes in oracle sql, indexes in oracle plsql, indexes in oracle sql, indexPLSQL, syntax and example of indexes in oracle database query, syntax and example of indexes in oracle plsql, syntax and example of indexes in oracle sql, using indexes in oracle database query, using indexes in oracle plsql, using indexes in oracle sql

  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 5
  • Go to Next Page »

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in