How to define a variable to match a table column data type?
No Answer is Posted For this Question
Be the First to Post Answer
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
What is the scope of a local variable?
How to create a temporary table in oracle?
How to drop an existing table in oracle?
Explain the use of Merge statement in oracle 11g
What are synonyms used for ?
What is rowid and rownum in oracle?
What is a subquery in oracle?
How to define a data source name (dsn) in odbc manager?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is set verify off in oracle?
why pl sql doesn't support retrieving multiple records