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.
Author Archives: Binu George
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 count those records in which the field in the brackets is NOT NULL.
‘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 of result set can be based on column or columns.
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 table and store it into another table based on certain conditions
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 another table column value.It is also known as references constraint
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 is possible to add CONSTRAINTS like primary key ,foreign key etc while creating the table or can be added after the table creation
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 in retrieving the maximum value of date from a record set or column or result set etc.
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.