I know there is no Update-Join statement in PL/SQL. I used to write T-SQL. I have two tables. Alex_Table1
I have come across a query like this in a database: SELECT col_a FROM my_table WHERE nvl(col_b, 0) in nvl(nvl(:arg, col_b), 0)
CREATEORREPLACEPROCEDURE GetEmployeesInDept( c OUTSYS_REFCURSOR) I am having a query related to the above Stored Procedures,
I am trying to write a stored procedure that inserts a row into an employee table.If the department does not exist, that department needs to be inserted into the departments table.I have the following
I am confused as when to go for stored procedures rather than embedded SQL in the code When I googled out, I found out these points
SELECT /*+ PARALLEL(aae,4) */ DISTINCT nvl(aae.voucher_group_id,-1)voucher_group_id, aae.nominal_transaction_amount unit_price,
I need to take cursor fields names from another cursor like this: FOR rec1 IN (SELECT * FROM table1) LOOP
I am creating a procedure in a package. I have updated the specification of the package and then when i am updating the body of the package it shows me the following error.
I have written a simple PL SQL block , i am getting this error Please tell me whats the problem in this block ??
I not family with PL/SQL. Can anyone explain why I can\'t do the following? BEGIN IF TRUE THEN CREATE INDEX TestIndex ON SomeTable (SomeColumn);
加载中,请稍侯......