Interested to Buy Any Domain ? << Click Here >> for more details...
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
3 8510I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
1 3341how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
TCS,
2 4939you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
2 5715what's query optimization and without use of IN AND Exist can we get another way data from query
2092What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
3 5081write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
KPIT,
1 4451write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
TCS,
4 6881Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
1 3856Post New Oracle General Questions
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is the sql query to concatenate column values from multiple rows in oracle?
What do you mean by redo log file mirroring?
What are the types of partitions in oracle?
How to check the oracle tns settings?
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'));
How to connect the oracle server as sysdba?
What is pragma autonomous transaction in oracle?
Explain the use of grant option in imp command.
List out the types of joins.
What is the best way to do multi-row insert in oracle?
How remove data files before opening a database?
can u plz provide me oca sql dumps please i need them
How can I see all tables in oracle?
