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; ...
three types,they are object-based logic models,record-based logic models,and physical models.
Latest Answer : Data Models:
Object based
Record based
Object Based:
Object Oriented
Entity Relationship Model
Record Based:
Relational
Network
Hierarchical ...
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
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
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 ?
How to maintain Big database During END of the Year????Example:My DataBase is Store and it has 40 tables..so after new year i want new transcation in new database.but Whats happen with my pandding data which is in old year ???this is My query
How to fetch old data with new database? suppose current inventory store in current database but after new year starting i want to store new year data in new database so howto fetch old data
Hello,I need some info, that is it possible to find or make query ,that if we know the data stored in a table but don't know the field name in which the required data is stored.ExampleTable having fields like columnA, columnB, columnC, columnD,..........columnN and all have the same dataType. and you dont know in which field your data exists.suppose some data like e.g. "BackMan" exists in any Field of the table but we don't know in which Field this information is store.Is
Latest Answer : go to tool box ->click on mysqlDataAdapter->sql datadase is created-> sql.prompt-> click on ok button->in toolbox->windows-> datagrid->in properties of datagrid->data source & data member ...
