Our Databases forum encompasses everything related to data storage, both for the web and other uses.

13 6 5 5 4 4 3 3 3 3
Member Avatar
Hi, I have installed Oracle 11g (latest version 11.2.0.1.0) on my system. During the installation it didnt ask me to set username or any password. I'm unable to start sql plus because i dont have the username and password. Can anyone tell me what is the default username and password …
by VenusCrystal in Databases ()
Member Avatar
/DROP TABLE STATEMENTS/ DROP TABLE BRANCH CASCADE CONSTRAINT PURGE; DROP TABLE SCREEN CASCADE CONSTRAINT PURGE; DROP TABLE SESSIONS CASCADE CONSTRAINT PURGE; DROP TABLE MOVIE CASCADE CONSTRAINT PURGE; /CREATE TABLE STATEMENT/ CREATE TABLE BRANCH( BRANCHID CHAR(2)NOT NULL, BRANCHNAME VARCHAR2(20), BRANCHSUBURB VARCHAR2(15), BRANCHPOSTCODE CHAR(4), CONSTRAINT BRANCH_PK PRIMARY KEY(BRANCHID)); CREATE TABLE SCREEN( SCREENID …
by nathan_8 in Databases ()
Member Avatar
Hi Guys! i need some help, with recurring invoices or payments. I have Application which i developed recently to my customer. And inside of App i got a module to invoice clients, for a product, which this product is valid only for one year starting may for each year and …
by hell hansen in Databases ()
Member Avatar
Good afternoon, Currently, I’m trying to consolidate all my financial information into one place so that I can see (the solution I’m currently using is Excel – see attached): 1. Valuation at a particular date 2 .Breakdown by investment product 3. Various other analytics (Allocation by class etc.) I’ve tried …
by ShortYute in Databases ()
Member Avatar
Hi, I was asked by my lead engineer to configure and migrate current database to elasticsearch that he believe will overcome the slow query issues . We are using laravel 5.2 , and using Amazon Web Services : Amazon Elasticsearch Service . I already done a proof of concept on …
by Muaz_1 in Databases ()
Member Avatar
I have been trying to insert,update,delete,select with separate queries.But when i try to write a query after a pre-written query i get an error that the string is predefined.I am working on a PBL project so i have to show all that in one program itself. Here is the current …
by sumod in Databases ()
Member Avatar
For Each itm As ListViewItem In ListView1.Items If itm.Text <= CStr(56) Then itm.BackColor = Color.Orange Else itm.BackColor = ListView1.BackColor End If Next this codes change background color of all items in listview....but i just want to change the forecolor mu value of stocks in listview in a column stocks..not all …
by PEM_1 in Databases ()
Member Avatar
I have a query that get the balance for last month and current month balance. I'm using a function inside the view that took more than 30 minutes. May I ask your help guys any idea or approach to speed up the processing or optimize the script it can be …
by jovillanuev in Databases ()
Member Avatar
Hi, I want to delete about 60 crore records from few oracle audit tables to free up some space. I am planning to delete them in batches of size 10,000. I dont want to use up lot of space while performing these deletes. Can someone suggest me a way to …
by saravind84 2 in Databases ()
Member Avatar
I have a table in mysql with the following data: | StartDateTime | FinishDateTime | | 2016-08-18 10:00:00 | 2016-08-18 11:00:00 | | 2016-08-18 12:00:00 | 2016-08-18 14:00:00 | | 2016-08-31 17:00:00 | 2016-09-01 09:00:00 | What I would like to get as the output is | Month | Duration …
by A_7 in Databases ()
Member Avatar
Sir I want to generate a query which will convert data from rows to columns I have this table ![aa.png](/attachments/large/4/266c6d1b9efd2e2621152dc5a3cad11e.png "align-center") I want to get this result ![bb.png](/attachments/large/4/54b2cbea895fc42a71c7e5109c612946.png "align-center") [IMG]http://i66.tinypic.com/2hfjep4.png[/IMG] Workers amount will go to column in relevant data Group by code. I wrote this query session_start(); require_once("includes/connectw.php"); $query = …
by phphp in Databases ()
Member Avatar
After a server issue, my client has restored the MySQL files before their issue, but MySQL is having problems bringing their database back up. (i'm waiting for more information as the exact nature of the issue) I have the ibdata1 ib_logfile0, and ib_logfile1files, and all the .frm and .ibd files …
by archibald_1 in Databases ()
Member Avatar
Iam using windows 7 32 bit and Oracle 11g SQL> spool off SQL> host type c:\spool.txt The system cannot find the file specified. help me to solve the above ploblem
by ganges in Databases ()
Member Avatar
File drop database if exists contacts create database contacts; use contacts; create table names ( ID mediumint not null auto_increment primary key, firstName varchar(20), lastName varchar(20) ); create table addresses ( ID mediumint not null auto_increment primary key, nameID mediumint not null, addr1 varchar(30), addr2 varchar(30), city varchar(30), state varchar(10), …
by lewashby 14 in Databases ()
Member Avatar
Create Table Non_Game ( P_Id int Not_Null, Item_Num Char(4) Not Null, Description Char(30), On_Hand Decimal(4,0) Category Char(3) Price Decimal(6,2), ))
by Drew-Shawn in Databases ()
Member Avatar
this is the response i get (1045, "Access denied for user 'point3hu_leo'@'197.253.66.85' (using password: YES)") Press any key to continue . . . from pony.orm import * db = Database() db.bind('mysql',host= 'poin.com',user='pointeo', password = 'lxxxx',db = 'poi_data')
by mcroni in Databases ()
Member Avatar
Hi Please why I got this error(SQL Error: ORA-00907: missing right parenthesis) whats wrong in my code? CREATE TABLE artphoto( photonr NUMBER(10), artnr NUMBER(10) NOT NULL, filtyp VARCHAR2(5) NOT NULL, path VARCHAR2(100) NOT NULL, CONSTRAINT artphoto_photonr_pk PRIMARY KEY(photonr), CONSTRAINT artphoto_artnr_fk FOREIGEN KEY(artnr), REFERENCES art(artnr), CONSTRAINT artphoto_filtyp_ck CHECK(filtyp in ('gif','jpg')) ); …
by tony75 10 in Databases ()
Member Avatar
I have Post code column and I want to get 60, 30 and 10% for each area code that I have, but the thing is there is a between statement which makes things a bit complicated. I need 60% from the first postcode then 30% from the second and 10% …
by kgizo in Databases ()
Member Avatar
Hiii I want to use select in select clause this is my statement which got an error: [code=sql]Select count(*) as cnt, (select count (answer_q1) from answers where (answer_q1 = 'ضعيف'))as a_q1 FROM Answers[/code] and this is the error: Error in SELECT clause: expression near 'SELECT'. Error in SELECT clause: expression …
by q8_dreamy -1 in Databases ()
Member Avatar
Group, I've written what I believe is fairly simple code to populate a combobox via data from an Oracle Database. Unfortunately it isn't working and the error in the output box says: "Exception thrown: 'System.BadImageFormatException' in OracleConnections.exe" (the name I've assigned to the program is "OracleConnections"). This is not an …
by doncwilson_1 16 in Databases ()
Member Avatar
: CREATE TABLE CUSTOMERS ( CUSTOMER_ID numeric(3) not null, LASTNAME varchar(50) not null, FIRSTNAME varchar(50) not null, STREET_ADDRESS varchar(50) not null, CITY varchar(50) not null, STATE char(2) not null, ZIPCODE char(5) not null, E_Mail varchar(50) null, Primary_Phone char(12) null, CURRENT_BALANCE real(8,2) not null, CREDIT_LIMIT real(8,3) not null, SALES_REP_ID numeric(3) not …
by Pam Thomas in Databases ()
Member Avatar
I'm not sure whether this is a good question for this forum but, I'm struggling to set up a database to use in my school academic system that is supposed to record all student's scores and then be able to prepare a report that shows students ranks. The hardest part …
by savedlema 17 in Databases ()
Member Avatar
Sir I have this query and result [IMG]http://i66.tinypic.com/4r7oee.jpg[/IMG] Now I want to modify query to get result like this [IMG]http://i65.tinypic.com/11aihzs.png[/IMG] Please help
by phphp in Databases ()
Member Avatar
I am banging my head again, and appologise if such a qestion has been posted and answered - i searched and could not see any results matching my question. I have a datagridview1 full of data, one column has a date and another a qty. datagridview1 Date Qty 2015-11-05 | …
by Oxley_1 in Databases ()
Member Avatar
Hi, I am developing a mobile app for a health care institution. I'd like to get a suggestion on how to approach my database design. There are many user types of this app; residents, nurse, and general-staff. The "resident" has many information that other types don't have; unit_number, food_allergy, emergency_contact, …
by ikel in Databases ()
Member Avatar
I need to develop aa database to store stock taking information and sales. I was going to use MS Access to strructure and make all the logistics for my database since im quite friendly with access and i find it easy to use. MY problem is, i want this database …
by Joseph_24 in Databases ()
Member Avatar
Hi all, I'm using the Laravel framework to create an application, and have a database question. I have a table called `posts`. I have been pulling the 10 most recent rows from here and making use of an offset variable for pagaination. Now however I also have a table `media` …
by James_43 15 in Databases ()
Member Avatar
Hi everyone! I am in major need of some help here and before I go off and write a SP to handle this for me, I though I would ask here for advice first. I am writing a report to display on our asp.net site using the ReportViewer component and …
by zachattack05 56 in Databases ()
Member Avatar
Hi group, I've looked all over the internet to find my solution without luck. Hopefully you can help. I need to add an Oracle server to my data sources in Visual Studio (if it matters, I'm using VB.net). Per the best instructions I've found so far, I've selected "Data Sources" …
by doncwilson_1 16 in Databases ()
Member Avatar
sir can you help us or give us an idea in our System Tutorial (Thesis) in our subjet Software Enginieering, our professor required us to make a system that is not yet existed, Examples Grading system, Inventory System, Using VIsual basic 10 with the connection of data base, . sir …
by _1_36 in Databases ()
Latest Posts