arumurali
Last Activity: Mar 18 '13, 06:13 AM
Joined: Mar 11 '13
Location:
-
Ohh Fine Fine,...Thanks for your valuable instructions r035198x..!! -
Yep not a bad idea but it has 100 rows with data's and it is so tedious to manually insert it again. So m searching for an alternative one, if no other option is left that's the only way left i guess :(Leave a comment:
-
No actually numbers are only present with only two numbers in each field. The data's are transferred from another source through a middle-ware Tuxedo. This type of imports mainly causes change in data type. So could u help me out of this?Leave a comment:
-
Datatype cannot be changed in table
I tried using the command alter table. But it is throwing the error as the datatype must be null to change the datatype. As i am trying to change the datatype from char(50) to NUMBER(2,0). As far as my searching in google, It is asking to drop the column and reinsert if yu need to change the datatype. It contains over 1000 datas. now i am really confused how to change the datatype to proceed further. Your idea or solution is highly appreciable.... -
That was much helpful rski..
Thanks for your time..!!Leave a comment:
-
So oracle defines cursor by default is what i got..Is that rite rski..?Leave a comment:
-
Thanks for the clear cut answer dude :)Leave a comment:
-
IN parameters are passed as constants from the calling environment into the procedure.
OUT parameter values are returned from procedure to the calling environment.Leave a comment:
-
Thanks rski..!!
But when we write a procedure we usually create a name and obviously it becomes a stored procedure rite..??Leave a comment:
-
My doubt is a silly one but Thanks for your time rski..!!
I don't have any problem in compiling procedures, but my problem is compiling procedures, functions in a different way by initializing a variable and then getting the output. It makes me feel kindof uncomfortable.Leave a comment:
-
Thanks for your response friends.
@rski--> Again my doubt is can't we use procedure to fetch data from the table, is cursor a necessary one to go?Leave a comment:
-
Just try months_between to get the exact details.Leave a comment:
-
In PL/SQL what is a difference between a cursor and a reference cursor?
As of my my knowledge, Cursor is used to process SQL statements in private area and we can use it further. A Ref cursor is defining a cursor at the spot where it is needed.Correct me if i am wrong.. -
How to execute a small piece of code in Toad?
I have a procedure with thousands of lines in it. I just need to change a specific code and execute the particular piece of code instead of executing the whole program. Can anybody help me out in this..?? -
Leave a comment:
-
GRANT your created workspace to user;Leave a comment:
-
Executing a procedure
Executing a procedure is a tedious process i ever came across. Why can't we just run a procedure instead of declaring a seperate variable and compiling them for results. Every procedure is compiled in a different way according to the needs, what can be done for this? -
Difference between a stored procedure and a procedure?
Whats the exact difference? -
Why are we going for cursor, can't we use procedure instead?
Yes I know cursor is a private area where SQL commands are executed and we can use them for further use. Even the procedure is used to perform an action and it may or may not return a value. Also, i have heard that using cursor makes the process slow. Can anyone help me out on this?
No activity results to display
Leave a comment: