No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Create a script named *just_lee_trg.sql* that contains the PL/SQL code to create a trigger named *books_qty_on_hand_trg*. The trigger should be set up to fire whenever the quantity on hand for a book has been updated. When the quantity on hand becomes zero, it should call the *insert_reorder* procedure and pass … |
|
I m try to solve this problem Add a column named *reorder_quanity* to the *books* table that will hold a value up to 999 with a default value of 10. 4. Update the reorder quantity of all books to 10. 5. Update the quantity ordered to 1 for all books … |
|
I create a procedure to update table but when I execute to test the procedure with PRINT :g_name_pd show nothing as been change .. Can you guy's help where I m doing wrong Thanks Agaba[code]CREATE OR REPLACE PROCEDURE update_name_pd (p_name IN bb_product.productname%TYPE, p_id OUT bb_product.idproduct%TYPE ) IS BEGIN UPDATE bb_product … |
|
This is my Code #include<iostream> using namespace std; struct BankAccount { int accountNum; double accountBal; double rate; }; int main() { const int ACCOUNT = 5; BankAccount info[ACCOUNT]; int sub; double balTotal = 0; double balAverage; int accountNumber; bool isFound = false; for(sub =0; sub<ACCOUNT ; ++sub) { cout<<"Enter Account … |
|
When i rebuild the program , I get this error 1>c:\users\agaba\documents\visual studio 2005\projects\car\car\school.cpp(97) : error C2447: '{' : missing function header (old-style formal list?) 1>Build log was saved at "file://c:\Users\agaba\Documents\Visual Studio 2005\Projects\car\car\Debug\BuildLog.htm" 1>car - 1 error(s), 0 warning(s) The code .................. [code=cplusplus] // Short-term parking at the airport, from 4am … |
|
When i try to rebuild this what i m geting 1>------ Rebuild All started: Project: depreciationarry, Configuration: Debug Win32 ------ 1>Deleting intermediate and output files for project 'depreciationarry', configuration 'Debug|Win32' 1>Compiling... 1>arry.cpp 1>Compiling manifest to resources... 1>Linking... 1>MSVCRTD.lib(crtexe.obj) : error LNK2019: unresolved external symbol _main referenced in function ___tmainCRTStartup 1>C:\Users\agaba\Documents\Visual … |
|
When my try to rebuild my program i m getting this errors 1>Linking... 1>MSVCRTD.lib(crtexe.obj) : error LNK2019: unresolved external symbol _main referenced in function ___tmainCRTStartup 1>C:\Users\agaba\Documents\Visual Studio 2005\Projects\car\Debug\car.exe : fatal error LNK1120: 1 unresolved externals 1>Build log was saved at "file://c:\Users\agaba\Documents\Visual Studio 2005\Projects\car\car\Debug\BuildLog.htm" 1>car - 2 error(s), 0 warning(s) my … |
|
input qty while qty > 0 input size call Calculate Scrap using 10 to get scrap 10, qty needed for 10 call Calculate Scrap using 25 to get scrap 25, qty needed for 25 call Calculate Scrap using 40 to get scrap 40, qty needed for 40 if scrap 10 … |