Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
which approach is do better performance do bulk insert by using insert from select or Cursor for loop ? for example : [code] DECLARE CURSOR Test_C IS SELECT * FROM test_table1; BEGIN FOR Test_C_REC IN Test_C LOOP INSERT INTO test_table2(col1, col2, col3) VALUES (Test_C.col1, Test_C.col2, Test_C.col3); END LOOP; END; [/code] or a simple select, like: [code] INSERT INTO ...
hello, I need query to get all packages , procedures and functions in my oracle database thanks in advance
hello guys, what is the FNDLOAD commands to download and upload value sets from one instance to another ?
for example I have one table with unique constraint on ID column and it has values like this : ID Name 1 test and I want to catch and handle unique constraint exception. thanks
I have a query and I want to use if statement inside where clause like this : [code] SELECT e.first_name, e.last_name, e.status FROM employees e WHERE IF status_flag = STATUS_ACTIVE then e.status = 'A' IF status_flag = STATUS_INACTIVE then e.status = 'T' IF source_flag = SOURCE_FUNCTION then e.business_unit = ...
I have a requirement to validate an JSF/ADF input field only if the value of that field changed by users. If the value on the page is the same as the value in the model, skip validation for that field. I ...
hello, I'm using Oracle 10gR2 and i want to know what's the differences between both because I take a look at the documentation and i find out there no differences. any suggestions will be appreciated.
How do I validate email address in JavaScript?
How to check there is object inside an array in javaScript? What is the efficient way to find out if a JavaScript array contains an object? This is the only way I know to do it: [code] function contObj(array, obj) { for (var i ...
I have a test_table with the following data : [code] select * from test_table; [/code] Number Name 1 AA 1 DD 2 QQ 3 WW 4 EE
