I'm trying to copy a view from one database to another. I'm exporting the view using 'Quick DDL > save to worksheet' to generate the script. At the top of the script i get the message:
"-- Unable to ...

I am currently trying to create a search box with multiple search options within Visual Studio 2013 but as i am new to this i have come across something i really am unsure on how to continue.
I have ...

I want to generate random Numbers in Oracle 11g. But due to client request, I cannot use dbms_random.random of Oracle.
Is there any other way I can generate random numbers?
Duplication are strictly ...

I have been searching all morning for an answer to the following question (please excuse me if this is a repost but I am really getting crazy with this issue).
I have the following table of relations ...

i have one requirement to "select all rows from fund table whose own fund_id is not found as replacement fund_id on other rows in fund table".
every fund record is having history record created with ...

When I'm working in a Worksheet in Oracle SQL Developer, the Home and End keys jump me to the beginning and end of the whole Worksheet respectively, not the beginning and end of the current line. Is ...

I have an Oracle form with many database data-blocks on it. Sometimes, users open the form and start entering the data. Meanwhile, a process is automatically run and updates the values in the tables. ...

I am having trouble establishing connections with tnsnames.ora while using SQL Developer 1.5.4. I have looked at other threads on this site and they have told me to go to Tools> Preferences > Database ...

I have a function defined that returns a sys_refcursor containing 5 text columns. Sorry, I cannot post the contents of it here for business reasons. The columns are casted to varchar2 with specific ...

Usually we use Select function(param) from dual to retrieve a value from function. I am trying to get a value from a function in a stored procedure in oracle. But it's getting Syntax error. The code ...