From a quick search, Oracle appears to use double quotes (“, eg “table”) and apparently requires the correct case—whereas, for anyone interested, MySQL defaults to using backticks (`) except when set to use double quotes for compatibility.
You can substract dates in Oracle. This will give you the difference in days. Multiply by 24 to get hours, and so on. SQL> select oldest – creation from my_table; If your date is stored as character data, you have to convert it to a date type first. SQL> select 24 * (to_date(‘2009-07-07 22:00’, ‘YYYY-MM-DD … Read more
Assuming a Windows installation, do please refer to this: http://www.oracle-base.com/articles/misc/ManualOracleUninstall.php Uninstall all Oracle components using the Oracle Universal Installer (OUI). Run regedit.exe and delete the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE key. This contains registry entires for all Oracle products. Delete any references to Oracle services left behind in the following part of the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Ora* It should be pretty … Read more
There are two types 12 and 13 http://oraclesniplets.tumblr.com/post/1179958393/my-oracle-support-oracle-database-69028-1 Type 13 select dump(sysdate) from dual; Typ=13 Len=8: 220,7,11,26,16,41,9,0 The format of the date datatype is Byte 1 – Base 256 year modifier : 220 2 – Base 256 year : 256 * 7 = 1792 + 220 = 2012 3 – Month : 11 4 – … Read more
For Oracle Database provide this information: Describe the symptoms of the problem Describe the behavior that cause the problem. Is the behavior of the query stable or does the problem occurs only sometimes, with specific parameters or simple random. Can you reproduce this behavior in an IDE (e.g. SQL Developer)? Describe the environment Define the … Read more
The question is vague. I’m assuming that you are using oracle 10g and above.If you are trying to send mail through PL/SQL, you can use UTL_MAIL package. You can try something like CREATE OR REPLACE PROCEDURE p_test_mail AS var_count NUMBER; CURSOR c1 IS SELECT COUNT(*) FROM nb005 nb JOIN emp_reset_id e ON nb.qteref = qrc.emp_quote_ref … Read more
It is very clear that you are not creating a dynamic query properly. Space is missing between TABLE’|| C.table_name It must be something like this: EXECUTE IMMEDIATE ‘TRUNCATE TABLE ‘|| C.table_name; — see space after TABLE Cheers!!
here lopping through each row and get non-null Comments,Assignee,Case_Info,Users values and return one row Isn’t that simply finding NOT NULL values in plain SQL – SELECT comments, assignee, case_info, users FROM sometable WHERE id = :id AND comments IS NOT NULL AND assignee IS NOT NULL AND case_info IS NOT NULL AND users IS NOT … Read more
As Ranzo notes several of the other answers are are also plausible. So, why is E the correct answer? Because the question asks for the most appropriate location for the code. Let’s break it down. The logic needs to be called from several places. It is therefore necessary to define it as its own function … Read more
I think you want to create a small table of object names and then join, something like: create table objectnames ( name varchar2(100) ); — populate objectnames — could be from a file or another table or whatever insert into objectnames … commit; — query from tables select a.* from abc_table a, objectnames o where … Read more