Tagged Questions

A database is an organized collection of data.

learn more… | top users | synonyms (3)

0
votes
0answers
3 views

reuse the function in oracle depending upon column passed

I have a function which I want to work in different way depending upon the column passed. I am calling that function in an UPDATE statement. If I pass col A of a table then the case1 of the function ...
0
votes
0answers
5 views

PL SQL - select column_name from user_triggers always returns an empty string

I'm doing a script in pl/sql where I create triggers creation scripts using data from "user_triggers" view. I need to get the name of the column referenced by the trigger. It's value should be in ...
0
votes
0answers
5 views

How to query a database using CollectionView's own filtering support?

I'm learning WPF for one of our projects. The software we are writing generally connects to databases with thousands of records. Let's say I am using a ListView for showing these records, but I don't ...
0
votes
1answer
8 views

XSLT: DB procedure output to XML structure

I am having a little problem with XSLT transormation and I need your help. I received from database procedure data as follow and I need to transform it to less redundant structure. The structure of ...
-7
votes
6answers
45 views

What is this variable $q? [closed]

$sql="SELECT * FROM user WHERE id = '".$q."'"; And what do these periods around the variable do? I'm new to php, so forgive my ignorance.
0
votes
2answers
22 views

Schema design: How do you incorporate “total”?

I am currently building a scoring table for my items. Each item has a score so the database (postgres) can sort the item by scores and return them to the user. Currently, the total score of the ...
1
vote
1answer
7 views

MySQL Global Triggers for a connection

Is it possible to create a trigger that will listen for any insert or update for one database connection/instance (all schemas)? Here is my business case: I have multiple schemas on one MySQL ...
0
votes
0answers
12 views

pl sql - where should I look for the document genereated using pl sql htp package

I'm working at a project that uses the htp package from ORACLE SQL. For example, if I run this procedure, where the webpage will appear? How can I see the page generated? CREATE OR REPLACE ...
0
votes
1answer
7 views

The best way of creating a simple voting system

I want to create a simple voting system, where people can vote for a candidate and the the votes for each candidate gets displayed on the website dynamically. No I am a front-end developer and do not ...
0
votes
0answers
3 views

Database | Google Product Feeds Field Length

Trying to construct a database to hold a bunch of product data. The plan is to programmically generate TXT (Text tab delimited) filed and upload to Google, Amazon, and Bing (all use Google Product ...
0
votes
1answer
11 views

iOS program to display database contents in app seperated by tabs

I have a program that connects to a MAMP server and selects my database and displays the contents in the Xcode simulator. Right now I have 2 tabs and the data is the same for both. I want the tabs to ...
0
votes
0answers
6 views

Dimension tables that “inherit” attributes from other dimension tables

What should you do when you have two dimensions, one of whose attributes end up directly coming from the other dimension? For instance, a customer applies for a loan and each application specifies ...
0
votes
1answer
23 views

Trying to make copy of table using subquery

SO I am trying to make a copy of a table I just created. I named it grad candidates. Using what I know so far this is how it should look like. I want to name the copy of the table harmeier. CREATE ...
0
votes
1answer
26 views

mysql Access denied for user “xxxxx” (using password: YES)

I am getting this error everytime im trying to connect to my database Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user '*USER*' (using password: YES) in ...
-1
votes
1answer
29 views

oracle sql(missing left parenthesis

Im trying to create a table named grad_candidates CREATE TABLE grad_candidates (student_id NUMBER(6), last_name VARCHAR2, first_name VARCHAR2, credits NUMBER(3), ...

1 2 3 4 5 … 3560
15 30 50 per page