I am new to SQL and I am trying to create the table for itinerary items however keep getting the same error message that I am “missing a keyword”. I have tried looking it up for what is wrong however I can not find anything Any solution or if you have any design suggestions to this would be much a…
Tag: oracle
display details of employees who joined in first march of each year [closed]
Closed. This question needs debugging details. It is not currently accepting answers. Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question. Closed 9 months ago. Improve this question In m…
how to divide each row by the sum of those rows?
I have a table CREDITS with these columns: DAY_OPERATIONAL TOTAL_LOAN CREDITS_PERCENT I should multiply each row’s TOTAL_LOAN and CREDITS_PERCENT then divide to SUM(TOTAL_LOAN) in that DAY_OPERATIONAL. My code is not working. How can I achieve this? How do I need to use group by properly? Answer This is…
How can i grant an execute statment
I want to grant TRIGGERS, FUNCTIONS and PROCEDURES to a role. I have the code to do it with procedure but with triggers and functions it not work. Answer User owns tables, functions and procedures. That user created a role and wanted to grant execute on various objects to the role. for triggers, it doesn̵…
Which is the best practice for allowing users to acces a database from database perspective? One db user vs a db user for every user [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 8 months ago. Improve this question So im planning to develop a test SaaS software for a hobby project, …
How do I find data from this day exactly one year ago in oracle?
Merry Christmas, I am using the below query to get the prices, but my requirement is to get the data for last one year from trunc(sysdate). i have tried using DATEADD function but its gives me an error cast(p.asof as DATE) = cast(DATEADD(Year, -1, GETDATE()) as DATE) Can anyone please help, what all changes i…
How to create the correct trigger instead of insert or update? ORACLE. Trigger. pl/sql
Help create a trigger for a non-updatable view. The tables look like this. The view itself looks like this I tried to create a trigger like this. But for some reason it is not created.( Error at line 86: PL/SQL: SQL Statement ignored Error at line 94: PL/SQL: ORA-00917: missing comma) it seems to me that I we…
What’s wrong with this PL/SQL Trigger?
I have this table, and I want to create a trigger on Magazine, that verifies “after insert” if the name of the Magazine inserted is either Vogue or People. If it’s not one of them, it gets deleted. Table: MAGAZINE (ISBN, MAG_NOM, PRIX_Mois); My trigger: But the problem is my teacher told me:…
Multiple functions calling a same function. I need to create a flag
Multiple functions calling a same function. I need to create a flag. Suppose I have 4 functions(f1,f2,f3 and f4) in a PLSQL package. F1 is being called by F2,F3 and F4. All I want a flag in order to track which function call the F1. For example . If f2 called f1 then flag=2,flag=3 when f3 called f1 and so
trigger created but when executed showing some errors==> ORA-04091:, ORA-06512:, ORA-04088:
I have a table called movie_cast. This table already has duplicate values(#114). act_id, mov_id are foreign keys. And I’ve created a trigger on movie_cast table called trg1. Although the trigger is been created but after execution it shows some errors My task is: I want to allow entries in this table i.…