I have one table and column is c1 pk, c2 not null,c3 not
null and 200 row in it and i add c4 column and value, how
can is possible
- 9 Answers
- 9607 Views
- I also Faced
- E-Mail Answers
Answer Posted / shaik
u can alter the table. after that u can add the data
depending upon the criteria condition.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
If a cursor is open, how can we find in a pl/sql block?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is before and after trigger?
what is self-join? : Sql dba
does sql support programming? : Sql dba
What is AUTH_ID and AUTH_USER in pl/sql ?
Why do we use joins?
How is data stored on a disk?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What is sqlca in powerbuilder?
Why join is faster than subquery?
What is trigger in pl sql?
Is left join same as inner join?
What jobs use sql?
