Got this question for an exam but getting error from trigger. Please help. Question customer(cust_id,cust_name,address)
I\'m looking for a Hash function in PL/SQL, to get the hash of a varchar. I found a package in Oracle 10 called dbms_crypto with a function dbms_crypto.hash and even other package dbms_sqlhash.getHash
I need to convert in procedure from string to decimal with fixed decimal separator . independant on culture settings. Next, I know decimal number is limited just with 6 decimal places after . and ther
I have run into a problem with a second trigger we are to write regarding the following: I have just written a stored procedure and stored function that serve to insert a new row into my Orders table
I am new to PL SQL Code and need help writing Insert query statement . eg: I want to insert Employee in Employees table where only employee name changes but the city is constant.
i am trying to build a procedure to obtain k nearest neighbor points to a point with a selected ID. I need to do this without using any spatial locator features like sdo_geometry or nn.
enter code hereI\'m working on building a group of functions that return a json string based on the parameters and an internal select.
I am trying to create a trigger to delete articles after it deletes of all of its article contents. I am getting a 1064 error at line 5.
I want to find the size of Table, Data_Space_Used, Index_Space_Used, Unused_Space etc but exec sp_spaceused开发者_StackOverflow doesn\'t work.
I have just written a stored procedure and stored function that serve to insert a new row into my Orders table.The row update inserts: Ordernum,OrderDate, Customer, Rep, Manufacturer, Product, Qty, an
加载中,请稍侯......