Basic Pl sql
Related Posts:
Distinct Function The SQL SELECT DISTINCT StatementIn a table, some of the columns may contain duplicate values. This is not a problem, however, sometimes you will… Read More
Using Clause In SqlThe Using Clause specifies which columns to test for equality when two tables are joined.it can be used insted of an on clause in the join operation t… Read More
Replace Function In SqlTrim :- Removes leading and /or trailing blanks(or other characters ) from a string.Syntax:- TRim([[<trim_spec >] char ]SQL> select trim(' … Read More
Difference between TRUNCATE, DELETE and DROP commands(adsbygoogle = window.adsbygoogle || []).push({}); The delete command is used to remove rows from a Table.A where clause can be used to only rem… Read More
ORA-01033: ORACLE initialization or shutdown in progressWhen you login into Oracle Database and it throws following error message: i could not login into my account . I was unable to login with the followin… Read More
0 comments:
Post a Comment