Answer Posted / arkchowdary
we use Dept table or Any table Insert Command
Insert into dept(Dname,deptno,location.....)values
('Darway',30,'Sweadon');
Or
Insert into dept values('&dname',deptno,'&location'....)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the simplest tool to run commands on oracle servers?
Explain rename?
Explain what are synonyms used for?
Is oracle an open source?
What are nested tables?
What is the difference between "as" and "is" in an oracle stored procedure?
Is there a function to split a string in plsql?
How do I connect to oracle?
What are a collation and state the different types of collation sensitivity?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How many types of table in Oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to load excel data sheet to oracle database
What is the maximum limit on the number of columns in a table?
What are the various oracle database objects?