|
| 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 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 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 ? Read Answers (2) | Asked by : Rk 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 Will the ‘View’ get refreshed immediately when you update a database table. If it doesn’t get refreshed immediately, what method you use to refresh it ? Read Answers (3) | Asked by : ronin I have my DB2 database on mainframes and I am trying to replicate the same database on Windows server. I have loaded the table definitions to the Windows servers but looking for a way to export data from Mainframe DB2 tables to Windows server tables (Table definitions in both servers are same).I am looking for an easy and efficient way which can take care of nulls, strings, delimiters etc while exporting.Any help! View Question | Asked by : CHANDU I have small application that i was developing as a school evaluation project,but i have faced problems.(i.e) My command buttons are not perfoming the tasks as expected Edit, and Delete buttons they search and delete the first records on the database. A sample of the commands is as below i am using Using DAO in a module and listviews to display the records.Please helpPrivate Sub cmdEditer_Click()cmdsaved.Caption = "Update"Dim l As Integerl = Val(InputBox("Enter the suppliers Number View Question | Asked by : Josephat Mbogoh I am having software in VB and database is SQL Server.now this software is to be installed at 3 different client locations.problem is that same database is to be used online for website.now i want whenever any person add,edit,delete data then it should be reflected among all 3 locations as well as on website.problem is database will be on local machine on each location bcoz it is not possible to keep online database connected, as it will need internet plus database connection can get disturb in
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
