REP-0492: Unrecognized token

REP-0492: Unrecognized token Yesterday I was trying to build a report in Oracle Dev6i. I have build the query in Toad9.5.0.31, I have executed query several times in Toad and it runs fine but when I paste same query in report builder and click 'OK' button it shows error ( REP-0492: Unrecognized token: ' '. ). REP-0492: Unrecognized token REP-0492: Unrecognized token I have tried everything possible to get rid of this error...

Read More

DDL DML DCL and TCL

DDL DML DCL and TCL In this post we will learn the basics of DDL, DML, DCL and TCL statements. DDL(Data Definition Language ) statements are used to define the database structure or schema. Such as: CREATE - to create objects in the database ALTER - alters the structure of the database DROP - delete objects from the database TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed COMMENT - add comments to the data dictionary RENAME - rename an object   DML(Data...

Read More