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
There are many fine ways to get this done, which others have already suggestioned. Following along the “get Excel data via SQL track”, here are some pointers. Excel has the “Data Connection Wizard” which allows you to import or link from another data source or even within the very same Excel file. As part of Microsoft Office … Read more
A simple solution would be doing something like this:
You typically only use an alias for a table name when you need to prefix a column with the table name due to duplicate column names in the joined tables and the table name is long or when the table is joined to itself. In your case you use an alias for VCustomer but only use it … Read more
Since the suggestion of a loop implies the request for a procedure type solution. Here is mine. Any query which works on any single record taken from a table can be wrapped in a procedure to make it run through each row of a table like so: First delete any existing procedure with the same … Read more
There are two formats of case expression. You can do CASE with many WHEN as; Or a Simple CASE expression Or CASE within CASE as;
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
You are using a transaction; autocommit does not disable transactions, it just makes them automatically commit at the end of the statement. What is happening is, some other thread is holding a record lock on some record (you’re updating every record in the table!) for too long, and your thread is being timed out. You … Read more
I found the answer. The problem was that I have to precede the table name with the schema name. i.e, the command should be: Thanks all.
Try replacing the string literal for date ‘1989-12-09’ with TO_DATE(‘1989-12-09′,’YYYY-MM-DD’)