- Strength to Increase Rep
- +7
- Strength to Decrease Rep
- -1
- Upvotes Received
- 11
- Posts with Upvotes
- 10
- Upvoting Members
- 9
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
- Interests
- writing books, traveling n Programming
87 Posted Topics
 | Hello VC, Check these out, hope it helps. [Click Here](http://oradim.blogspot.com/2007/11/oracle-11g-and-ora-01017-invalid.html) [Click Here](http://stackoverflow.com/questions/740119/default-passwords-of-oracle-11g) But i should think ypu had to enter a password during the installation process  |
 | Hello garyrichard, Well, first of, you need to post what you've been able to do. That said..are you entering these values manually? I should think there'll be a predefined query that generates them. If it's already an hard coded table and you just need to find the missing sequence, then …  |
| | Hi King03, E and M are known as Aliases. You can give a table or a column a different name through the use of an alias. This is useful and helpful if you have very long or complex table or column names. An alias name could be anything, but usually …  |
| | Hello, koros.komen, Why not post what you have so far. The Tables and structures and we'll advise from there. |
 | Hello dean, First, I assume you know what a database is. Basically, a collection of data that can be stored and retrieved. The purpose of a DB (Database) is to organize, store, and retrieve information as efficiently and effectively as possible. Google for more information Regards |
| | In addition to Urtrivedi, Please post what codes you have so far, and the errors you are getting |
| | Hello king03, In addition to rch1231's response, The table contains some data that you arent showing here. You are to majorly perform a 'select' query, whose syntax you should be familiar with. for e.g SELECT [column_name] FROM [table_name] WHERE (column_name = condition); For the first question, List '**Sold**' transactions for … |
| | Hi caierhui, I don't really get your question. What exactly do you want to do and in what context? |
| | Hi jtodd, That's the way to go. Your database is basically at the 'backend'. The user doesn't need to see this. You have to create a form of user interface (UI) that they can use to interact with the database. What you choose to implement this front end UI(e.g ASP.Net) … |
 | Re: User Roles. Hello akkbkht, From what i understand, you can do this by having, for example, a MEMBER_ROLE table e.g roleID | roleName | Description 1 Admin Administrator 2 Applicant bla bla bla and ofcourse, you have a member table.. memberID | firstName | lastName | roleID(fk) 1 Beautiful You 2 2 …  |
| | Re: Validation Hey papadarl, Could you be a little more specific as to what your problem is? What are you trying to do? What have you done? What issues are you having? |
| | Hello rithish, try opening the sql command line and connecting to your database, e.g [CODE]Conn system as sysdba[/CODE] |
| | Hello HunainHafeez, please see this link http://www.daniweb.com/web-development/databases/threads/430095/user-roles Regards |
 | > CREATE OR REPLACE PROCEDURE "MAINTAIN_REQUESTSTATUS1" (emplevel IN NUMBER,eid IN NUMBER,depid IN NUMBER,teamid IN NUMBER) is lastreq number; seq number; stat NUMBER; tok varchar2(60); appr number; I haven't tried this but you have four items within the bracket and five afterwards. Dont think you declared properly |
| | Re: Records & Tables Hello anthonyjpv, Checkout: [This](http://docstore.mik.ua/orelly/oracle/prog2/ch09_01.htm), [This](http://www.plsqltutorial.com/plsql-record/) and [This](http://docs.oracle.com/cd/B12037_01/appdev.101/b10807/05_colls.htm) . Hope these links help. |
 | Hi Sadun89, This all depends on what you're trying to do with your database. Depending on the information provided in the tables, you can choose whether or not to add a table or a column. If you provide more info, we should be able to help you better.  |
| | Re: projects Hi kahindi , What are you interested in? Do you want to create a web based system (probably the easiest of them all) or a mobile app, or something on networking, or graphics?? There's a whole lot to do. 1.You could also see past projects. There's usually a section that … |
| | Hello pjdomingo, You can ask them about the existing system --What it currently does --What problems they are facing with it --What improvements they'd like to see --Any ideas they might want to include etc Regards, Priscilla |
| | |
| | Hi TheSomalilander, What have you been able to do so far? |
| | Re: oracle queries Hello Ganges, what do you mean by complete list of queries? if you mean syntax, check out these links; [here](http://www.w3schools.com/sql/default.asp) and [here](http://ss64.com/ora/). Browse through them, should be helpful. Regards, Seslie  |
| | Hi Daniwebers, Is there anyone familiar with sharepoint? My question is on validation of dates in sharepoint… If i have two date fields – start date(& time) and end date(&time). How do i validate these, so that a person cannot pick a time in between these? For example, if someone … |
| | Hello bflack, it's pretty easy in oracle, you just use 'imp' and 'exp' commands to import and export respectively. see this [link](http://dev.mysql.com/doc/refman/5.0/en/copying-databases.html) for ideas on mysql  |
 | |
| | Hello London-G, from the database aspect, you would need a column (of data type BLOB - in oracle, don't know if this applies for other databases) on one of your tables (perharps personInfo) that would hold the image information. I am not very conversant with Java, so i don't know … |
| | Hi rhfh, Looks good to me, although i would make Rental table have its own unique primary key though. For example, what if a particular customer likes a particular car and wants to use that car more than once? check out this [link](http://databaseanswers.org/data_models/car_hire/index.htm) for a more comprehensive example. Be sure … |
| | Hi sneha07, What kind of applications are you looking to develop? Have you heard of Oracle Application Express (APEX)? |
| | Hi monstercamron, I just checked out your site. Good job! But, you still need to work on look and feel of it. It's inconsistent throughout the pages. The home page is still messy, you need to tidy that up. And the colours/themes? Not sure about them, well depends on what … |
| | Necroposting: You prob didnt look at the dates or simply ignored the 'dead thread' notice. Well, thanks 4 d info though. |
| | Re: Need Help In Sql @debid25, Wrong Section, man. @almoj4ever, what exactly is your problem? what's the question? where's your attempt? Anything to help us help you... |
| | Hi VC, in this table, > Table1 link - varchar > hlink - varchar > top-cap - varchar (FK) > sub-cap - varchar (FK) > lk - varchar(PK) Do the two foreign keys reference the same key on the second table? Please, could you put a sample of the kind … |
| | I would assume you know a little about Data types and i would suggest you read up on them. See these links [here](http://www.w3schools.com/sql/sql_datatypes.asp) and [here](http://dev.mysql.com/doc/refman/5.5/en/data-types.html). |
| | Hi soUPERMan, A 'join' clause would be best suitable for what you are trying to do. See this [thread](http://www.daniweb.com/web-development/databases/ms-sql/threads/422691/join-for-three-tables-in-mssql) for help on join. Try your hands in it and post back any issues you might have. also try this: select su.name from subject su, student st, student_subject ss where ss.studentID … |
 | Hi vimbai, There's a whole archive on what to do. And you have to be a little more specific. Are you familiar with any particular programming language? Do you want to create a web based system (probably the easiest of them all) or a mobile app, or something on networking, … |
| | Ok, just went through your posts 1. Read the [rules](http://www.daniweb.com/community/rules) 2. Please don't start another thread. Seems like they're about the same domain, so just stick to one until you get your answer 3. Be a lot more specific and clear with your questions. 4. Goto 1 |
 | Still need to practice anyways... :-) |
| | Hello Hastin, There are a couple of sample mvc projects on the official site; [here](http://www.asp.net/mvc/tutorials). They are sure to guide you as you get started. Best of luck ;-) |
| | Hi ravenous, Quick question: you assigned the enum types numbers but you didn't use them in the sample code. is there a reason for this? and also your code reads: if ( gender == eFemale ) // Use '==' here, not '=' { cout << "Male" << endl; // Print …  |
 | Re: make gallary As above. Search the forum (and internet in general) for information on database management systems. In summary: You'll need a database (e.g MySQL) where you'll have various tables relating to what you intend to do. (e.g cardInfo table with coulmns such as cardID (prob numeric), designerName (varchar2(50)), description(varchar2(100)), image(blob), e.t.c). … |
| | Hi shwetaaroa, in addition to above. You'd implement the button function on the front end of your application . At the database end, you'd need to connect to your database and update your table by using an sql upadte query syntax: UPDATE [table_name] SET [column_name] = value, [column_name2] = value2,.. … |
 | Hello abhi10kumar, checkout this [site](http://www.orafaq.com/wiki/SQL_FAQ#How_does_one_escape_special_characters_when_writing_SQL_queries.3F). And pls, try to write your codes legibly |
 | Hello andarivaadu1, These links, [link1](http://geekswithblogs.net/brcraju/archive/2003/10/23/235.aspx), [link 2](http://www.mkyong.com/regular-expressions/10-java-regular-expression-examples-you-should-know/), [link3](http://developer.gnome.org/glib/2.30/glib-regex-syntax.html) would help. Bonus: > A strings minmum length must be 3 charcters, and maximum length must be 12 characters ^[a-zA-z]{3,12}$ ^ #start of regex [a-zA-Z] # Match characters and symbols in the list, a-z, A-Z {3,12} # Length at least 3 characters … |
 | Re: DFD and ER Hello, I dont think there's any dependency between ERD and DFD. One can help with the other, i guess. As for database design, i'd say an ERD is closely related to that cos ERDs are basically database modelling tools. DFDs simply create an overview of the entire system. You and … |
| | Looks like you're having troubles with your CRUD (Create, Read, Update, Delete) functions. szabizs and nextus have posted right. Post what you've done and the exact errors you're getting and you'll be sure to get some help |
| | Hello mousumisrety (quite a name u got dere :-) ), I assume you've already created the form for the website you're talking about. It's pretty easy from there. First, you add a few validations to the database fields (e.g NOT NULL) so that the user is forced to enter a … |
| | Hello aadesi Now, you want to select a room that isnt booked between particular dates? SELECT * FROM TBLBOOKINGSROOM WHERE ROOM_ID = '111' AND STARTDATE IN ('07/05/2012') //this would depend on a variable AND ENDDATE IN ('07/05/2012')//this would depend on a variable Between can also be used but try this …  |
 | Hello mogaka , did you declare sku earlier? <?php $query = "SELECT emp_no FROM employees WHERE dpt_no = '%s'"; (....) $var = 'sku'; $qstring = sprintf($query, $var); mysql_query($qstring); ?> one question though...why is $account not in single quotes while $sku is? |
 | Hi poojavb, I can't see a 'join' clause anywhere in your query. You can use this syntax FROM table1 join table2 ON table1.primarykey = table2.foreignkey join table3 ON table2.primarykey = table3.foreignkey (or try changing your where clause to see if it works..worked for my sample table, although i didnt use … |
| | How about Tic tac toe? [something i saw](http://www.cs.millersville.edu/~webster/gametechnologytrack/CS475/XNA/misc/CBennettXNA2D31.pdf) |
| | Hello qwertpink , First of, your systemid column is might be cos ids generally are supposed to be unique. And next, a simple sql query might not work well to achieve this, so first question; Assuming there's another entry with id 1, do you have a new column 'phonenumber4' created? … |
The End.