GeekInterview.com
  I am new, Sign me up!
 

Oracle SQL FAQ


Oracle SQL FAQ

Questions: 202
Comments: 669
 Oracle SQL FAQ Tags
 Showing Questions 41-50 of 203 Questions
<< Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
 Sponsored Links

 
 Oracle SQL FAQ
Sorting Options :  

How to display time with sysdate? 
Latest Answer: select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') from dual ...

How to desc table data without using desc command 
Latest Answer: select column_name name,data_type typefrom user_tab_columnswhere table_name = ...

How to print the number of columns in a particular table also the column names without using JDBC Result set meta data using pure SQL code. 
Latest Answer: select count(column_name),column_name from user_tab_columns where table_name='tablename'; ...

How to get field names from empty table by using SELECT statement; 
Latest Answer: SELECT   cnameFROM   COLWHERE   Tname ='EMP'/*Any table can be used here*/; ...

How many types of databases are there? What are they? 
Latest Answer: These days when we talk abt database we are mainly talking about 2 databases  namely : Analytical DatabaseOperational DatabaseAnalytical Database : Like OLTP( On Line Analytical Processing) are primarily static, read only database which store historical ...
Read Answers (1) | Asked by : pavuluri

In which manner the SQL commands access the data from database? 
Latest Answer: Accessing data from a database depends on its implementation.consider the follwing statement select empname from emp where empid=100;(Oracle)1:first the server process of oracle checks whether the data is present in the dbbuffer cache2:if not ...
Read Answers (1) | Asked by : pavuluri

How data is stored in database? 
Latest Answer: Data in database is logically stored in table space and physically stored in data files of database. ...
Read Answers (3) | Asked by : pavuluri

Can you provide any security for SQL queries? If Yes, How? 
Latest Answer: thru views,or stored procedures so that the underlying query is abstracted ...
Read Answers (1) | Asked by : pavuluri

What is the disadvantage of using "BETWEEN" for date feilds 
Latest Answer: It won't work to selecting data in between months ...

What is the difference between SQL & PLSQL? 
Latest Answer: Sql is a non procedural language i.e. we  say what to do not how to do . Oracle sql engine itself decides how to do.Where as pl sql is procedural language. We write program logic and control the execution sequence. ...

View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape