Hi,
Our application calls a stored procedure to disable a foreign key constraint (simple, alter table table_name disable constraint constraint_name), and sometimes it can't because of ORA-0005...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23271940.html
Good afternoon,
I am searching for a way to identify the name of a db-object (package / view) dynamically. Specifically, I have got something in mind that works like "THIS" in Java or "ME" in VB...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23301300.html
Hi all,
I have around 17000 rows of data in table .
In that in I have 2 columns called
"expenses " and "savings" . of type varchar2
users are entering as 100 Euro or 100 euro or 100 EUro or...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23370026.html
I am curious about something and though I have looked on google, I wanted to check with some of the DB experts to get their thoughts. I am currently moving an app from VB6 to VB.Net (.Net 3.0). I...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23404056.html
Hi all ... scratching my head over this, but I suspect experts here may know it ...
If a table has fields:
PersonID (integer)
GMTDate (date)
TimePeriod (integer)
Channel (integer)
ReadIng...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23423557.html
Zones:
SQL SyntaxDate Answered: 05/22/2008 Grade: A Views: 0
Is it possible for me to do a statement as follows:
Select tbl.*
From tbl
Where (
if tbl.item = 'item_code' then
tbl.time_stamp BETWEEN TO_DATE('05/22/2008 19:00:00', 'MM/DD/YYYY HH24:MI:S...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23426653.html
How to display row value of each class as a column value
ID NAME CLASS HOURS SCHOOLNAME
1 Allen Maths 12 school1
2 Sam Maths 12 school1
4 Pam Maths 10 school1
3 Sam Comp 10 school1
9 ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23435417.html
Hi,
I have a table like sample_t2. It contains the value like below.
id name sal
1 A 1000
1 B 2000
1 C 3000
2 ...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23494118.html
Hi,
I want to create a ? cross-tab report?
I want to show columns accross top Jan - Dec
and show locations down the side and have the intersection show a calculation of that months numbers for...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23524337.html
Zones:
PL / SQLDate Answered: 07/02/2008 Grade: A Views: 0
I have a table that contains many Items....Item1, Item2, Item3...
Each of these items can have multiple id's associated with them...ID1, ID2, ID3.
I want one of every item, but only ID2 if ID1 is...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23545658.html
