Posts
 
Reputation
Joined
Last Seen
Ranked #438
Strength to Increase Rep
+6
Strength to Decrease Rep
-1
91% Quality Score
Upvotes Received
11
Posts with Upvotes
10
Upvoting Members
9
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
6 Commented Posts
~82.4K People Reached
Interests
writing books, traveling n Programming
Favorite Tags
Member Avatar for VenusCrystal

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

Member Avatar for Shiwam_1
0
65K
Member Avatar for garyrichard

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 …

Member Avatar for Shivraj_1
0
616
Member Avatar for king03

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 …

Member Avatar for BitBlt
0
121
Member Avatar for koros.komen

Hello, koros.komen, Why not post what you have so far. The Tables and structures and we'll advise from there.

Member Avatar for diafol
0
252
Member Avatar for dean.ong.14

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

Member Avatar for seslie
0
105
Member Avatar for king03

In addition to Urtrivedi, Please post what codes you have so far, and the errors you are getting

Member Avatar for seslie
0
73
Member Avatar for king03

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 …

Member Avatar for seslie
0
207
Member Avatar for caierhui

Hi caierhui, I don't really get your question. What exactly do you want to do and in what context?

Member Avatar for seslie
0
89
Member Avatar for jtodd

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) …

Member Avatar for seslie
0
156
Member Avatar for akkbkht

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 …

Member Avatar for HunainHafeez
0
309
Member Avatar for papadarl

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?

Member Avatar for lps
0
69
Member Avatar for rithish

Hello rithish, try opening the sql command line and connecting to your database, e.g [CODE]Conn system as sysdba[/CODE]

Member Avatar for seslie
0
234
Member Avatar for HunainHafeez

Hello HunainHafeez, please see this link http://www.daniweb.com/web-development/databases/threads/430095/user-roles Regards

Member Avatar for HunainHafeez
0
94
Member Avatar for code739

> 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

Member Avatar for code739
0
173
Member Avatar for anthonyjpv

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.

Member Avatar for seslie
0
119
Member Avatar for Sadun89

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.

Member Avatar for JorgeM
0
180
Member Avatar for kahindi

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 …

Member Avatar for amrita111
0
116
Member Avatar for pjdomingo

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

Member Avatar for pjdomingo
0
89
Member Avatar for DJWK
Member Avatar for TheSomalilander
Member Avatar for ganges

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

Member Avatar for debasisdas
0
125
Member Avatar for 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 …

0
117
Member Avatar for bflack

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

Member Avatar for veedeoo
0
200
Member Avatar for sreelavanya
Member Avatar for london-G

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 …

Member Avatar for seslie
0
130
Member Avatar for rhfh

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 …

Member Avatar for 1stDAN
0
3K
Member Avatar for sneha_07

Hi sneha07, What kind of applications are you looking to develop? Have you heard of Oracle Application Express (APEX)?

Member Avatar for seslie
-1
99
Member Avatar for monstercameron

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 …

Member Avatar for seslie
0
103
Member Avatar for tekboi

Necroposting: You prob didnt look at the dates or simply ignored the 'dead thread' notice. Well, thanks 4 d info though.

Member Avatar for seslie
0
366
Member Avatar for almoj4ever

@debid25, Wrong Section, man. @almoj4ever, what exactly is your problem? what's the question? where's your attempt? Anything to help us help you...

Member Avatar for seslie
0
97