Explain temporal data types in oracle
a query to select maxmun 3 salaries of employee table
types of indexes and the rationale behind choosing a particular index for a situation.
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
How to change user password in oracle?
How to connect the oracle server as sysdba?
Respected sir, Please send me technical questions related to oracle apps..
is there a tool to trace queries, like profiler for sql server?
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
Give the constructs of a package, function or a procedure.
State the difference between a primary key and foreign key?
What is analyze command used for?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)