Finding the number of rows of all tables of a user/schema in Oracle
how can i know all the table names along with the no. of rows they contain for a user/scema in oracle 9i through sql? plz answer ……
Answer Question
| February 23, 2009 7:16 PM
Oracle 9i, Oracle SQL, ROWCOUNT statement, SQL, SQL queries
how can i know all the table names along with the no. of rows they contain for a user/scema in oracle 9i through sql? plz answer ……
Answer Question
| February 23, 2009 7:16 PM
Oracle 9i, Oracle SQL, ROWCOUNT statement, SQL, SQL queries
SQL query and Oracle database design help needed
Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could put this as an item of the [...]
Answer Question
| February 23, 2009 6:22 AM
Database design, Oracle development, Oracle SQL, SQL, SQL queries
Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could put this as an item of the [...]
Answer Question
| February 23, 2009 6:22 AM
Database design, Oracle development, Oracle SQL, SQL, SQL queries
Looking for study materials for PRINCE2
HI I NEED STUDY MATERIALS FOR PRINCE 2 CAN YOU HELP PLS HI CAN YOU SUGGEST ANYWEBSITE FOR STUDY MATERIAL AND PAST QUESTIONS HOW LONG WILL IT TAKE ME TO STUDY AND PASS THE EXAM
Answer Question
| February 23, 2010 8:32 PM
Career development, Certifications, IT careers, IT project management, PRINCE2 certification, PRINCE2 Project Management Methodology, Project management
HI I NEED STUDY MATERIALS FOR PRINCE 2 CAN YOU HELP PLS HI CAN YOU SUGGEST ANYWEBSITE FOR STUDY MATERIAL AND PAST QUESTIONS HOW LONG WILL IT TAKE ME TO STUDY AND PASS THE EXAM
Answer Question
| February 23, 2010 8:32 PM
Career development, Certifications, IT careers, IT project management, PRINCE2 certification, PRINCE2 Project Management Methodology, Project management
Trigger for DB2 user administration
Hi guys…. Please help me…. I want to create trigger to avoid users updating records or when he update that data want to write one log file with his Login ID, time, date etc. please help me. If these is possible using trigger then pls tell me how ? Thanks Amar
Answer Question
| February 24, 2009 9:18 AM
DB2 administration, DB2 Command Editor, DB2 triggers
Hi guys…. Please help me…. I want to create trigger to avoid users updating records or when he update that data want to write one log file with his Login ID, time, date etc. please help me. If these is possible using trigger then pls tell me how ? Thanks Amar
Answer Question
| February 24, 2009 9:18 AM
DB2 administration, DB2 Command Editor, DB2 triggers
Resizing Microsoft Access 2003 properties form
I recently installed MS Access 2003 SP3 on a new machine under Windows XP SP3. I find that I cannot resize the properties window when doing form design. The problem also applies to popup forms that I create. If I take the .mdb file to another machine, it works just fien. I have tried uninstalling [...]
Answer Question
| February 23, 2009 7:32 AM
Access 2003, Access 2003 forms, Microsoft Access, Microsoft Access 2003, Microsoft Access 2003 forms, Windows XP
I recently installed MS Access 2003 SP3 on a new machine under Windows XP SP3. I find that I cannot resize the properties window when doing form design. The problem also applies to popup forms that I create. If I take the .mdb file to another machine, it works just fien. I have tried uninstalling [...]
Answer Question
| February 23, 2009 7:32 AM
Access 2003, Access 2003 forms, Microsoft Access, Microsoft Access 2003, Microsoft Access 2003 forms, Windows XP
Install QMF V9
What are the conversion requirements for QMF objects going from V8 to V9 – queries, forms & procs and what about tables and views saved in QMF, do they need to be unloaded and re-loaded?
Answer Question
| August 3, 2009 5:18 PM
QMF, QMF Objects, QMF V8, QMF V9
What are the conversion requirements for QMF objects going from V8 to V9 – queries, forms & procs and what about tables and views saved in QMF, do they need to be unloaded and re-loaded?
Answer Question
| August 3, 2009 5:18 PM
QMF, QMF Objects, QMF V8, QMF V9
Website and database connection
can anybody tell me how to connect the MS sql database with the jsp pages….I got the ip address and username with the password…I know how to connect it in a local system…but I dont know how to connect it with the database in the web server….Please help me to solve this matter
Answer Question
| February 23, 2009 12:29 PM
Database connectivity, JSP, SQL Server, SQL Server connectivity, SQL Server development, Web development
can anybody tell me how to connect the MS sql database with the jsp pages….I got the ip address and username with the password…I know how to connect it in a local system…but I dont know how to connect it with the database in the web server….Please help me to solve this matter
Answer Question
| February 23, 2009 12:29 PM
Database connectivity, JSP, SQL Server, SQL Server connectivity, SQL Server development, Web development
How can I compare fields on two databases
I want to list all fields on a database and use a forall loop to check list of fields on two forms in two seperate databases…can this be done
Answer Question
| February 24, 2009 12:18 PM
Database programming, FORALL loop, FORALL statement
I want to list all fields on a database and use a forall loop to check list of fields on two forms in two seperate databases…can this be done
Answer Question
| February 24, 2009 12:18 PM
Database programming, FORALL loop, FORALL statement
Update one database from another database with ASP.NET
I want to update my database from another database when it change.Thank for your answers
Answer Question
| February 20, 2009 9:13 AM
ASP.NET, Database programming, Multiple databases, Web development
I want to update my database from another database when it change.Thank for your answers
Answer Question
| February 20, 2009 9:13 AM
ASP.NET, Database programming, Multiple databases, Web development
How do I get started in the IT Job market
I have Network+ and MCP, But I do not have enough experience. I am interested in networking (computer of IP). Anyone knows how I can get started. Thanks
Answer Question
| February 27, 2009 3:09 AM
Career development, IT careers, IT jobs, Junior Network Engineer, MCP, Network, Networking careers
I have Network+ and MCP, But I do not have enough experience. I am interested in networking (computer of IP). Anyone knows how I can get started. Thanks
Answer Question
| February 27, 2009 3:09 AM
Career development, IT careers, IT jobs, Junior Network Engineer, MCP, Network, Networking careers
How can I select unique records from Access based on two criteria
I need to do the following: SQL = "select amount, count(amount) from table1 group by amount having count(*) =1" This returns all unique records, but I need to add another criteria to that statement ie: I need to select all unique records only if a second value is met as well! This is what I [...]
Answer Question
| February 20, 2009 1:08 AM
Microsoft Access, SQL, SQL queries
I need to do the following: SQL = "select amount, count(amount) from table1 group by amount having count(*) =1" This returns all unique records, but I need to add another criteria to that statement ie: I need to select all unique records only if a second value is met as well! This is what I [...]
Answer Question
| February 20, 2009 1:08 AM
Microsoft Access, SQL, SQL queries
Sending more then 1 Access Report to Outlook
Hi, I have 2 Access Reports which I need to send to Outlook as attachments. I usually use SendObject, but that only allows for 1 attachment. I am using Access 2007 Thanksyou Julie
Answer Question
| February 20, 2009 1:00 PM
Access 2007, Access reports, Microsoft Access, Outlook
Hi, I have 2 Access Reports which I need to send to Outlook as attachments. I usually use SendObject, but that only allows for 1 attachment. I am using Access 2007 Thanksyou Julie
Answer Question
| February 20, 2009 1:00 PM
Access 2007, Access reports, Microsoft Access, Outlook
Inserting 50000 rows using FORALL statement
How can we insert 50000 rows by using FORALL,please give me entire code?
Answer Question
| February 18, 2009 5:48 AM
FORALL statement, Oracle development, Oracle SQL, PL/SQL, SQL
How can we insert 50000 rows by using FORALL,please give me entire code?
Answer Question
| February 18, 2009 5:48 AM
FORALL statement, Oracle development, Oracle SQL, PL/SQL, SQL
IT career requirements for Java?
Hi there, I’m currently studying IT- Network and Systems Engineering. I wanted to get your professional opinion on a matter. I am not required or expected to study Java Programming. But I want to get you input on that. Should I learn Java … will I need it for future purposes?
Answer Question
| November 11, 2009 2:05 AM
Career development, Information technology systems, IT, IT careers, IT education, IT training, Java, Java programming, Network and system management, Networking, Programming Languages
Hi there, I’m currently studying IT- Network and Systems Engineering. I wanted to get your professional opinion on a matter. I am not required or expected to study Java Programming. But I want to get you input on that. Should I learn Java … will I need it for future purposes?
Answer Question
| November 11, 2009 2:05 AM
Career development, Information technology systems, IT, IT careers, IT education, IT training, Java, Java programming, Network and system management, Networking, Programming Languages
Combo search box – “Invalid Outside Proceedure”
..and before you ask, no I don’t use anything linked into Access 2007 to program my database. So, I’ve been creating a form coming from the same table with the same information to be used as a separate edit form. And now suddenly my “search box” gets this error in my normal form. HELP!
Answer Question
| February 17, 2009 4:05 PM
Access 2007, Access errors, combo box, Invalid Outside Procedure, Microsoft Access
..and before you ask, no I don’t use anything linked into Access 2007 to program my database. So, I’ve been creating a form coming from the same table with the same information to be used as a separate edit form. And now suddenly my “search box” gets this error in my normal form. HELP!
Answer Question
| February 17, 2009 4:05 PM
Access 2007, Access errors, combo box, Invalid Outside Procedure, Microsoft Access
PL/SQL
Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and strange it [...]
Answer Question
| February 20, 2009 10:47 AM
INSERT statement, Oracle development, Oracle PL/SQL, PL/SQL, PL/SQL block, SQL, SQL Timestamp, Timestamp, UPDATE statement
Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and strange it [...]
Answer Question
| February 20, 2009 10:47 AM
INSERT statement, Oracle development, Oracle PL/SQL, PL/SQL, PL/SQL block, SQL, SQL Timestamp, Timestamp, UPDATE statement
What is difference between Clustered Index and Non-Cluster Index?
What is difference between cluster index and non cluster index
Answer Question
| February 20, 2009 6:27 AM
Clustered Index, Database index strategy, Non-Clustered Index
What is difference between cluster index and non cluster index
Answer Question
| February 20, 2009 6:27 AM
Clustered Index, Database index strategy, Non-Clustered Index
Temporary recordset in MS Access VBA
Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don’t need [...]
Answer Question
| February 19, 2009 6:40 PM
Access 2003, ADO, DAO, Microsoft Access, MS Access 2003, MS Access VBA
Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don’t need [...]
Answer Question
| February 19, 2009 6:40 PM
Access 2003, ADO, DAO, Microsoft Access, MS Access 2003, MS Access VBA
How to move the msdb database to sql 2005
I have a server running sql 7.0 and I need to move the msdb database to another server running sql 2005. When I try to restore the db from a backup I’m getting a compatability error message. Any suggestions greatly appreciated.
Answer Question
| February 17, 2009 2:30 PM
SQL 2005, SQL 7, SQL database replication, SQL Server MSDB Database
I have a server running sql 7.0 and I need to move the msdb database to another server running sql 2005. When I try to restore the db from a backup I’m getting a compatability error message. Any suggestions greatly appreciated.
Answer Question
| February 17, 2009 2:30 PM
SQL 2005, SQL 7, SQL database replication, SQL Server MSDB Database
SQL Server does not exist or Access Denied Error
I have a VB.Net app which connect to a SQL Server database, just recently the technical guys removed the DNS server from the network for maintenance. and now my application cannot see the SQL server. I can ping it using its IP address and it responds but even if I configure my application to use [...]
Answer Question
| February 17, 2009 12:23 PM
Database connectivity, Error: Access Denied, SQL Server, VB.NET, Visual Basic .NET
I have a VB.Net app which connect to a SQL Server database, just recently the technical guys removed the DNS server from the network for maintenance. and now my application cannot see the SQL server. I can ping it using its IP address and it responds but even if I configure my application to use [...]
Answer Question
| February 17, 2009 12:23 PM
Database connectivity, Error: Access Denied, SQL Server, VB.NET, Visual Basic .NET
