Yep, Oracle has temporary tables. Here is a link to an AskTom article describing them and here is the official oracle CREATE TABLE documentation. However, in Oracle, only the data in a temporary table is temporary. The table is a regular object visible to other sessions. It is a bad practice to frequently create and drop temporary tables in Oracle. Oracle … Read more
Based on the comments left above I ran this under sqlplus instead of SQL Developer and the UPDATE statement ran perfectly, leaving me to believe this is an issue in SQL Developer particularly as there was no ORA error number being returned. Thank you for leading me in the right direction.
Ok, well, since you didn’t show any code, I’ll make a few assumptions here. Based on the ORA-1461 error, it seems that you’ve specified a LONG datatype in a select statement? And you’re trying to bind it to an output variable? Is that right? The error is pretty straight forward. You can only bind a … Read more
I have fixed the problem, just need to check: and then check: and then use:
You can’t update with a number greater than 1 for datatype number(2,2) is because, the first parameter is the total number of digits in the number and the second one (.i.e 2 here) is the number of digits in decimal part. I guess you can insert or update data < 1. i.e. 0.12, 0.95 etc. Please check NUMBER … Read more
This simply means that something in the backend ( DBMS ) decided to stop working due to unavailability of resources etc. It has nothing to do with your code or the number of inserts. You can read more about similar problems here: http://kr.forums.oracle.com/forums/thread.jspa?threadID=941911 http://forums.oracle.com/forums/thread.jspa?messageID=3800354 This may not answer your question, but you will get an … Read more
BLOB : BLOB (Binary Large Object) is a large object data type in the database system. BLOB could store a large chunk of data, document types and even media files like audio or video files. BLOB fields allocate space only whenever the content in the field is utilized. BLOB allocates spaces in Giga Bytes. USAGE OF BLOB : You can write a … Read more
Try replacing the string literal for date ‘1989-12-09’ with TO_DATE(‘1989-12-09′,’YYYY-MM-DD’)
There is no combination of LIKE & IN in SQL, much less in TSQL (SQL Server) or PLSQL (Oracle). Part of the reason for that is because Full Text Search (FTS) is the recommended alternative. Both Oracle and SQL Server FTS implementations support the CONTAINS keyword, but the syntax is still slightly different: Oracle: SQL … Read more
Just add a new datafile for the existing tablespace To find out the location and size of your data files: