How to delete multiple tables at a time? E.G like c* means all the tables starts with C have to be deleted at a time.
As per my knowledge we cannot use Regular Expressions with drop stmt. You can delete multiple tables in a single statement by separating them with a comma.Ex:mysql> show tables;+--------------...
There is no way to delete multiple table at a time.You can just drop a single table at a time.Syntax: table name.
Evaluate this query?Select e.Emp_id from emp@wing e; what is "@wing" ? Is it a partition on emp table or a constraint on table emp?
Its a DB link which is used to access tables which reside on another server.From the above query you are trying to access emp table which is in "WING" schema.WING being on other server.
It is connection string
What are the different types of joins and explain in brief how to use them ?
Hi shravanam,Wht is this u r wrong?Non-Euqijoin : Join more than one table with other than equlity operator (i.e. BETWEEN ... AND....)
Join is a query which retrieves related columns or rows from multiple tables. Self Join - Joining the table with itself. Equi Join - Joining two tables by equating two common columns. Non-Equi Join - ...
(i)a table is classfied as a parent table and you want to drop and recreat it .How would you do this without affecting the children tables?(ii)you want to group the following set of selected returns ,what...
i. YOU CAN NOT DELETE A PARENT TABLE WITHOUT DELETING CHILDREN TABLES. BUT VICE VERSA CAN TAKE PLACE.II. IF YOU HAVE ITEM CATEGORY THEN U CAN HAVE GROUP BY EXPRESSION ON ITEM_CATEGORY.III. DELETE FROM...
(1) use cascade option in query
What is a mutating trigger error? How can we resolve it?I need this reply asap. Thanks
See, in oracle to maintain read consistency oracle keeps a copy in undo section of database for the data which is under modification by some transaction. And so readers do not wait for writers and ca...
In before update/delete trigger if we use select statement for fetching the records.in this scenario will wet mutating trigger error.using row level trigger we can avoid instead of statement level trigger. we can accurate results.
Hi,can u write a function without a return statement.Please quickly send answer.Plzzzzzzzzzzzzzzz.
NO YOU CANNOT WRITE A FUNCTION WITHOUT RETURNING A VALUE.IT SHOULD RETURN ATLEAST ONE VALUE.........WITH REGARDS,SHARAT
No, we can not write a function witout a function
Dear 1 simple qustion is how I can get out put likescott's sal is 2000becoz ' is special char I can not pipe it with enameasename||'scan we use escape sequence but I know that escape seq is only 4 % and...
TRY THISSELECT ENAME||' ' ' '||'S' FROM EMP:
You just need to do this: ename||'''||'s'.
If ename := 'Scott', the output is Scott's.
What is the SQL command for retrieving a procedure or a function from the database.
SELECT TEXT FROM USER_SOURCE WHERE NAME='PROCEDURE/FUNCTION/PACKAGE/PACKAGEBODY'/
USER_SOURCE data dictionary view describes the text source of the stored objects owned by the current user wether it is procedure or function. Its columns (except for OWNER) are the same as those in All_source data dictionary view .
Rownum is used to get tha top-n values. What if I want to know the value at specific position?Ex: a table emp has two columns e_name and e_salary. How can I list the e_name of the employee who is getting...
select e_name,e_salary from emp where e_salary=(select min(e_salary) from (select e_salary from emp order by sal desc )where rownum<4;
I think we can also use this:select emp_name from from where rownum=3 order by salary desc
Write down a query for inserting 'n' rows into a table, prompting for the values each time a record is inserted
SYNTAX:INSERT INTO VALUES('&COLUMN1'(STRINGS,DATES),&COLUMN2);EXAMPLE:INSERT INTO EMP VALUES('&ENAME',&EMPNO);
insert into table_name &column1,..... values (.......);
insert into emp (emp_name,emp_id) values('&emp_name','&empid');
What is report customization? What are the triggers used ?
what harsha said is right.in addition to the above reports there are 3 more triggers1. VALIDATION TRIGGERS2.FORMAT TRIGGERS3.ACTION TRIGGERS
Report Customization means taking the orginal oracle report and modifing ( changing layout, query- by adding some more field....) according the user requirement.There are 5 types of report triggers1)B...
1. Why the performance of the table is degraded when more index is created on the table......2. Whats the main usage of synonym other than that of creating other names to objects....3. Shall we able to...
1. When you create more indexes on a table , for example table A has 10 columns and you have create 8 indexes on that table. Then whenever you r going to retrieve data from that table each row o...
3.If we have the null values in the column then we can not create primary key trigger on that column.4. It is an event that raised implicitly when you update the table.Regards,Sushma
What is the basic difference in function and store procedure.Where we use function and where we need to use store procedure.Could you please explain me in brief.
procedure wont retrun any value but it can return many values on condition. but function always returns a values
A procedure is used to perform a specific task. It can also return a value but its not mandatory.But a function is used to perform some calculations and it is mandatory to return atleast one value.
Can you explain what is dual table in Oracle ?
Dual is default table in oracle .it contains single row and single column.All the Character functions and number functions and date functions execution done in this Dual table.
Dual is a dummy table which has one row and one column but can't make the DML opertions.
Syntax for getting the table witout any contents
create table emp as select * from student where 1=2;
select * from faculty where rownum=0;
What is the difference between primary key and aggregate key what is the difference between varchar and varchar2?
In varchar u can store upto 2000 bytesIn varchar2 u can store upto 4000 bytesIn Oracle even if u declare a variable with varchar it takes varchar2 into consideration and creates that variable with varchar2
Varchar and Varchar2 is different.Varchar and varchar2 store is 2000 char.
varchar2 size is automatically reduce. It will take on using char size based.
How do you remove a column from table
You can remove a column but first of all you should see that column doest have any values and it should not be a primary keyALTER TABLE DROP COLUMN
To drop a Column from a Table.The command is.Sql>Alter table
BPO Career for BTech Graduates
Has anyone asked you for help? What did you do?
What do you do when things do not go as planned? Cite an example.
What are my options when I do not get a job after graduation?
Career Options for BCA Graduates
What is the role of a mechanical engineer in the Software Industry?
Have you gone above and beyond your job description?
Describe a time when you had to work under pressure.
How to Overcome Employment Gap during interview.
What was the most important decision you ever had to make?
Ask Interview Question?
Have Career Question?
Ask Only Career questions.