Stored procedure for inserting a constant plus values from another table?
INSERT Table2 (Col1, Col2, Col3) SELECT T1Col1, T1Col2, 'Something' FROM Table1.
Lol – Neil Knight Nov 9 '10 at 12:29 1 @Ardman - it's a little bit frightening... – Paddy Nov 9 '10 at 12:30.
INSERT Table2 (Col1, Col2, Col3) SELECT T1Col1, T1Col2, 'Foo' FROM Table1.
Thank you! Marked Paddy's answer as accepted. He was 30 secons earlier :) +1 – rem Nov 9 '10 at 13:32.
This procedure closes a BFILE that has already been opened through the input locator. This procedure closes all BFILEs opened in the session. This function finds out if a given BFILE locator points to a file that actually exists on the server's file system.
This procedure determines the directory object and filename, given a BFILE locator. This function only indicates the directory object name and filename assigned to the locator, not if the physical file or directory actually exists. The maximum constraint values for the dir_alias buffer is 30, and for the entire path name, it is 2000.
This function finds out whether a BFILE was opened with the given FILE locator. If the input FILE locator was never passed to the FILEOPEN procedure, then the file is considered not to be opened by this locator. However, a different locator may have this file open.
In other words, openness is associated with a specific locator. This procedure opens a BFILE for read-only access. BFILE data may not be written through the database.
This procedure deletes the data at the specified offset for the given length from the LOB without having to rewrite all the data in the LOB following the specified offset. This function inserts the given data (limited to 32K) into the LOB at the given offset. This procedure moves the amount of bytes (BLOB) or characters (CLOB/NCLOB) from the given offset to the new offset specified.
All offsets are pre-move offsets. Offsets of more than 1 past the end of the LOB are not permitted. This procedure replaces the data at the given offset with the given data (not to exceed 32k).
Invoking this procedure is equivalent to deleting the old amount of bytes/characters at offset and then inserting the new amount of bytes/characters at offset. This procedure frees the temporary BLOB or CLOB in the default temporary tablespace. When a new temporary LOB is created, and there is currently no temporary LOB in use with the same duration (session, transaction, call), a new temporary LOB segment is created.
When the temporary LOB is freed, the space it consumed is released to the temporary segment.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
What is 7 plus 7 plus 7 plus 7 plus 7 plus 7 plus 7 plus 7 plus 7 plus 7 plus 7 plus 7 plus 7 plus 7 equals?
How to call a stored procedure from another stored procedure in oracle?
Getting value from stored procedure in another stored procedure?
Stored Procedure runs slowly when being called from another stored procedure?
How to get the output value from stored procedure from another stored procedure in a tabular format?
Can I add values to a MySQL table via a form based on a match between values in a textbox and values in a column in the table?