Subscribe SQL & PLSQL Tips via email
Globinch is a Technology Blog .More
| Search Globinch plsql world: |
-
ORA-01722: invalid number | PL/SQL :ORA-01722 Error
The error ORA-01722: invalid number is caused while encountering non numeric data(‘characters) when numeric data is expected. -
COUNT() Function in SQL ,Using COUNT(*) and COUNT(1)
The COUNT() function returns the number of records in a tables based on sql query. The COUNT function will only... -
‘ORDER BY’ clause in SQL | Using SQL order by
The keyword ‘ORDER BY’ clause used in SQL to order the data sets retrieved from a SQL database. The sorting... -
Oracle/PLSQL:Create Table as Select
CREATE TABLE AS SELECT statement can be used when we need to extract part or full data from a... -
Oracle/PLSQL: Create table with foreign key constraint
Usage Create table statement with foreign key constraint will create table with referential integrity Foreign Key holds the reference to... -
CREATE TABLE statement: create a table with composite primary key
CREATE TABLE statement: create a table with composite primary key. -
Oracle PL/SQL:CREATE TABLE statement: create a table with primary key.
Oracle PL/SQL:CREATE TABLE statement: create a table with primary key. -
Oracle PL/SQL:Create Table
CREATE TABLE statement is used to create table objects in database.You can create tables with different column data types.It... -
Oracle Max(Date) function usage-SQL max date
Max() function in sql can be used to get maximum value of two or more dates.Max(Date) function is useful... -
Oracle Trim Function | PL/SQL TRIM() Function.
TRIM function removes all specified characters from the beginning of a string or from the ending of a string.
-
Error Codes
ORA-01722: invalid number | PL/SQL :ORA-01722 Error
No Comments -
Functions
COUNT() Function in SQL ,Using COUNT(*) and COUNT(1)
2 Comments -
Functions
‘ORDER BY’ clause in SQL | Using SQL order by
No Comments -
Fundamentals
Oracle/PLSQL:Create Table as Select
2 Comments -
Constraints
Oracle/PLSQL: Create table with foreign key constraint
No Comments -
Constraints
CREATE TABLE statement: create a table with composite primary key
No Comments -
Constraints
Oracle PL/SQL:CREATE TABLE statement: create a table with primary key.
No Comments -
Fundamentals
Oracle PL/SQL:Create Table
No Comments -
Functions
Oracle Max(Date) function usage-SQL max date
No Comments -
Functions
Oracle Trim Function | PL/SQL TRIM() Function.
1 Comment