General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
The column is define as allowing NULLS
The insert is something like :
INSERT INTO mytable(oneval, twoval, oneday) VALUE(lc1,lc2,ldate)
I run this and copy the output to the cliptext. It comes back with only the values of lc1 and lc2.
Like (“firstval”, “secondval”
that’s all it reads, not even close parentheses.
I declare ldate as I showed you before NVL(ldate, NULL) so that if it is null I want to insert a NULL.
I use what I have in the clipboard adding the NULL like this:(“firstval” “secondval”,NULL) and it runs
that's why I thought I needed to send a something to the sql sever.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only