Trim :- Removes leading and /or trailing blanks(or other characters ) from a string.Syntax:- TRim([[<trim_spec >] char ]SQL> select trim(' Aptech Computer') from dual;Returns the following result.TRIM('APTECHCOM---------------Aptech ComputerConcate Function:--The syntax for the oracle concat function is :concat(string1,string2)Parameters...
Saturday, February 28, 2015
Friday, February 27, 2015
ORA-01033: ORACLE initialization or shutdown in progress
When 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 following error. But datbase was in open state.
If your database shutdown is in progress then wait for some time until the database is shutdown and start your database with Startup command.
ORA-01033: ORACLE...
