I want to pop up a message for numeric value. It seems the message statement only accept char value, not num value. How can I do that?
For example, I have the following message statement bu...
i have three tables stbPreference, stbPreferenceType and tbCustomerPreference. Please look at the image provided. Now, i need to insert a row to stbPreferenceType table and stbPreference table...
I need to create a procedure that will take any length numeric integer value and convert it to 3 significant digits.
for example: 12345 will be reported as 12300, 123456 will be 123000 ...
the below query is relatively slow - takes about 20 seconds irrespective of how much data I get back. what can I do to optimize it ? there is an index on business_code. I tried to do a self jo...
New to Oracle SQL here so need some quick syntax update.
I would like to do the following.
Create a temp table name tableAlpha
Create a cursor from a select statement
Open the cursor a...
Hello all,
I have an update statement in my stored proc that is attached here in the code blob.
The three date params coming in are just that date type fields. What I am going to do is ...
Hello Experts; I am trying to write a query that will do the following.
I have a single table with the following structure:
Acct# Line Amt
100 1 100.00
100 2 105.00
100 3 ...
Hi, the following query gives the error: "ORA-00979 not a group by expression"
I think I am making a trivial mistake but couldn't figure out. I'd be glad if you could help.
Thanks
I have a select query that joins multiple tables. I am able to do a select * to display all the columns of all the tables. But I need to add an additional column that does some calculation, li...
Procedure cnmae (cn in cust.cnum%type) is
n cust.lname%type;
begin
select lname into n from course where cnum = cn;
if (sql%found) then dbms_output.put (n);
else dbms_output.put...
I need help putting a view together for this any help would be much appreciated.
This is what I am trying to get. I have three tables:
CUSTOMER
COUNTRIES
CUSTREGISTRATION
There is ...
Would like to test if ra.rev_code is one of these revenue codes ('651','652','655') before the loop is called.
Hi, how can i show 0 values in the following querie to make the maths work?
Hi
i am pretty new in Oracle.
i have a procedure i wrote in SQL SERVER and i need to write it in ORACLE , and i start and it is not compiled.
CREATE OR REPLACE PROCEDURE P_CheckDelMain
...
Looks for help to create a query that would perform what is in the image. The top part of the image is an example of the raw data in the DB, the lower part is how I would like to transform th...
I have a table with 100 rows.
I want a oracle update statement; that update's 10 rows on the table at a time.
These 10 rows should be unique in the sense, it should not have appeared i...
Hi Experts,
I am trying to run this simple query:
Its throwing the error shown in question title.. what am I doing wrong here?
I using ORACLE 11 g
I would like to output this input into child parent order. See the desired output results below:
Source
Print Order Level Description ...
Hi,
How can I select the latest price for items? I have the following querie and it is not quite working. Every month the prices are calculated for items and if I use the date that the last...
I have a set of data in the following format:
Class Code Start_Date End_Date
1 A 1/1/2009
1 A 1/15/2009
1 B 1/29/2009
2 A 1/15/2009
2 A 2/12/2009
2 D 3/10/2...
In my package body, I've defined the function to receive the following variables:
...
orgncode1 IN VARCHAR2 DEFAULT NULL,
orgncode2 IN VARCHAR2 DEFAULT NULL...
I have a query that derives some stats and displays results in a table as abelow.
Is it possible to use analystics or SQL to add another derived row that is based on the two values on the...
1. Do the contents shown in the link adequate and good enough to be applied/implemented to real-world database project?
http://www.learningdom.com/lms/course/info.php?id=10
Note: hands-o...
Have a PL/SQL statement like
EXECUTE IMMEDIATE 'select username from dba_tables where table_name = upper(aTable)' into v_tablename;
aTable is a variable that is passed in. Thancompiler compl...
I am trying to accomplish something like this:
Dell Desktop V305
- Model: Black - 23877487y24y
- Mother Board - Intel ....
- RAM - 3 GB DDR
HP Printer
- Ink Jet C 7770
- 4 Catridg...
