Solve Your Every Day Technical Problem

Efficient query writing it’s not a tough job. We are easily achieving it to following some point when writing a query. Here present some of them. I hope it's help you to writing efficient query.

University Student Payment System ‘USPS’ is an online base bespoke application system. It is mainly an accounting system but it is not a conventional accounting system. It has some specialty; it is specific only for student. Students will be able to pay their tuition and other semester fees online using this system. Guardian will able to pay their students fees through online and able to see the student financial statement. It has various message options to notify transaction information like as mobile, emailing also own messaging system. On demand University Student Payment System users will be able to view receipts, payment statement from anywhere in the world using Internet.

SQL tuning is the iterative process of improving SQL statement performance to meet specific,measurable, and achievable goals. SQL tuning implies fixing problems in deployed applications. In contrast, application design sets the security and performance goals before deploying an application.

You may have noticed that when you have a new installation of  reports 11.1.2.0 when you try to run a PDF report or even if you simply try to do a  showjobs request you get the error  REP-52262 Diagnostic output is disabled . It seems that in a new installation for security reasons diagnostic output from the URL is disabled by default.

Gets First day, last date of week, last date of month, last date of quarter, last date of year using oracle date functions.  --First day of current week SELECT TRUNC (SYSDATE, 'Day') first_day_of_current_week   FROM DUAL;

1. Basic (Every DBA should answer correctly ALL these questions. This knowledge is just basic for a 3+ year experienced DBA) 1.1 Q- Which are the default passwords of SYSTEM/SYS? A-  MANAGER / CHANGE_ON_INSTALL 1.2 Q- How can you execute a script file in SQLPLUS? A- To execute a script file in SQLPlus, type @ and then the file name. 1.3 Q- Where can you find official Oracle documentation? A- tahiti.oracle.com 1.4 Q- What is the address of the Official Oracle Support? A- metalink.oracle.com or support.oracle.com 1.5 Q- What file will you use to establish Oracle connections from a remote client? A- tnsnames.ora 1.6 Q- How can you check if the database is accepting connections? A- lsnrctl status or lsnrctl services 1.7 Q- Which log would you check if a database has a problem? A- Alert log 1.8 Q- Name three clients to connect with Oracle, for example, SQL Developer: A- SQL Developer, SQL-Plus, TOAD, dbvisualizer, PL/SQL Developer… There are several, but an experienced dba should know...