Home Discussion Discuss: Database Management System (DBMS)

  • Sql Serverchveeranna June 2, 2011 at 10:58 AM

    i need sql server tutorial

  • ResearchNasiru ope June 25, 2011 at 1:40 AM

    What data are you likely to collect when you fail to anticipate the strategies for your data

  • Laptop needzama June 27, 2011 at 11:08 PM

    I am a student of IT at majuba colledge in newcastle, but its impossible to study without a computer at home

  • Pro Cmeenakshi.H.N June 29, 2011 at 7:51 AM

    do SQL server support embedding sql into C HLL? how to work on emkbedded SQL using C & Oracle

  • DBMSTanakala Srikant June 29, 2011 at 7:54 AM

    I need a online trainer at Oracle Database,SQ L.

  • feedbackshere mitesh June 29, 2011 at 11:34 AM

    this website is amazing... thanks a lot....

  • iEVfaoJohWsCTFanni June 15, 2013 at 2:59 PM

    Whoa, things just got a whole lot esaier.

  • TuUZUiQlDCCXbcMarnie June 15, 2013 at 3:35 PM

    Why does this have to be the ONLY relabile source? Oh well, gj!

  • to create a .war file of jsp fileAamirkhan August 23, 2011 at 11:06 AM

    Hi! i want to create a .war file of my temp.jsp file..how to do that..is there any way to do that in net beans..reply me as soon as possible..

  • COOMENTsenthilkumar.j August 23, 2011 at 5:44 PM

    GOOD

  • core javaD.VIKRAM August 29, 2011 at 12:05 AM

    what is the garbage collectoin

  • bjsXCBWccaxrkYAssem June 13, 2013 at 10:23 AM

    Which Career is Better?None of the careers you lisetd is better than the other because you will find professionals thriving and succeeding in all of them.The idea of choosing a career because you think that it is better than the other is a subjective way of making a choosing a career.An alternative, perhaps better method is to realize that while one career is good for someone, it may not be good for you.In other words, it is the YOU in that makes the difference. It is actually better to ask the question this way:1. Which Career Is Better For ME ?2. Where can I make a difference?In answering the first question:Which career is better for me, you will have to make a list of your goals, dreams, passions, interests, abilities, likes, dislikes, strengths, weaknesses use that to evaluate your opportunities and threats.Again, I say it is the YOU that makes the difference. You have to look at your own goals, dreams, ambitions, financial needs, etc.Here are a few questions that you can answer that will help you make a better decision:1. Is making a lot of money important to you? If yes, which of these careers will help you earn a lot of money.2. Can you afford a career that requires you to spend 4 years in and incur college debt? A few careers require a masters degree or an expensive and long college education.3. How good are you at the skills required for those careers in comparison to others? Answering this question means that you have to make an inventory of the skills required in each career and then evaluate how your skills compares to others. E.g. as a Technical Writer, documentation and writing skills will be the primary skills you must practice and / or enjoyBy using more objective criteria like those mentioned in this post, you would be able to evaluate which career is better for you.Let me know if this answers your question or if you need more help VN:F [1.9.22_1171](1 vote cast) -8Was this answer helpful?

  • phpdonald June 6, 2013 at 4:32 AM

    Advance php

  • very goodk.srinubaburoy September 3, 2011 at 10:44 PM

    i have mo number of latest information.

  • sqlAnil Kumar Singh September 7, 2011 at 8:37 PM

    i hv little knowledge about the sql. so want to know more about it....please help me...

  • GoodABC September 12, 2011 at 12:51 PM

    very good site for learning..............

  • Access database construction/managementFarid Ahmad Fayeez September 13, 2011 at 2:50 PM

    I am searching an institute that could provide me Access training where I can learn the following topics: - how to create/develop a database - data analysis - data cleaning - data modeling - data security - data warehouse and - data mining Also there will be some topics that I forget to write you. thanks.

  • Plz reply answers for this query..Basavaraj Patil September 23, 2011 at 5:44 PM

    1. Develop a database application to demonstrate storing and retrieving of BLOB and CLOB objects. 2. Develop a database application to demonstrate the representation of multivalued attributes, and the use of nested tables to represent complex objects. Write suitable queries to demonstrate their use. 3. Design and develop a suitable Student Database application. One of the attributes to me maintained is the attendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, write active rules to do the following: a. Whenever the attendance is updated, check if the attendance is less than 85%; if so, notify the Head of the Department concerned. b. Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40%; if so, notify the Head of the Department concerned. 4. Design, develop, and execute a program in a language of your choice to implement any one algorithm for mining association rules. Run the program against any large database available in the public domain and discuss the results.

  • sql ServerAmit tripathi September 26, 2011 at 3:55 PM

    Hai..

  • c++MITHUN KUMAR October 5, 2011 at 11:36 AM

    c++

  • dbmssatya prakash January 30, 2013 at 8:47 PM

    Design and develop a suitable Student Database application. One of the attributes to me maintained is the attendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, write active rules to do the following: a. Whenever the attendance is updated, check if the attendance is less than 85%; if so, notify the Head of the Department concerned. b. Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40%; if so, notify the Head of the Department concerned.

  • DBMSRamesh October 18, 2011 at 10:51 AM

    On the bases of oracle is there any courses available for certification?Please answer me.

  • asp.netrabia November 9, 2011 at 5:26 PM

    know about how to do post button coding on discussion forum.

  • bank projectrupesh kumar November 18, 2011 at 6:03 PM

    we need exe file of bank in vb

  • databasehussain November 25, 2011 at 10:45 PM

    what is the syntax for the query "Select customer names having account but not loan" the tables are 1. account 2. branch 3.loan 4.customer with relationships: customer-account: 1-M customer-loan: 1-M branch-loan: 1-M branch-account: 1-M

  • bQflLuCHsTZzdNoviea March 5, 2013 at 8:47 PM

    had less than one MEGAbyte of memory. No hard disk, just two 360 kB fopply disk drives and 128K of RAM. I just got saddled with a data-mining project that will process tens of gigabytes of data in a networked environment. My analysis tools can use SQL to access the data. This book was the first thing I insisted on. (Kind of embarassing for a senior person to be seen carrying a thick yellow and black book with the word DUMMIES on it )This has proven to be an excellent starting point. I know plenty about computers and programming. I vaguely remember the essentials of relational databases (for those who don't, basic information is in the book, it should be enough to get started, even if you are absolutely ignorant!) Taylor packaged enough of the right information that I could read his book over the weekend and dive into the planning stages of our project on Monday sounding like I knew a thing or two. The book charts a course from the most basic elements of databases to modestly complicated database and query materials. The author discusses common pitfalls and useful strategies. This book isn't enough, by itself, to turn somebody into a database wonk, but it's a great starting point.I got a bit annoyed by some of the cute material used to make the subject seem less threatening, but that filler doesn't take up too much space and is easily skipped. Also, the book is overly Microsoft centered the author uses Windows applications as examples and champions Microsofts ODBC. A section about using SQL in a Unix/Linux environment should have been included (access from shell scripts, PERL, etc?). A solid four-star introduction to SQL and database technology in a Microsoft world.(If you'd like to discuss this book or review in more detail, please click on the about me link above and drop me some email. Thanks!)

  • ELqLnMkcgIqwQGEkayzm March 6, 2013 at 12:52 AM

    hey there and thank you for your information â?? Iâ??ve cnrtaiely picked up anything new from right here. I did however expertise several technical issues using this site, since I experienced to reload the web site a lot of times previous to I could get it to load properly. I had been wondering if your hosting is OK? Not that I'm complaining, but sluggish loading instances times will sometimes affect your placement in google and could damage your quality score if ads and marketing with Adwords. Anyway I am adding this RSS to my e-mail and could look out for much more of your respective intriguing content. Ensure that you update this again very soon..

  • DBMSmadhu December 16, 2011 at 6:42 PM

    what is the type of an image in database?

  • fsdanu December 21, 2011 at 3:48 PM

    need 2 improve

  • Data base mulugeta December 21, 2011 at 8:30 PM

    I have no word to express your uploaded handout so that be continue to upload news things and modified thanks a lot Your sensory D/r Mulugeta Assefa Bye bye

  • nkoNdHjKhItWqGVeAFrankie March 6, 2013 at 8:55 AM

    Too many compliments too little space, tkahns!

  • EEhqnpjAtrgrDKOXNJanine March 6, 2013 at 8:55 AM

    Wow! Great to find a post with such a clear mssegae!

  • UJukhlTzsYdWfDoRAPrecious March 6, 2013 at 8:56 AM

    Your awnser was just what I needed. It's made my day!

  • aACrYKBdtEIpQSPhilip March 6, 2013 at 9:28 AM

    I would have thought that if a given optuut gap can tolerate a budget deficit of say 10% without making inflation accelerate, its better for this 10% deficit to be split 9% on targeted spending (with a proven multiplier effect) and only 1% on bond interest (which goes to capital owners and so has a low multiplier), instead of 7% vs 3%. In other words, if a govt pays out a lower amount of sovereign interest, it has more room to pay for more useful things.

  • regarding RDBMSGoldy Rawat December 26, 2011 at 7:26 PM

    I like this website. its very helpful for us... Thankx

  • storing and retrieving the datasmitha January 14, 2013 at 11:58 PM

    when we do a project we create html pages such as registration forms etc,but my question is where do we store this data and how do we invoke this data(retrieve). when is xml used and when is jdbc connection used?

  • dbmsujwala January 13, 2012 at 12:53 AM

    wants more advance knowledge in dbase

  • To know about the java MD.ASIF ANSARI January 26, 2012 at 9:45 PM

    I want to connection with java and updating,deleting,viewing and many more.

  • projectvalarmathi February 2, 2012 at 9:42 AM

    i will do my project in database.please help

  • D B M S inqury md saifee February 3, 2012 at 6:08 PM

    D B M S me mai kiya use kar sakta hun .hai kiya

  • tLuKgsedaMHernan January 19, 2013 at 7:54 AM

    Just want to say your article is as aosnutding. The clearness in your post is simply nice and i could assume you are an expert on this subject. Fine with your permission allow me to grab your feed to keep up to date with forthcoming post. Thanks a million and please continue the gratifying work.

  • gTYlLFvtMdNkGbAmira January 19, 2013 at 7:55 AM

    Very nice post. I just stumbled upon your webolg and wished to say that I've truly enjoyed surfing around your blog posts. In any case Iâ??ll be subscribing to your feed and I hope you write again very soon!

  • kiquekish February 17, 2012 at 4:53 PM

    DECLARE QUERY VARCHAR2(32767); FIN_QUERY VARCHAR2(32767); CURSOR C IS (select distinct PORTFOLIO from MPE_TEST1); CURSOR C2 IS SELECT DISTINCT PORTFOLIO_LEVEL, PORTFOLIO FROM MPE_TEST1 ORDER BY PORTFOLIO_LEVEL; TYPE ARRAY IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER; PORTFOLIO_LEVEL ARRAY; IDX NUMBER :=1; BEGIN QUERY := 'SELECT '; for R IN C LOOP IDX := 1; FOR R2 IN C2 LOOP IF(R2.PORTFOLIO = R.PORTFOLIO) THEN PORTFOLIO_LEVEL(IDX) := R2.PORTFOLIO_LEVEL; IDX := IDX + 1; END IF; END LOOP; QUERY := QUERY || 'CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(1) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_SALE_ASS_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(1) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_SALES_ASS_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(2) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_SALE_MST_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(2) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_SALE_MST_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(3) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_SALE_PROF_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(3) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_SALE_PROF_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(4) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_TECH_ASS_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(4) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_TECH_ASS_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(5) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_TECH_MST_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(5) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_TECH_MST_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(6) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_TECH_PROF_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(6) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_TECH_PROF_EXP_DT,'; END LOOP; QUERY := SUBSTRING(QUERY,0,LENGTH(QUERY)-1); QUERY := QUERY || ' FROM MPE_TEST1 F '; --DBMS_OUTPUT.PUT_LINE('QUERY--'||QUERY); FIN_QUERY := 'select '; FOR R IN C LOOP FIN_QUERY := FIN_QUERY || '(case when '||R.PORTFOLIO||'_TECH_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL ASSOCIATE'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL ASSOCIATE'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL ASSOCIATE'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_TA_LEVEL, (case when '||R.PORTFOLIO||'_SALE_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES ASSOCIATE'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES ASSOCIATE'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES ASSOCIATE'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_SA_LEVEL, (case when '||R.PORTFOLIO||'_TECH_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL MASTER'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL MASTER'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL MASTER'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_TM_LEVEL, (case when '||R.PORTFOLIO||'_SALE_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES MASTER'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES MASTER'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES MASTER'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_SM_LEVEL, (case when '||R.PORTFOLIO||'_TECH_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL P'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL P'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL P'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_TP_LEVEL, (case when '||R.PORTFOLIO||'_SALE_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES P'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES P'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES P'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_SP_LEVEL, '; END LOOP; FIN_QUERY := FIN_QUERY || ' i.* from (' || QUERY; FIN_QUERY := FIN_QUERY || ') I '; DBMS_OUTPUT.PUT_LINE(FIN_QUERY); EXECUTE IMMEDIATE FIN_QUERY; END;

  • oracle projectgopal February 19, 2012 at 8:20 PM

    i want to do project wth oracle having DB2 frontend. can somebody help me or suggest me something

  • simple questionsumit agarwal February 23, 2012 at 4:10 PM

    sir/madam please send some dbms mcq question. (sumit agarwal)

  • apricationzag February 27, 2012 at 12:50 PM

    Interseting tut

  • need answermalini March 3, 2012 at 7:48 PM

    i want coding for online voting system ...i want to finish my project within a week

  • database sumera zulfiqar March 16, 2012 at 11:30 AM

    plz provide me a project on bank management system

  • sqlsaeed March 22, 2012 at 4:47 PM

    Can i help me about diffrences of kinds of Sql?

  • projectrasha April 3, 2012 at 12:34 AM

    write code i have five tables i want to build them html form and link between them database and php then make query between them ,,,,,,,,,, Table of suppliers Source no, resource name, Address mobile ,Tel , e-mail ,,,,,,,,,,,, Customers table Customer no , Customer name , Address ,mobile, Tel , e-mail ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Sales table Sales invoice no , History , Statement, Item Goods number ,number price ,color ,payment, Delivery date , notes ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Table purchases Purchase invoice ,number, Date , Number of purchase number, statement, item ,Price , color, payment Delivery date, notes ,,,,,,,,,,,,,,,,,,,,,,,, Bucket table Goods number ,Payment invoice, number, Purchases Invoice number, statement, item ,number, Cost price ,Selling price , color Date of entry of the goods ,status ,,,,,,,,,,,,,,,,,,,

  • JTable Connectivity with MSAccessmanoj singh April 3, 2012 at 1:55 PM

    I want to access Table contents in JTable in java swing.. plz help me and provide source code for that

  • computer scienceadava April 23, 2012 at 3:04 AM

    I am an fresh men in IT area . need someone give me some help. Thanks

  • JDBC MSACCESSravi April 10, 2012 at 5:14 PM

    How to insert dynamically values into a table using JDBC MSACCESS This COde is not working for me COuld you please tell me the error in this code import java.sql.*; import java.util.*; public class DBDemo3 // DBDemoInsert { public static void main(String[ ] args) throws Exception { String url = "jdbc:odbc:mydsn"; Properties p = new Properties(); p.put("user", "sa"); p.put("password","dss"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection( url, p ); String insertCommand = "INSERT INTO employee VALUES(" + args[0] + ",'" + args[1] + "'," + args[2] + ")"; Statement stmt = con.createStatement(); int count = stmt.executeUpdate(insertCommand); System.out.println(count + " row(s) inserted"); con.close(); } }

  • jdbcsugamber April 17, 2012 at 12:22 AM

    import java.io.*; import java.sql.*; import java.util.*; class database { public static void main(String...a)throws IOException { try{ Class.forName("com.mysql.jdbc.Driver"); Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/ashish","root","sugamber"); Statement st=conn.createStatement(); Scanner sc=new Scanner(System.in); String user_name=sc.next(); String password=sc.next(); ResultSet rs=st.executeQuery("SELECT * from user_master where login_name='"+user_name+"', password='"+password+"' "); if(rs.next()) { if(rs.getString("user_type").equals("admin")) { System.out.println("Welcome Admin"); } else { System.out.println("Sorry u r not admin"); } } else { System.out.println("Invalid User"); } } catch(Exception e) { System.out.println(e); } }} this is the code and i want connect with MYSQL database than i found java.lang.classnoyfoundexception <com.mysql.jdbc.driver> how to solve this problem? plz help me

  • SQLrajesh April 28, 2012 at 11:54 AM

    In OODBMS can sql implemented, is it possible?

  • CSEshovon May 5, 2012 at 6:44 AM

    no comment

  • LollllAnarkali May 27, 2012 at 11:50 AM

    Thanks

  • DB2tanya May 28, 2012 at 9:09 PM

    I want the full explainatory tutorials of DB2.

  • dbmsshobhakant June 8, 2012 at 6:49 AM

    i think better.

  • dbms & rdmsrachita June 9, 2012 at 3:08 PM

    difrance between Dbms & Rdms

  • Sir,Venkatesh June 11, 2012 at 5:06 PM

    It's very good to open one site for us to learn

  • DBMSbharath June 21, 2012 at 9:57 PM

    how can we use this dbms software in IT industries?

  • registeredswitchcon July 3, 2012 at 1:50 PM

    i want to post

  • About DBMSSatyanarayana Goud July 7, 2012 at 10:24 PM

    VERY IMPRESSIVE WAY OF EXPLANATION,IF DIAGRAMATIC REPRESENTATION IS THERE IT WILL BE MORE INFORMATIVE TO REMEMBER

  • SQLITE query formationabhishek gaur July 26, 2012 at 5:23 PM

    create table DATA (IMAGE_ID ,IMAGETimestamp, IMAGEFilePath ); create table FRAME(FrameID,VideoStartTime, VideoEndTime,VideoFile path); here the Image id is primary key and frame ID is foreign key i want to join the tables in such a way that FrameID did not come in the joined table as the entries of the Imageid and frame id are same i applied the query by left outer join but it is huge can someone help to reduce the size... select DATA.Img_ID,DATA.Img_Type,DATA.Img_FilePath,DATA.Img_TimeStamp,DATA.Img_Lat,DATA.Img_long,DATA.Img_Country,DATA.Img_City,DATA.Img_Landmark, DATA.MPEG7FILEPATH,DATA.Img_Title,DATA.Img_Creator,DATA.Img_Description,DATA.Img_Keyword,DATA.Img_Genre,DATA.Img_Rate,DATA.Img_Copyright, FRAME.VIDEOSTARTTIME,FRAME.VIDEOENDTIME,FRAME.VIDEOFILEPATH from DATA left join FRAME on DATA.Img_ID=FRAME.FRAMEID;

  • mysql code to do this.Jane July 27, 2012 at 1:19 PM

    Can you please give a way forward to accomplish this: You are provided with a database backup to aid you in performing a data import for a hospital. The backup contains a single table that will act as your extract/source data. Required: Create a normalized database that will capture the details for the patients and NOKs(next of kins). N.B. Only one address and telephone table respectively should cater for both NOK and Patient addresses and phone records respectively. All fields must be mapped into the database structure you i create. The following fields are lookup fields and so should be thus implemented; sex,title,maritalstatus,religion,ethnicity,noktitle,nokrelationship Visibility of system status should be implemented and the messages should not be verbose (make them brief and to the point)

  • Database CorruptionGOODLUCK YOBANA August 14, 2012 at 1:08 PM

    What could be done when the database is corrupt?

  • databasebalwinder kaur August 15, 2012 at 11:21 AM

    how to perform normalization

  • sql/plsqlarunkumar August 15, 2012 at 7:24 PM

    depth of sql/plsql

  • dbmsgaurav sharma August 25, 2012 at 2:46 PM

    what is the mdi form

  • DB design for Fkrepresent multiple tablesRavisankar December 27, 2012 at 11:05 AM

    Customer ,sites,books and authors each is individual entity but every entity has the notes entity is one many relation ship so how i need to design the table at database side.

  • databasekesego lesaso September 3, 2012 at 7:25 PM

    examples of database

  • history of bioinformaticsSubha prasana jena September 4, 2012 at 11:24 PM

    i am the student of North orisa univesity in bioinformatics. s

  • about talentvicks September 10, 2012 at 4:56 PM

    u r very talented

  • SQLsajid uddin December 13, 2012 at 5:51 PM

    hey, I want the PLSQL tutorial covering all the concepts.. with appropiate examples.

  • Best Databse with Java on Windows & plateform.Manish Dixit September 20, 2012 at 11:05 PM

    Sir, I have to work on many projects at the same time and each have some database. I even now could not found a very much suitable database with all appropriate drivers that can be used with java development and can be deployed also onto the client side. There are many types of problems I face, sometimes Database server could not start, somewhere required drivers cound not be found, some other time null values could not be inserted into a connected database table. In short I am very much exhusted when I am working on different project at the same time. I think You are getting my point and thankfull very much to You if you can provide a guidance and suggest the best compatible database with java on every windows OS. Yours, Manish Dixit

  • insertion..!Divya Dhage September 21, 2012 at 5:07 PM

    What is DataBase insertion..?

  • jspgeorge fernandas September 30, 2012 at 5:22 PM

    how to write a jsp program for student registration form and retrieve the value from the database

  • jspgeorge fernandas September 30, 2012 at 5:29 PM

    how to write jsp program to create student information in randomly.using random button

  • dbmsRajendra singh October 3, 2012 at 3:11 PM

    any ask qution

  • java with dbmschandra shekhar parmar October 13, 2012 at 9:23 AM

    sir, i have a problem in jsp i want to write a code in jsp and the code of submit form(submit button) and code of insert data i want to write in same page but my program is not working.... why this is happing???

  • crijwan October 15, 2012 at 11:42 AM

    nice

  • DBMSTwesh srivastava October 26, 2012 at 6:36 PM

    u give us a huge knowldge but its need some clarifies ofr every topic so if u do that we will helpful... thanku..

  • meWJTVyzKlKMNNoWCBagna October 26, 2012 at 7:17 PM

    On added point to mention here is that with Access teabls you can store up to 255 fields not that I would recommend this as it can affect performance. The file size can grow to 2GB should you need the space.With MS Access queries, the capacity of the number of fields is the same but they can be combined from up to 32 teabls with 16 joins a heavy duty query!

  • database managementLingani Petros October 26, 2012 at 8:32 PM

    i need steeps on desining database and exrcises on and its terminology, guide on how to make quiery,form and reports.

  • database managementLingani Petros October 26, 2012 at 8:35 PM

    i need steps on desining database and guide on making quiery,form and reports

  • databasenaqib wazir November 11, 2012 at 2:29 PM

    u have explained the term dbms very well

  • explain databasekush kumar May 8, 2013 at 12:44 PM

    for examnple class.forName DriverManager.getConnection con.createStatement(); st.executeUpdate com.mysql.jdbc.Driver Connection con; PreparedStatement ps; Result set please explain this ... please send my email or give me url .. thanks...

  • objective cprudhvi May 9, 2013 at 12:29 PM

    its nice to follow

  • RXMBMCYxuirdkMimosa June 15, 2013 at 4:27 PM

    You got to push it-this esesntail info that is!

  • hgWZWaXEAoKaress June 15, 2013 at 5:25 PM

    Me dull. You smart. That's just what I nedeed.

  • DBMSSony Appi July 29, 2013 at 1:22 PM

    It is my favorite subject in computer course... I want some more information about SQL and database management... Thanking you....

  • to know about programs atul rajput September 26, 2013 at 11:10 PM

    i want to know all details of programs by step by step solving method

  • datastructuresakila October 1, 2013 at 4:58 PM

    i want source code for hill climbing algorithm using java using steepest ascent method and primary dual method

  • copro1Emil October 8, 2013 at 1:44 PM

    i want to know more about java programming!

  • about database k.thilagavathi December 11, 2013 at 12:25 PM

    how to insert the value using database connection with jsp bean class

  • Data baseMuhammad Usman July 2, 2014 at 7:04 PM

    What recommended book of data base for begginers?

  • Data structureMuhammad Usman July 2, 2014 at 7:07 PM

    what recommended book of data structure for begginers?

Post your Comment



Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Related Articles
Database-Tutorials

Database Management System (DBMS)
Database Management System (DBMS) A Database Management System... management system (RDBMS). A newer kind of DBMS is the object-oriented database... Among several types of DBMS, Relational Database Management System (RDBMS 

Database-Tutorials

Database Management System (DBMS)
 

General

Ask DBMS Questions online
database management system (RDBMS). A newer kind of DBMS is the object-oriented...;    DBMS stands for Data Base Management System... on any software of DBMS or RDBMS (Relational Data Base Management System) if you 

Java Beginners

for management system
for management system  i need to store some data and to display the stored data and again to modify the data that have been stored and also with either java swing or java awt in format of similar to tat of form 

JSP Servlet Questions

Employee Management System
Employee Management System  coding for employee management system 

JSP Servlet Questions

Employee Management System
Employee Management System  coding for employee management system 

JSP Servlet Questions

coding for employee management system
coding for employee management system  coding for employee management system 

JSP Servlet Questions

library management system
library management system  coding for library management system 

Swing AWT

Bank Management System
Bank Management System  I need a Bank Management System Project in Java Swing 

Applet Questions

Attendence Management system
Attendence Management system  coding for Attendance management system using java applet 

JavaMail Questions

attendance management system
attendance management system  i want to project demo on attendance management system 

Java Interview Questions

Pharmacy Management System
Pharmacy Management System  hi all i wanna Pharmacy management system in java or vb.net or web application >> << thx all 

Java Beginners

contact and activity management system
contact and activity management system  how to make a web application on contact and activity management system. can anyone help me 

JSP Servlet Questions

generic workflow management system
generic workflow management system  How to design a generic workflow system for applying scholarship and its processes in online 

Design concepts & design patterns Questions

generic workflow management system
generic workflow management system  How to design a generic workflow system for applying scholarship and its processes in online 

Java Beginners

material management system
material management system  hi frnds i need a mini project based on material management system if u have the project please post to me on java beginners 

JSP Servlet Questions

Hostel management information system
Hostel management information system  Can u send me mvc based project of hostel management systenm source code 

Design concepts & design patterns Questions

Complaint Management System
Complaint Management System  Hi......i have to create a complaint management system where the user calls a toll free number and a computerized voice... with the complaint number. I have no idea as to how I should go about this system 

JDBC Questions

Student Management System
Student Management System  Hi , Friend can i get the solution for connecting login page of JFrames to JDBC 

HTML Questions

DBMS
 

SQL Question

DBMS
 

SQL Question

DBMS
 

SQL Question

DBMS
 

Design concepts & design patterns Questions

dbms
dbms  **can u please explain how to create a database in simle manner in windows 

Java Magazine Questions

dbms
 

SQL Question

DBMS
 

JDBC Questions

DBMS
 

Java Beginners

STUDENT MANAGEMENT SYSTEM
STUDENT MANAGEMENT SYSTEM  can any one help me with the coding if this using awt please!!!!!!! STUDENT MANAGEMENT SYSTEM Table details Student (STUDENTID, NAME, ADDRESS, PHONE, MAILID, COURSEID (Foreign Key)) Course (COURSEID 

Swing AWT

hospital Management System
hospital Management System  hello sir i want hospital management system Source code in java swing Back-end Oracle 9i. i want these type of model 1... all, delete,save plz give me the full source code with database 

Java Beginners

Fleek Management System(FMS)
Fleek Management System(FMS)  Hi, Please anybody can reply....I wanna develop a project(FMS) in Java , which was already developed in PHP. Now what technologies should i apply for developing this project. The main aim 

DMCA.com