1,135 Topics
 | |
 | Hey, [CODE] CREATE OR REPLACE TRIGGER "TRI_AMOUNT_REDUCTION" AFTER INSERT ON "PURCHASE" FOR EACH ROW BEGIN IF (:NEW.CLIENTNO = 122336) THEN :NEW.AMOUNT := AMOUNT * 0.1; END IF; END; / [/CODE] I have a query that selects my top client then want to pass the clientNo to the trigger. Is it … |
| | Hi, i have 3 tables in oracle sql developer (packing, detail, header). I need to update the packing table's part no with header table's part no. But header doesn't contain the serial id hence i need to refer to detail table for cross reference. I did like below, but it … |
| | |
 | HI Guys These days I am checking whether amount is correctly upload into one of our table its located in oracle database below query used to check this . Select * from Amount_Paiad where CusID IN ('34343','34343','090094') There is no issue in query.Problem is how many values I can enter … |
| | hello everyone... could anyone tell me how to store images in oracle database..or which datatype has to use for it.. |
| | Anyone know how to install Oracle Sql developer on Mac? |
| | |
 | [URL="http://www.youtube.com/watch?v=b-Cr0EWwaTk&feature=player_embedded#!"]An Oracle produced song to promote Java; fun stuff[/URL]. ;-) Lyrics at: [url]http://www.adam-bien.com/roller/abien/entry/code_hard_with_java[/url]  |
| | Hi everyone, I've been trying different commands that check inputs that will be entered into the tables I've got. I want to check that Amount/Ename columns can not be NULL. What's <> do in SQL? [CODE] // first command ALTER TABLE Emp ADD CONSTRAINT CK_AMOUNT CHECK ( AMOUNT NOT NULL); … |
| | |
| | Hi friends I have a question about savepoint The SQL statements executed in a user session are as follows: SQL> CREATE TABLE product(pcode NUMBER(2), pname VARCHAR2(10)); SQL> INSERT INTO product VALUES (1, 'pen'); SQL> INSERT INTO product VALUES (2,'pencil'); SQL> SAVEPOINT a; SQL> UPDATE product SET pcode = 10 WHERE … |
| | Hi guys, I need some help from you. I know it's lame to ask for help for college, but for oracle databases we have a professor that really doesn't know how to explain anything. We are learning it all theoretically and nothing practically and now he gave us a code …  |
| | i have a query is to lookup CREDIT_CARD table using CREDIT_CARD_ID and get the MIN_REPAY_AMT. if SUM(AMOUNT_DEPOSITED) < MIN_REPAY_AMT for that month Then populate 1000 else 0 i have attempted the query below kindly help me out and i am getting the following error. Error: [CODE]ERROR at line 2: ORA-00923: … |
 | Provide a list of Students in zip code 11214 that registered more than 2 days after their student record was created. what i have so far right now i have it where it checks for if created date after registration date just can't figure out how any points in the … |
| | how to call oracle report using form builder on which command button.If i press command button report should be run. |
| | This is homework. Here is the problem: Produce a list of employee last name, first name and department name. Use appropriate, user friendly column aliases. This is from the tables [ICODE]DEMO.EMPLOYEE[/ICODE] and [ICODE]DEMO.DEPARTMENT[/ICODE]. The relevant column names are [ICODE]LAST_NAME, FIRST_NAME, DEPARTMENT_ID[/ICODE] (from [ICODE]DEMO.EMPLOYEE[/ICODE]) and [ICODE]DEPARTMENT_ID, NAME[/ICODE] from [ICODE]DEMO.DEPARTMENT[/ICODE]. As you … |
| | Hi, I'm trying write a sql statement that will: show all employee id , name, their wages and the project they are doing if their wage's are greater than average wage. The wage is calculated by the hourly rate which is located in allocation table and hrsworked which is located … |
| | This is probably obvious to someone who is familiar with Oracle, however, I'm writing a script file for a class, and it throws an error on the line [CODE]ALTER TABLE FACULTY ADD CONSTRAINT FACULTY_Locid_fk REFERENCES LOCATION;[/CODE] where the table is FACULTY, the column is Locid, and I'm trying to create … |
| | [code]select a.div_amt_alloc , b.payment_dt , substr(c.stk_desc,1,38) from noth_stock_alloc a , nomh_announcement b , comh_counter c, comh_client d where a.ann_num = b.ann_num and substr(a.ann_num,5,1) = 'C' and b.stk_cd = c.stk_cd and a.client_cd = d.REM_cd and rtrim(d.rem_cd) = 'ABC' and B.payment_dt between to_date('01/08/2009}','dd/mm/yyyy') and to_date('31/08/2009',''dd/mm/yyyy'')' order by b.payment_dt;[/code] those query will show … |
 | I have to design a database where one requirement says "For each project, for each user, for each skill, store the marks gained". Initially, i had a table where each skill was a column(proj_id, user_id, skill1, skill2, ......., skill_N) I felt this was a bad design because the number of … |
| | hi. I'm working with php-oracle and I need to do a query that I know will return a unique string, but when I execute the query all that I recieve is a number. Why? this is my code: [CODE] $nombre=oci_parse($conexion, "select nombre_cliente from cliente where cod_cliente=$codigo_de_cliente"); $nombre_de_cliente=oci_execute($nombre); [/CODE] nombre_cliente is … |
| | Just unsure regarding which data type can store data such as multiple language codes e.g. English:EN, Chinese:ZH, Malay:MS and even more in such a format(EN,ZH,MS), is LONGVARCHAR an option??? |
 | Its providing me error................................ [code] insert into products_information values(1,to_timestamp(current_timestamp,'DD-MON-YYYY HH24:MI:SS'),1200,10,1000,12,1100,10) / ERROR: date format picture end before converting entire input string.... [/code] This is making me nuts... Please Help a bit.... |
| | hi. I need to create a table, but I want to set three forgein key each one of different tables. Is that posible to do with oracle? |
| | i have two products , product one has 5 entries of date and product 2 has 4 entries. I want to select max date entries of both... [code] select max(entrydate) from products,products_information where products_information.pno = products.pno [/code] It return a single max date of one product.... Please Help .............. |
| | Hello My task is to write a procedure which has to get information about price of a product and updates the data base for produc_id=777. if product_pirce < 400 then product_price=500 if product_price > 400 then product_price=300 IN PL/SQL: [CODE] create or replace procedure change_price is begin if (select price … |
| | I am looking for query to select the last row of a table. Please help. |
| | Hi, I have a java appllication which has a query depending on the requirement, select EmployeeID, TransactionAmount from employee where EmployeeID IN ('E123','E234') group by EmployeeID; which works well in mysql, but for oracle a get an error like [Err] ORA-00979: not a GROUP BY expression Can anyone help me … |
| | Hi, i work with SQl Navigator and Oracle and i want to buy Mac laptop, but i am not sure if Oracle 11g is going to Work in Mac. So the question is: If SQL navigator 6.2 and Oracle 11g can work in Mac OS. Thank you. |
| | Hi, I have a select statement and I need to find a way to apply a filter to it: [CODE] select * from my_table where my_table.field_1 like :filter_item [/CODE] The real problem is that filter_item can be a string, a string that includes '%' or a comma-separated string that can … |
The End.