Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
100% Quality Score
Upvotes Received
1
Posts with Upvotes
1
Upvoting Members
1
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
0 Endorsements
Ranked #4K
Member Avatar for haria_kishore

Hi I have a master table Company info where information like revenue, profit, expenses etc are captured. Now i want to retrieve companies who has made profit every year since last 5 years. Issue is some company have latest data of 2017 and some have latest dat until 2016. How …

Member Avatar for pty
0
100
Member Avatar for haria_kishore

Hi guys I am new to workflow but i have a task ahead of designing a workflow management for an organisation We have Windows 2003 Server installed on one system which acts as Oracle application server I want lots of details 1) How to go about creating a workflow from …

Member Avatar for AdrianChestnut
0
107
Member Avatar for haria_kishore

hi I have 3 tables - table1,table2,table3 table1 has 3 columns named col1,col2 and col3 and has 1 dummy record with values 0,1,2 respectively. The other records are my master records col1 col2 col3 0 1 2 A B C AA BB C D E F table 2 has the …

Member Avatar for anubina
0
86
Member Avatar for pratapchiluveru

hi! All I have the problem with Watson postmortem and windows explorer problem. Nearly for every 10 or 20 min it displaying the message "Windows has encountered a problem and need to close", and then Dr Watson postmortem problem error, and then hangs up the system. I am wondering what …

Member Avatar for pratapchiluveru
0
314
Member Avatar for haria_kishore

Hello everyone I need a solution for my problem. The solution can be a simple PL/SQL block or a trigger I have a table called T_SBSTTN_VLTG_MSTR with following data SBSTTN_CD VLTG STTS DT_ENTRY FK_TM_ID 10111111 11 Existing 2/9/2009 19:32 10144 10111111 33 Existing 2/9/2009 19:32 10144 10111111 132 Existing 2/9/2009 …

Member Avatar for debasisdas
0
84
Member Avatar for haria_kishore

Hi Guys I have designed reports in Discoverer Plus and the users are viewing the report using viewer. My need is that suppose there is a report which is made. Now if some user views the report by changing the layout and save the changes. Now problem is the change …

Member Avatar for alit2002
0
489
Member Avatar for haria_kishore

Hi everyone I have one master table with the following structure incm_id Category SubCategory 1001 Expenses A 1002 Expenses B 1003 Income C 1004 Income D I have a child table where i am capturing amount value for the above table and structure is something like id fk_incm_id Amount 10001 …

Member Avatar for alit2002
0
115
Member Avatar for haria_kishore

Dear friends Can anyone pls help me with this I need to create radio buttons where 1st option will have 2 sub options as shown below 1)Closely held company Sole Proprietor Family owned 2)Public company with minority float 3)Public company with majority float If the user selects "Closely held Company" …

Member Avatar for U.K.
0
130
Member Avatar for haria_kishore

Hi friends I am designing a questionnaire where at one particular page i need to ask the user "Number of projects" Based on the number provided and when he clicks next, he should get the table with rows equal to the number provided. The columns will be fixed . Can …

Member Avatar for peter_budo
0
153
Member Avatar for haria_kishore

Hi everyone I have a table with 3 columns pk_itm_code name fk_code The pk_itm_code is taken from another master table. Now my requirement is automatic generation of fk_code fk_code = pk_itm_code + "PT" + random generated no. (startin from 1) If the user selects same pk_itm_code 2 times then the …

Member Avatar for Comatose
0
76
Member Avatar for haria_kishore

Hi friends Can someone help me in this pls.I have 2 tables in my DW One is a table which have all data regarding Income and Expenditure details. The structure (columns) of the table is ctgry_id,ctgry_nm,sbctgry1_nm,sbctgry2_nm,amount.,cmpny_id and tm_id So the records in this table would look like 10001 Wages and …

0
54
Member Avatar for haria_kishore

Hello friends Actually i need a small help. I have 2 enviornment with 2 different databases .one is development and one is testing. All development and design work is done in Development work and once in a week we take database dump from development to testing enviornment Actually the procedure …

Member Avatar for chrisbliss18
0
71
Member Avatar for haria_kishore

Hello friends I have created 2 reportsin Oracle 10g Discoverer . One of which looks like below [B]Asset item Opening Balance Additions Decuctions Closing Balance[/B] Item 1 3 0 2 1 Item 2 4 0 3 1 Item 3 5 0 4 1 Total (Item 4) 12 0 9 3 …

0
67
Member Avatar for haria_kishore
Member Avatar for haria_kishore

Hi friends I just wanted some help on Oracle Warehouse Builder(if anyone has used it). I have designed a dimension in DW which actually is based on more than 3 tables in my source database.Now I want to map these 3 tables to the dimension. But I m facing some …

0
95
Member Avatar for peter_budo

I am supposed to write an query which will add new attribute to my already existing table So I written this [I][B]ALTER TABLE member ADD e_mail CHAR(20)[/B][/I] which is fine, however when I try insert required data for each row I get stuck [I][B]INSERT INTO member(e_mail) VALUES('johnwhite@msn.com');[/B][/I] Can anyone help …

Member Avatar for peter_budo
1
1K
Member Avatar for haria_kishore

Hi guys, sorry to trouble u guys,but can't resist Actually i have a table (transaction table) in which i have got customer id(can have more than one record with same id) ,acc no, and type (either credit or debit). Now i want to find the balance of the customer by …

Member Avatar for haria_kishore
0
105
Member Avatar for haria_kishore

Hi everyone can anyone please help me to define the dimension table for EMPLOYEE I need to design the dimensional table with the hierarchy starting with Board of Directors(which is sub categorised into Staff for Board of Directors which again is subcategorize into Technical, Administrative and Accounts) Then we have …

Member Avatar for autocrat
0
132
Member Avatar for haria_kishore

Hi everyone I am new to the world of VB Actually I wanted to know if anyone knows that how to validate option button For example I create 3-4 option button(radio) and would like to check if the user has clicked on any of the button and then it should …

Member Avatar for GraveyDice
0
199
Member Avatar for haria_kishore

Hi everyone Our company is using Oracle Datawarehouse builder as a tool to create DW. some of my friends suggested me to use different tools like DW toolkit... Which is the best tool that i can go for so that i can suggest my company the advantages of those tools …

0
103
Member Avatar for nikkinak

Hi, can anyone build me a programme in any language VB, C or C++ mainly for a salon if you could do it then i will give the main specs for the programme, money in it £350. regards nicky ;)

Member Avatar for haria_kishore
0
88
Member Avatar for haria_kishore

Hello guys Actually I am new to the world of datawarehousing. In fact today is my third day. Actually I am working in an organization where I have been given the responsibility of designing a datawarehouse. The operational database is already being created and I have to post the past …

Member Avatar for autocrat
1
138
Member Avatar for SPARKY123

It has been a long time since I have programmed anything. Grew-up in the 80's using basic. I am currently somewhat fluent in JAVA(R) but I need some help understanding the current state of databases. I am developing a cd that needs a stand alone database for the Java program …

Member Avatar for haria_kishore
0
106