DEAR ALL,
HOW CAN I TRACE ALL THE QUERIES WHICH IS RUN IN NEW QUERY WINDOW AND IT AUTOMATICALLY INSERT
INTO A TABLE IN ROW AND COLUMN FORMAT.
EXAMPLE-IF I AM WRITING SELECT ,UPDATE,DELETE,INSERT ETC QUERY
THE QUERY WHICH IS RUN WILL SAVE INTO A TABLE BY COLUMN
USER NAME-> LOGIN NAME
USER MACHINE NAME-> INSTANCE NAME OR PC NAME EG-IVAN-PC,RTM,
QUERY RUN TIME- > WHEN THE QUERY HAS BEEN RUN.
THE ENTIRE QUERY-> EG-SELECT * FROM TABLENAME.