|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions How can you prevent the users logging in through tools like TOAD or SQL Navigator or PLSQL Developer..? Connect as sydba Write a LOGON trigger like this CREATE OR REPLACE TRIGGER RESTRICT_TOOL AFTER LOGON ON DATABASEDECLARE L_TOOL V$SESSION.PROGRAM%TYPE;BEGIN SELECT SELECT * FROM V$VERSION Latest Answer : To find the Oracle Version:Sql>Select * from v$version; ... Latest Answer : using SQLLOADER you can migrate data from non oracle database to oracle database. ... three types,they are object-based logic models,record-based logic models,and physical models. Latest Answer : There are no standards in this area. Authors and theorists make it up as they go. The entity-relationship model (ER) has hundreds of derivitives (bachman, chen, ibm, IDEF1x etc.). the most popular of the OO models is Unified Modeling Language (UML). ... Read Answers (1) | Asked by : sudheer I have Employee information in MS-Excel format , now i want to convert in to Oracle database. is it possible to do this task, can any one please help me Read Answers (10) | Asked by : balaji I want to access the dimension members in oracle OLAP and update them in a list box in html.. I am unable to access the dimension member values.. How can i do that?? View Question | Asked by : rajesh 1. This question involves different aspects of an operational database compared to a data warehouse.a) Since there are differences between a data warehouse and an operational database, how does this effect the people requirements of each. What differences are there in terms of how many people need to be assigned to the data warehouse team and how many people need to be assigned to the operational database team? Also, what type of skills are needed for the people assigned to the data warehouse team How can a user access all the Data Dictionary Views - Say If Scott user needs to be given the privilege of viewing all the Data Dictionary Views, What needs to be done ? Read Answers (3) | Asked by : RK I have a production 24/7 database and i am looking at refreshing the database, how is it possible ? Mind you ! Its a production 24/7 database nad hence cannot be shutdown ? Read Answers (2) | Asked by : Rk I have student table with fields name,marks1,marks2,marks3 fileds. i want the output as the student details and thier totals and their rank in class, i.e calculated at runtime.please send me the query in sql server or oracle Read Answers (2) | Asked by : sanjay
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
