Posted
by Vineet
on Stack Overflow
See other posts from Stack Overflow
or by Vineet
Published on 2010-04-01T09:48:05Z
Indexed on
2010/04/01
9:53 UTC
Read the original article
Hit count: 193
hi, I want to find the size of any data type in pl/sql,for eg DECLARE x boolean;
I want to find size of like X,is there any function like (sizeof() in C) or any how i can find it.Please let me know!
© Stack Overflow or respective owner
as seen on Server Fault
- Search for 'Server Fault'
When I rut the following:
set ORACLE_SID=orcl
exp.exe 'SYS/system as sysdba' full=y log=exp.log file=mydump.dmp
in the end i see the following:
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
what should i do to resolve…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi Following is the syntax for creating table in mysql.
I want to create table with same properties in oracle9i.
Can anyone provide me the equivalent syntax for oracle?
CREATE TABLE IF NOT EXISTS "tbl_audit_trail" (
"id" int(11) unsigned NOT NULL,
"old_value" text NOT NULL,
…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello,
I've a cube olap created with oracle9i, and I want to do some queries on this cube using a java application, but the problem is: how can I connect the java application with the cube olap.
thanks for your help
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I am in a development environment, and our test Oracle 9i server has been misbehaving for a few days now. What happens is that we have our JDBC connections disconnecting after a few successful connections.
We got this box set up by our IT department and handed over to. It is 'our problem', so options…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Getting this error when executing SQL Server query only when connected via remote Desktop.
When running the query from desktop, no problem. Is this a tsnNames issue?
Linked server to Oracle 9i
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error:
TITLE: SQL Server Setup failure.
SQL Server Setup has encountered the following error:
…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure.
How can I do this with detection code written in SQL?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Here is the query:
INSERT INTO @TempTable
SELECT UserID,
Name,
Address1 =
(SELECT TOP 1 [Address] FROM
(SELECT TOP 1 [Address] FROM [UserAddress] ua INNER JOIN UserAddressOrder uo ON ua.UserID = uo.UserID WHERE ua.UserID = u.UserID
ORDER BY uo.AddressOrder ASC) q
ORDER BY AddressOrder…
>>> More
