hello guys, what is the FNDLOAD commands to download and upload value sets from one instance to another ?
Question
Oraask Latest Questions
Question
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
Question
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 = ...
Question
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 ...
Question
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.
Question
How do I validate email address in JavaScript?
Question
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 ...
Question
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
Question
Hi , I have the below query where am using TRUNC on the column2 filed which is increasing the performance delay. so need to avoid the TRUNC on this check and need to use BETWEEN operator. Here SYSTEMDATE is the currentdateandtime. So how can ...
Question
Hi, I need a sample for using sys_connect_by_path in sql query please regards,