Hey, I\'m trying to create a trigger in my Oracle database that changes all other records except the one that has just been changed and launched the trigger to 0. Because I am updating records in the
this is my first attempt with Oracle I would like use foreign key. First I create some table, with autoincrement ID:
new to oracle, I am having a oracle DB which we don\'t use anymore开发者_如何学运维(version : 8.1.7.4).
i am getting that error always listner going down.then again i restart the database. please give me solution开发者_C百科.
Office 2010 causes MSQuery to crash when running a big query like this: SELECT TRANSACTION_DETAIL.ACCT_ID, TRANSACTION_DETAIL.ACCT_DESC,
I want to create a GUI in Oracle form 10g, the purpose of creating this page is : -user able to upload & see uploaded file(upload into ftp)
I\'m trying to check if a value from a column in an oracle (10g) query is a number开发者_C百科 in order to compare it. Something like:
TYPEemp_type_rec IS TABLE OF employees%rowtype INDEX BY BINARY_INTEGER; When we define an array, why is it indexed b开发者_高级运维y some datatype?Because you have a choice of data types to index by
I have a homework assignment in SQL for Oracle 10g where I have to apply union to two different select statements, to return two columns. I need the values of each cell under vendor_state to indicate
When I issue this select statement in the Oracle web console it returns all the rows 开发者_运维知识库in the table:
加载中,请稍侯......